$stmt->bind_param('sii', $class, $mark, $id);Procedural style
mysqli_stmt_bind_param($stmt, "si",$class, $id);
Used with prepare() to bind parameters to variables used inside Query.
$query="UPDATE student SET class=?,mark=? WHERE id=?";
MySQLI database connection file
<?Php require "config.php";// Database connection file. $class='Three'; $mark=66; $id=5; $query="UPDATE student SET class=?,mark=? WHERE id=?"; $stmt = $connection->prepare($query); if ($stmt) { $stmt->bind_param('sii', $class, $mark, $id); $stmt->execute(); echo "Record Updated:"; echo $stmt->affected_rows; }else{ echo $connection->error; } ?>Procedural style
$class='Three';
$mark=68;
$id=5;
$query="UPDATE student SET class=?,mark=? WHERE id=?";
if ($stmt = mysqli_prepare($connection,$query)){
mysqli_stmt_bind_param($stmt, "sii", $class, $mark, $id);
mysqli_stmt_execute($stmt);
echo "Record Updated:";
echo mysqli_affected_rows($connection);
}else{
echo mysqli_error($connection);
}