What are some recommended alternatives to using mysql_result in PHP?

Using mysql_result in PHP is not recommended as it is deprecated and removed in newer versions of PHP. Instead, you can use mysqli or PDO to fetch data from a MySQL database. These extensions provide more secure and efficient ways to interact with the database. 

// Using mysqli to fetch data from a MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");
$result = $mysqli->query("SELECT * FROM table");
$row = $result->fetch_assoc();
echo $row['column_name'];

// Using PDO to fetch data from a MySQL database
$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

mysqli_fetch_assoc PDO mysql_fetch_assoc database abstraction layer SQL injection

Related Questions