What are some best practices for selecting and displaying data from a SQL database in PHP?

When selecting and displaying data from a SQL database in PHP, it is important to properly sanitize user input to prevent SQL injection attacks. Additionally, it is recommended to use prepared statements to securely interact with the database. Finally, consider implementing pagination to efficiently display large datasets without overwhelming the user interface. 

<?php
// Connect to the 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);
}

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

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

$conn->close();
?>

Keywords

SQL database data retrieval PHP data display error handling

Related Questions