How can PHP be used to compare user IDs from different tables and output the corresponding count?

To compare user IDs from different tables and output the corresponding count, you can use SQL queries to retrieve the user IDs from each table and then compare them in PHP. You can use PHP to loop through the results, compare the IDs, and increment a counter if they match. Finally, you can output the count of matching user IDs. 

<?php

// Connect to your 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 get user IDs from table1
$sql1 = "SELECT user_id FROM table1";
$result1 = $conn->query($sql1);

// Query to get user IDs from table2
$sql2 = "SELECT user_id FROM table2";
$result2 = $conn->query($sql2);

// Initialize counter
$count = 0;

// Compare user IDs and increment counter if they match
while ($row1 = $result1->fetch_assoc()) {
    while ($row2 = $result2->fetch_assoc()) {
        if ($row1['user_id'] == $row2['user_id']) {
            $count++;
        }
    }
}

// Output the count of matching user IDs
echo "Count of matching user IDs: " . $count;

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

?>

Keywords

PHP SQL JOIN COUNT User IDs

Related Questions