Menu
Community /Pin to ProfileBookmark
@NogDogApr 14.2019 — #
The first is a bit "cleaner", the second more flexible, in that you can pass any of the 3 optional parameters to it as desired (seehttps://www.php.net/manual/en/pdostatement.fetch.php ).@NogDogApr 15.2019 — #@coleio#1602814
Nope: PDOStatement::execute() returns a Boolean, not a PDOStatement object, so there's nothing to loop on. (Would be nice if it did for when you want to chain methods, but... 🤷♂️ )@NogDogApr 15.2019 — #Yep...code defensively. Assume that anything that can fail will fail, so figure out what should happen if it does. If you turn on Exceptions for any PDO error (see https://www.php.net/manual/en/pdo.setattribute.php ), you could use a try/catch block to catch any errors from PDO methods, limiting the number of
foreach, while or both?
in the following peice of code is a pdo sql query. im wondering which should be used to work with the data just to echo it out say, a foreach loop or a while loop. if both are possible can you please give me an example of each. thanks
[CODE]
$sql = “SELECT * FROM table WHERE column1 = :foo and column2 – :bar”;
$stmt = $connect->prepare($sql);
$result = $stmt->execute(array(
‘:foo’ = $_GET[“foo”],
‘:bar’ = $_GET[“bar”}
));
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogApr 14.2019 — #<i>
</i>foreach($stmt as $row) { . . . }
// or
while($row = $stmt->fetch()) { . . . }
The first is a bit "cleaner", the second more flexible, in that you can pass any of the 3 optional parameters to it as desired (see
0
@NogDogApr 15.2019 — #Nope: PDOStatement::execute() returns a Boolean, not a PDOStatement object, so there's nothing to loop on. (Would be nice if it did for when you want to chain methods, but... 🤷♂️ )
0
@NogDogApr 15.2019 — #Yep...code defensively. Assume that anything that can fail will fail, so figure out what should happen if it does. If you turn on Exceptions for any PDO error (see if($something == false)