<?php
//使用mysqli 实现 mysql预处理
//创建mysqli_stmt 对象
$mysqli = new mysqli('localhost', 'root', '', 'test', '3306');
$mysqli->set_charset('utf-8');
$sql = "insert into test values (null, ?, ?)";
$stmt = $mysqli->prepare($sql);
// ss 表示 后面传递参数的数据类型 string string 首字母 ss
$stmt->bind_param('ss', $username, $password)
//赋值
$username = "test123";
$password = "test123";
//执行sql语句
$stmt->execute();
//第二种创建mysqli_stmt的对象的方法 需要再次调用prepare()
//$stmt = $mysqli->stmt_init();
//$stmt->prepare($sql);
?>