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()