What are the potential pitfalls of using mysql_query to count entries in multiple tables in PHP?

Using mysql_query to count entries in multiple tables in PHP can be inefficient and prone to SQL injection attacks. It is recommended to use prepared statements with mysqli or PDO to securely execute queries and prevent potential vulnerabilities. Additionally, using separate queries for each table can improve performance and readability of the code. 

// Connect to the database
$mysqli = new mysqli("localhost", "username", "password", "database");

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

// Count entries in multiple tables
$tables = ["table1", "table2", "table3"];
foreach ($tables as $table) {
    $stmt = $mysqli->prepare("SELECT COUNT(*) FROM $table");
    $stmt->execute();
    $stmt->bind_result($count);
    $stmt->fetch();
    echo "Entries in $table: $count" . PHP_EOL;
    $stmt->close();
}

// Close connection
$mysqli->close();

Keywords

mysql_query count entries multiple tables PHP pitfalls

Related Questions