simple Php-SQL query help

[albmed7589]

This is my code

$stmt = $db->prepare("SELECT factory FROM offices
    WHERE id=?");
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->bind_result($factory);
 
echo "<br />factory: ".$factory;

problem is there is no value being assigned to the $factory variable. when I run the query in PHPMyAdmin I get back one result, as expected. Any help would be highly appreciated 

Edited July 14, 2016 by albmed7589

[lovephp]

Shouldn't this

 

$stmt->bind_param("i", $id);

 

Be

 

$stmt->bind_param("id", $id); ??

[mac_gyver]

you are missing a $stmt->fetch(); method call to retrieve the data.

 

the PDO extension is much more consistent and straight-forward to use, particularity with prepared queries. if you can, switch from using the mysqli extension to the PDO extension.

Edited July 14, 2016 by mac_gyver

[ginerjm]

LovePHP: mysqli requires the variable type to do the bind using the ? parm. Therefore the OP's code is correct as it is.

 

Mac_gyver has solved the user problem - no data was being fetched.

 

And Mac_gyver has my vote on his choice of PDO over mysqli!