作业帮 > 综合 > 作业

php 写入数据库时Call to a member function bind_param() on a non-ob

来源:学生作业帮 编辑:拍题作业网作业帮 分类:综合作业 时间:2024/04/29 12:20:56
php 写入数据库时Call to a member function bind_param() on a non-object,急,
$sql="insert into user (username,password,question,answer,sex,birth,Email,phonenum,randcode,level) values(?,,,,,,,,,)";
\x09$regin->mysqli_stmt=$regin->mysqli->prepare($sql);
\x09$regin->mysqli_stmt->bind_param("sssssssssi",$username,$password,$question,$answer,$sex,$birth,$email,$phonenum,$randcode,$level);
看了一个下无了就是早不到原因
$regin->mysqli_stmt->bind_param("ssssss.这一行就是报错,核对了数目,根本就没错,逗号也没漏
Call to a member function bind_param() on a non-object
而且用MySQL 5.6 Command Line Client - Unicode写入成功了
insert into user (username,password,question,answer,sex,birth,Email,phonenum,randcode,level) values('test','test','test','test','test','2014-7-17','test','test','test',1)
其它的都是text型,只有birth是date和level是int型的
是我之前进行了读取,导致问题出现了在读取数据使用完成后再使用
$regin->mysqli_stmt->free_result();
进行释放,就可以了
对象里没有bind_param方法.