Answers for "SELECT query with PDO"

PHP
2

SELECT query with PDO

// select a particular user by id
$id = 1 ;
$stmt = $pdo->prepare("SELECT * FROM users WHERE id=?");
$stmt->execute([$id]); 
$user = $stmt->fetch();
Posted by: Guest on March-23-2022
2

php query pdo

<?php
$sql =  'SELECT name, color, calories FROM fruit ORDER BY name';
foreach  ($conn->query($sql) as $row) {
    print $row['name'] . "\t";
    print  $row['color'] . "\t";
    print $row['calories'] . "\n";
}
?>
Posted by: Guest on April-15-2020

Browse Popular Code Answers by Language