In the context of PHP development, what are the best practices for connecting to databases and querying data, considering the deprecation of mysql_* functions?

With the deprecation of mysql_* functions in PHP, it is recommended to use either MySQLi (MySQL Improved) or PDO (PHP Data Objects) for connecting to databases and querying data. These extensions provide more secure and efficient ways to interact with databases, preventing SQL injection attacks and offering better performance. 

// Using MySQLi for connecting to a database and querying data
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// Query data
$sql = "SELECT * FROM table";
$result = $conn->query($sql);

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

$conn->close();

Keywords

PDO mysqli prepared statements database connection data querying

Related Questions