MySQLi绑定参数错误[关闭]

Question

My code generates an Call to a member function bind_param() on a non-object error. When I perform a var dump the result is bool(false). It appears that PHP doesn't think the $statement variable is an object. I'm kind of new to this so any help would be appreciated. I've also tried replacing the $id variable value with a string with no luck.

<?php
$con=new MySQLi("localhost","root","mysql","tinymce");

$statment = $con->prepare("SELECT * FROM 'content' WHERE 'id'=?");

$id=1;

$statement->bind_param('i', $id);

$statement->execute();



$con->close();
?> 

Answer 1

This is the first thing I noticed. Use back ticks not single quotes:

$statment = $con->prepare("SELECT * FROM `content` WHERE `id`=?");

Other problems noticed:

// Haven't tested this but it could be case sensitive, use `mysqli` not `MYSQLi`
$con=new mysqli("localhost","root","mysql","tinymce");  

// Typo here?  it should be `$statement = ` not `$statment` as you're using `$statement` in rest of your code.
$statement = $con->prepare("SELECT * FROM `content` WHERE `id`=?");