What are the newer alternatives to the deprecated mysql_result function in PHP, as mentioned in the PHP manual?

The mysql_result function in PHP has been deprecated and is no longer recommended for use due to security vulnerabilities and lack of support. The newer alternatives to mysql_result are using mysqli or PDO extensions to interact with MySQL databases in a more secure and efficient way. These extensions provide object-oriented approaches to database operations and offer better error handling capabilities. 

// Using mysqli extension as an alternative to mysql_result
$mysqli = new mysqli("localhost", "username", "password", "database");
$result = $mysqli->query("SELECT * FROM table");
$row = $result->fetch_assoc();
echo $row['column_name'];

// Using PDO extension as an alternative to mysql_result
$pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");
$stmt = $pdo->query("SELECT * FROM table");
$row = $stmt->fetch(PDO::FETCH_ASSOC);
echo $row['column_name'];

Keywords

mysql_result alternatives PHP deprecated functions

Related Questions