Users Data from MySQL
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Query 1: SELECT * FROM users WHERE id = 20
$result1 = $pdo->query("SELECT * FROM users WHERE id = 20")->fetchAll(PDO::FETCH_ASSOC);
foreach ($result1 as $row) {
$users[$row['id']] = $row; // Use ID as key to avoid duplicates
}
// Query 2: Prepared statement SELECT * FROM users WHERE id = ?
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([4]);
$result2 = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($result2 as $row) {
$users[$row['id']] = $row;
}
// Query 3: SELECT * FROM users WHERE id = 10 (from dbQuery)
$result3 = $pdo->query("SELECT * FROM users WHERE id = 10")->fetchAll(PDO::FETCH_ASSOC);
foreach ($result3 as $row) {
$users[$row['id']] = $row;
}
// MySQLi Query: SELECT * FROM users
$mysqli = new mysqli('159.65.85.53', 'admin', '07RY2yaph6g3@', 'php_sdk');
$result4 = $mysqli->query("SELECT * FROM users");
while ($row = $result4->fetch_assoc()) {
$users[$row['id']] = $row;
}
// Display the table
if (empty($users)) {
echo '
No users found in the database.
';
} else {
echo '
';
echo '
';
echo '';
echo '';
// Table headers (based on first row's keys)
$columns = array_keys(reset($users));
foreach ($columns as $column) {
echo '| ';
echo sanitize($column);
echo ' | ';
}
echo '
';
echo '';
echo '';
// Table rows
foreach ($users as $row) {
echo '';
foreach ($row as $value) {
echo '| ';
echo sanitize($value ?? 'NULL');
echo ' | ';
}
echo '
';
}
echo '';
echo '
';
echo '
';
}
?>