Prepare PDO sql statement with variable to call values on

Question

Okay, so obviously the code I have now doesn't work

$stmt = $pdo->prepare('SELECT * FROM '.$table.' WHERE id = :p');
foreach($stmt->execute(array(':p' => $_GET['p'])) as $row) {
    echo $row['id'];
}

but, hopefully you can understand what I'm trying to do. I want to return values from an sql entry that are related to id whatever. I'm not exactly sure what combination of prepare, execute, or query I need to use to achieve this.

Thanks

execute() returns true or false, not an array. You just call $stmt->fetch(PDO::FETCH_ASSOC) in a while loop, or $stmt->fetchAll() to get an array. php.net/manual/en/pdostatement.fetch.php — Michael Berkowski
– Michael Berkowski, Commented Feb 6, 2013 at 1:58

Supericy · Accepted Answer · 2013-02-06 01:58:37Z

2

Simplest answer:

$stmt = $pdo->prepare('SELECT * FROM ' . $table . ' WHERE id = :p');

$stmt->execute(array(':p' => $_GET['p']));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
    echo $row['id'];
}

I highly recommend taking a look at what each of these individual methods do:

http://php.net/manual/en/book.pdo.php

answered Feb 6, 2013 at 1:58

Supericy

5,8911 gold badge23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AKrush95 Over a year ago

Thank you. I've been looking there but there's just so much stuff and so much to take in it got intimidating. Thanks again.

Christian Koch Over a year ago

foreach ( $stmt as $row) is possible too, but after the execute() call

Collectives™ on Stack Overflow

Prepare PDO sql statement with variable to call values on

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related