MySqli Prepared Statment Fetch Row
Posted
by pws5068
on Stack Overflow
See other posts from Stack Overflow
or by pws5068
Published on 2010-04-10T17:38:01Z
Indexed on
2010/04/10
17:43 UTC
Read the original article
Hit count: 312
I'm looking for an efficient way to select a specific row with a php prepared statement.
$iDB = new mysqliDB();
$stmt = $iDB->prepare($sql);
$stmt->bind_param('s',$searhStr);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($objID,$typeID,$year,$updated);
// Now jump to row $rowNumber
echo("Obj ID = {$objID}");
Any suggestions?
Thanks!
© Stack Overflow or respective owner