PHP MySQL SELECT

MySQLi

$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo $row["name"] . " - " . $row["email"];
    }
}

PDO

$stmt = $pdo->prepare("SELECT * FROM users WHERE status = ?");
$stmt->execute([$status]);
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);

Prepared Statements (Safe)

$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();

---