What are some best practices for querying and displaying data from a MySQL database in PHP?

When querying and displaying data from a MySQL database in PHP, it is important to sanitize user input to prevent SQL injection attacks. Additionally, it is recommended to use prepared statements to securely interact with the database. Finally, consider using error handling to gracefully handle any database connection or query errors. 

// Connect to MySQL database
$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);
}

// Prepare and execute SQL query
$stmt = $conn->prepare("SELECT id, name FROM users WHERE id = ?");
$stmt->bind_param("i", $id);

$id = 1;
$stmt->execute();
$result = $stmt->get_result();

// Display data
while ($row = $result->fetch_assoc()) {
    echo "ID: " . $row['id'] . " - Name: " . $row['name'] . "<br>";
}

// Close connection
$stmt->close();
$conn->close();

Keywords

MySQL PHP querying displaying data

Related Questions