php预定义sql

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