快愁死我了，难道这个问题解决不了我要放弃mysqli吗？请高手指点我的代码错在哪里？还是服务器的问题？（服务器我用的是xampps1.9.7集成环境）
if($_post['contacts'] == true)
{
$stmt = $mysqli->prepare(insert into contactsuser(bookuname, bookdep, bookduty,bookphone,booktel,bookemail,bookgid) values (?, ?, ?, ?, ?, ?, ?));
$stmt->bind_param('sssd', $bookuname, $bookdep, $bookduty, $bookphone, $booktel, $bookemail, $bookgid);
$bookuname = $_post['bookuname'];
$bookdep = $_post['bookdep'];
$bookduty = $_post['bookduty'];
$bookphone = $_post['bookphone'];
$booktel = $_post['booktel'];
$bookemail = $_post['bookemail'];
$bookgid = $_post['bookgid'];
/* execute prepared statement */
$stmt->execute();
printf(%d row inserted.\n, $stmt->affected_rows);
/* close statement and connection */
$stmt->close();
exit;
}
回复讨论(解决方案) $mysqli 不是 mysqli 对象
试试面向过程风格的方法：
$stmt = mysqli_prepare($link, insert into contactsuser(bookuname, bookdep, bookduty,bookphone,booktel,bookemail,bookgid) values (?, ?, ?, ?, ?, ?, ?))
我刚才的程序确实疏忽忘了包含数据库链接文件了，但包含之后，包括改成面向过程风格后还是有错误：
warning: mysqli_stmt_bind_param(): number of elements in type definition string doesn't match number of bind variables in d:\xampps\htdocs\txl\addbook.php on line 24
程序如下：
$link = mysqli_connect('localhost','root','root','addressbook') or die('unale to connect');
$stmt = mysqli_prepare($link, insert into contactsuser(bookuname, bookdep, bookduty,bookphone,booktel,bookemail,bookgid) values (?, ?, ?, ?, ?, ?, ?));
mysqli_stmt_bind_param($stmt,'sssd', $bookuname, $bookdep, $bookduty, $bookphone, $booktel, $bookemail, $bookgid);
$bookuname = $_post['bookuname'];
$bookdep = $_post['bookdep'];
$bookduty = $_post['bookduty'];
$bookphone = $_post['bookphone'];
$booktel = $_post['booktel'];
$bookemail = $_post['bookemail'];
$bookgid = 1;
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
数据库的字段类型我也检查了，除了主键bookid是自动增加的int型，bookgid是int型，其他都是varchar类型
values (?, ?, ?, ?, ?, ?, ?)
$stmt,'sssd', $bookuname, $bookdep, $bookduty, $bookphone, $booktel, $bookemail, $bookgid
七个问号对应着八个参数 。。。。。加一个问号再试试
mysqli_stmt_bind_param($stmt,'ssssssd', $bookuname, $bookdep, $bookduty, $bookphone, $booktel, $bookemail, $bookgid);
http://php.net/manual/zh/mysqli-stmt.bind-param.php
the number of variables and length of string types must match the parameters in the statement.
楼上说的对，应该是ssssssd
太好了！感谢各位高手帮忙！特别是saint_leer和misakaqunianx...说的“ssssssd”的问题说到点子上了，一直没搞懂这传字符串啥意思！