mysqli_prepare()函数

mysqli_prepare()函数,预执行php语句

$strsql="INSERT INTO Test values(?, ?)";//要执行的语句,?代替要操作的参数
$stmt = mysqli_prepare($con, $strsql);//预处理执行语句
mysqli_stmt_bind_param($stmt, "si", $Name, $Age);//插入参数
$Name = 'Raju';//参数赋值
$Age = 25;//参数赋值
mysqli_stmt_execute($stmt);//执行语句
mysqli_stmt_close($stmt);//关闭语句
mysqli_close($con); //关闭连接