致命错误:在布尔值上调用成员函数 bind_param() [英] Fatal error: Call to a member function bind_param() on boolean in
本文介绍了致命错误:在布尔值上调用成员函数 bind_param()的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
代码
if(isset($_POST['create'])){
$fname = trim($_POST['fname']);
$lname = trim($_POST['lname']);
$ftname = trim($_POST['ftname']);
$mtname = trim($_POST['mtname']);
$date_of_admission = trim($_POST['date_of_admission']);
$date_of_birth = trim($_POST['date_of_birth']);
$photo_location = trim($_POST['photo_location']);
$address = trim($_POST['address']);
$phone = trim($_POST['phone']);
$sex = trim($_POST['sex']);
$nationality = trim($_POST['nationality']);
$religion = trim($_POST['religion']);
if(empty($fname) && empty($lname) &&empty($ftname) &&empty($mtname) &&empty($date_of_admission) && empty($phone) && empty($sex)){
$error = "You must fill all fields.";
}else{
$insert = $db->prepare("INSERT INTO st_info (fname, lname, ftname, mtname, date_of_birth, date_of_admission, photo_location, address, phone, sex, nationality, religion,joined) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())");
$insert->bind_param('sssssssssddd',$fname,$lname,$ftname,$mtname,$date_of_birth,$date_of_admission,$photo_location,$address,$phone,$sex,$nationality,$religion);
if($insert->execute()){
//$success = "st_info added successfully!";
header("location:index.php");
}
}
}
错误
致命错误:在布尔值上调用成员函数 bind_param()C:\xampp\htdocs\create.php 第 26 行
Fatal error: Call to a member function bind_param() on boolean in C:\xampp\htdocs\create.php on line 26
推荐答案
准备语句中最常见的失败之一是连接编码.. try
one of most common failures at prepared statements is connection encoding.. try
$mysqli->set_charset("utf8");
之后
$mysqli = new mysqli("host", "user", "pass", "db");
这篇关于致命错误:在布尔值上调用成员函数 bind_param()的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文