准备语句帮助php mysqli [关闭]

Question

I can't seem to get prepared statements to work for me. I've tried several different examples from the php manual, but no luck.

For example,

$myNumber = 1;
$sql = ("SELECT * from finished_goods WHERE finished_goods_id2 = ? ");
$stmt = $conn->prepare($sql);
$smt = bind_param('i', $myNumber);
$stmt->execute();

Answer 1

All the variable have to be the same, so like this:

$myNumber = 1;
$sql = ("SELECT * from finished_goods WHERE finished_goods_id2 = ? ");
$stmt = $conn->prepare($sql);
$stmt = bind_param('i', $myNumber);
$stmt->execute();

You wrote $smt when binding the parameter.