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: 282

Filed under:
|
|
|
|

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

Related posts about php

Related posts about mysqli