What function should mysql_result be changed to in order for the code to work?

Question

PHP

I am learning PHP from Nixon's book, and while typing code from it, the IDE started highlighting some functions as obsolete for me, and I decided to try to rework the code to a more relevant one, but unfortunately I could not cope with the problem that is visible in the screenshot.

Answer 1

// You have mysql_result() call in the screenshot, and you are using MySQLi Get
a newer book and open the MySQLi documentation )
This is how it should work (simplified version):

<?php
$db = mysqli_connect('localhost', 'user', 'password', 'databaseName');

if ($db->connect_errno)
{
   exit('Не получилось соеденится к MySQL серверу');
}

$query = mysqli_query($db, 'SELECT * FROM `classics`');

while ($row = mysqli_fetch_assoc($query))
{
   echo 'Автор: ',$row['author'];
}
?>

Answer 2

mysql_result($query) or die(mysql_error());