What role does the mysql_query function play in the PHP code snippet?

The mysql_query function in PHP is used to send a SQL query to the MySQL database. However, this function is deprecated as of PHP 5.5.0 and removed in PHP 7.0.0. To solve this issue, you should switch to using MySQLi or PDO extensions for database operations in PHP. 

// Connect to MySQL using MySQLi extension
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Example query using MySQLi prepared statement
$stmt = $conn->prepare("SELECT * FROM table WHERE column = ?");
$stmt->bind_param("s", $column_value);
$column_value = "value";
$stmt->execute();
$result = $stmt->get_result();

// Process result set
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Column: " . $row["column"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

Keywords

mysql_query PHP database SQL data retrieval

Related Questions