I wrote a php script to update information in an mysqli database table and and am getting the error: The number of variables must match the number of parameters in a prepared statement.
This is the code snippet with the error line in bold red. I don't see anything wrong with it but hopefully some of you sharp eyed people can help me.
include "churchdb_data.php";
$con=mysqli_connect('localhost',$username,$password,$database);
if (mysqli_connect_errno()) {
die ("Failed to connect to MySQL: " . mysqli_connect_error());
}
$sql = "UPDATE missionaries SET ID=?, missionary=?, active=?, country=?, city=?, state=?, zip=?, street=?, phone=?,email=?,
website=?, facebook=?, photo=? WHERE ID=?";
$stmt = $con->prepare($sql);
$stmt->bind_param("issssssssssss", $id, $missionary,$active,$country,$city,$state,$zip,$street,$phone,$email,$website,$facebook,$photo);
if ($stmt->execute()) {
echo "Record updated successfully!";
} else {
echo "Error updating record: " . $stmt->error;
}
$stmt->close();
$con->close();
?>
