php-pdoSelect with prepared statement and bind values in PHP PDO

$st = $pdo->prepare('SELECT * FROM test WHERE age = :age');
$st->execute([':age' => 52]);
foreach ( $st as $row ) {
  print_r($row);
}ctrl + cgithub

`$pdo->prepare` prepare given query to execute	`$st =` prepared statement object
`$st->execute(` run query on the server	`foreach ( $st as $row )` go through each row in result set
`print_r($row)` print each row	`:age` safe value placeholder
`[':age' => 52]` bind values when executing query

Usage example

<?php

$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');

$st = $pdo->prepare('SELECT * FROM test WHERE age = :age');
$st->execute([':age' => 52]);

foreach ( $st as $row ) {
  print_r($row);
}

output

Array
(
    [id] => 2
    [0] => 2
    [age] => 52
    [1] => 52
    [name] => B
    [2] => B
)
Array
(
    [id] => 3
    [0] => 3
    [age] => 52
    [1] => 52
    [name] => C
    [2] => C
)

Select IN array with PHP PDO
Select LIKE query example with PHP PDO
Select with prepared statement in PHP PDO

More of Php Pdo

Set charset in PHP PDO
Fetch single column value with PHP PDO
Commit transaction in PHP PDO
How to get results after PHP PDO statement execute()
Set execution timeout with PHP PDO
Get last query error with PHP PDO
Bind current datetime with PHP PDO
Escape string with PHP PDO
Get current database name with PHP PDO
Insert JSON into table with PHP PDO

See more codes...

php-pdoSelect with prepared statement and bind values in PHP PDO

Usage example

output

Related

More of Php Pdo