How can a beginner effectively transition from using mysql_query to mysqli_query in PHP?

When transitioning from using `mysql_query` to `mysqli_query` in PHP, a beginner should update their code to use the improved MySQLi extension, which offers better security and performance. To do this, they need to establish a connection to the database using `mysqli_connect` or `mysqli_init` and then use `mysqli_query` to execute SQL queries. 

// Establish a connection to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check if the connection was successful
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Use mysqli_query to execute a SQL query
$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query);

// Process the result set
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 results";
}

// Close the connection
mysqli_close($connection);

Keywords

PHP mysql_query mysqli_query database migration

Related Questions