时间:2021-07-01 10:21:17 帮助过:34人阅读
$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);
楼上说的对,应该是ssssssd
太好了!感谢各位高手帮忙!特别是saint_leer和misakaqunianx...说的“ssssssd”的问题说到点子上了,一直没搞懂这传字符串啥意思!