xxxxxxxxxx
$stmt = $pdo->prepare("SELECT * FROM table WHERE id = ?");
$stmt->execute([$id]);
$result = $stmt->fetchAll();
xxxxxxxxxx
$sql = 'SELECT publisher_id, name
FROM publishers
WHERE publisher_id = :publisher_id';
$statement = $pdo->prepare($sql);
$statement->bindParam(':publisher_id', $publisher_id, PDO::PARAM_INT);
$statement->execute();
$publisher = $statement->fetch(PDO::FETCH_ASSOC);
xxxxxxxxxx
<?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";
}
?>
xxxxxxxxxx
$sql = "SELECT * FROM payment WHERE tno=? && status=?";
$stmt =$pdo->prepare($sql);
$stmt->execute([$_POST["tranjection"],"active"]);
// retutn all data
$data = $stmt->fetchAll();
// retu ntotal row
$row = $stmt->rowCount();
xxxxxxxxxx
$pdo = new PDO('mysql:host=' . $host . ';dbname=' . $database, $username, $password);
$query = "
SELECT * FROM [database]
";
$stmt = $pdo->query($query);
foreach ($stmt->fetchAll() as $item) {
$data[] = $item;
}
xxxxxxxxxx
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "myDatabase";
try {
$pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
$id='1';
$stmt = $pdo->prepare("SELECT * FROM myTable WHERE id =?");
$stmt->execute([$id]);
$results = $stmt->fetch();
//Close DB connection
$pdo = null;
//return results in an array
print_r($results);