MYSQLI预编译
- 查询语句写法
$sql='INSERT INTO users (username,password,age) VALUES('admin','admin','20')'
$sql='select username ,password ,age from users where id=1'
- 准备预处理语句
$mysqli_stmt=$mysqli->prepare($sql)
- 绑定参数
$mysqli_stmt->bind_param('ssi',$username,$password,$age)
绑定结果集
$mysqli->bind_result($username,$password,$age)
执行预处理语句
$mysqli_stmt->excute()
- 显示插入id
echo $mysqli_stmt->insert_id
- 显示绑定结果的变量
while($mysqli_stmt->fetch())
echo $username.$password.$age
- 释放结果
$mysqli_stmt->free_result()
- 关闭编译语句
$mysqli_stmt->close()
- 关闭数据库连接
$mysqli->close()