MYSQLI STMT Bind_Param

[keenyounglearner]

HI there, I am having trouble understanding how this function works and am getting the error:

 

Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement in file.php on line 65

-1

$thesql ="INSERT INTO `table` (`id` ,`name` ,`third`)
VALUES (NULL, '$name', '$third');";

if ($stmt = $thesql ->prepare($thesql)) {  
$stmt->bind_param("ss", $name2, $third);
$stmt->execute();       
} 

 

How does this work, do I need to have a "s" or "i" for a NULL value?

[gevans]

Your code is currently using $thesql as an object, though you're clearly setting it as a string on the lines before;

 

Where do you instantiate your mysqli object? and to waht variable is it assigned?