PDO fetching objects - how to assign variables ?

[elem]

Hi guys,

very simple I'm sure - what is the better way of assigning variables to rows in this case? I'm assuming this is probably a stupid way of doing it:

PHP Code:

$stmt = $conn->prepare('SELECT id,make,model FROM products WHERE id > :id');
$stmt->execute(array('id' => $id));
$result = $stmt->fetchAll();
if ( count($result) ) {
foreach($result as $row) {
$id=$row[0];
$make=$row[1];
$model=$row[2];
} 


[Fou-Lu]

Yep, you can use list.

PHP Code:

list($id, $make, $model) = $row; 


[Dormilich]

Tip: you don’t need ->fetchAll() for this, you can loop directly over $stmt

[elem]

Thanks guys, if there is any more ways I'll be glad to get to know them.

Fou-Lu - I've used it and it works great. Cheers

[Dormilich]

Originally Posted by elem

if there is any more ways I'll be glad to get to know them.

that depends upon what you want to do with the variables.