What are the best practices for accurately counting entries in each table in a MySQL database using PHP?

When counting entries in each table in a MySQL database using PHP, it is important to use the COUNT() function in SQL queries to accurately retrieve the count of rows in each table. This ensures that the count is calculated directly from the database and not from potentially outdated or incorrect cached data. Additionally, it is recommended to sanitize user input to prevent SQL injection attacks. 

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

// Query to count entries in a specific table
$sql = "SELECT COUNT(*) AS count FROM table_name";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Count: " . $row["count"];
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

MySQL PHP database counting entries

Related Questions