mysqli bind_param() fatal error
I Have an Error at my Code could someone help me?
<?php
$db = new mysqli("localhost","root","","karmintalender");
$owner_ID = 1;
$sql = "SELECT name, kalender_ID FROM kalender WHERE ersteller_ID = ?";
$stmt = $db->prepare($sql);
$stmt->bind_param("i", $开发者_如何学Pythonowner_ID);
$stmt->execute();
$stmt->bind_results($name, $kalender_ID);
while ($stmt->fetch()) {
echo $name . " " . $kalender_ID;
}
?>
When I open it this error appears "Fatal error: Call to a member function bind_param() on a non-object in G:\xampp\htdocs\Karmintalender\test.php on line 8"
One of your fields on this line doesn't exist,check them.
$sql = "SELECT name, kalender_ID FROM kalender WHERE ersteller_ID = ?";
Also, you should be checking for $stmt.
$db = new mysqli("localhost","root","","karmintalender");
$owner_ID = 1;
$sql = "SELECT name, kalender_ID FROM kalender WHERE ersteller_ID = ?";
$stmt = $db->prepare($sql);
if($stmt){
$stmt->bind_param("i", $owner_ID);
$stmt->execute();
$stmt->bind_results($name, $kalender_ID);
while ($stmt->fetch()) {
echo $name . " " . $kalender_ID;
}
}
it should be $stmt->bind_result($name, $kalender_ID);
drop the s
精彩评论