Koneksi PHP PDO 8

SELECT

Select Query tanpa Parameter

$stmt = $pdo->query("SELECT * FROM users");

while ($row = $stmt->fetch()) {

    echo $row['name']."<br />\n";

} 

Select Single Row 

$stmt = $pdo->query("SELECT * FROM users ORDER BY id DESC LIMIT 1");

$user = $stmt->fetch();

Select Single Row menggunakan chain pipeline

$user = $pdo->query("SELECT * FROM users ORDER BY id DESC LIMIT 1")->fetch();

Select Multiple Row menggunakan Fetch

$data = $pdo->query("SELECT * FROM users")->fetchAll();

// and somewhere later:

foreach ($data as $row) {

    echo $row['name']."<br />\n";

}

Select menggunakan Placeholder

 // select a particular user by id

$stmt = $pdo->prepare("SELECT * FROM users WHERE id=?");

$stmt->execute([$id]); 

$user = $stmt->fetch();

SELECT query dengan multiple placeholders 

// select a particular user by id

$stmt = $pdo->prepare("SELECT * FROM users WHERE id=:id");

$stmt->execute(['id' => $id]); 

$user = $stmt->fetch();

Select Query Multiple menggunakan prepared  Statement

$stmt = $pdo->prepare("SELECT * FROM users LIMIT ?, ?");

$stmt->execute([$limit, $offset]); 

while ($row = $stmt->fetch()) {

    echo $row['name']."<br />\n";

}

Atau

 $stmt = $pdo->prepare("SELECT * FROM users LIMIT :limit, :offset");

$stmt->execute(['limit' => $limit, 'offset' => $offset]); 

$data = $stmt->fetchAll();

// and somewhere later:

foreach ($data as $row) {

    echo $row['name']."<br />\n";

}