php-pdoJoin query example with PHP PDO

$st = $pdo->prepare('SELECT p.*, u.name FROM photos p JOIN users u ON (u.id = p.user_id)');
$st->execute();

foreach ( $st as $row ) {
  print_r($row);
}ctrl + cgithub

`$pdo->prepare` prepare given query to execute	`p.*, u.name` selects all columns from `photos` table and `name` column from `users` table
`$st->execute(` run query on the server	`foreach ( $st as $row )` go through each row in result set
`print_r($row)` print each row

More of Php Pdo

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

See more codes...