What are the potential pitfalls of using both mysql_* and mysqli_* functions in the same PHP script?

Mixing mysql_* and mysqli_* functions in the same PHP script can lead to confusion and errors due to differences in syntax and functionality between the two. To avoid this issue, it's recommended to stick to one set of functions for database interactions. If you need to migrate from mysql_* to mysqli_*, it's best to update all database queries in the script to use mysqli_* functions consistently. 

// Example of using mysqli_* functions consistently in a PHP script
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Perform database operations using mysqli_* functions
$result = $mysqli->query("SELECT * FROM table");

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 results";
}

$mysqli->close();

Keywords

mysql_* mysqli_* PHP script potential pitfalls error types

Related Questions