<?php
$mysqli=new mysqli("127.0.0.1","root","root","php");
if ($mysqli->connect_error) {
die("连接失败".$mysqli->connect_error);
}
$mysqli->query("set names utf8");
$sql="insert into t_user (name,passwd,email) values(?,?,?)";
$mysqli_stat=$mysqli->prepare($sql);
$mysqli_stat->bind_param("sss","猪头","typ5669298","1414854843@qq.com");
$res=$mysqli_stat->execute();
if (!$res) {
echo "execute fail ......";
} else {
echo "execute successful ...... ";
}
$mysqli->close();
?>
上面这个程序,是使用预定义sql,插入数据,绑定数据时,数据直接写在
bind_param这个方法里,执行错误,如果提炼成变量插入的话正常,代码在下面,感觉怪怪的,没查到原因
<?php
$mysqli=new mysqli("127.0.0.1","root","root","php");
if ($mysqli->connect_error) {
die("连接失败".$mysqli->connect_error);
}
$mysqli->query("set names utf8");
$sql="insert into t_user (name,passwd,email) values(?,?,?)";
$mysqli_stat=$mysqli->prepare($sql);
$name="猪头";
$passwd="typ5669298";
$email="752554930@qq.com";
$mysqli_stat->bind_param("sss",$name,$passwd,$email);
$res=$mysqli_stat->execute();
if (!$res) {
echo "execute fail ......";
} else {
echo "execute successful ...... ";
}
$mysqli->close();
?>