我在这个MySQL查询中遇到了这个错误?
问题描述:
我从perfectly..but与BIND_PARAM()用事先准备好的声明的问题,收到HTML form..the值收到我的价值?可我使用PHP 7.0.1版本我在这个MySQL查询中遇到了这个错误?
<?php
if(isset($_POST['submit']))
{
if(empty(($_POST['fname'])) && empty(($_POST['lname'])) && empty(($_POST['dg'])))
{
header("Location:view.html/form.html");
}
else
{
$f_name=addslashes($_POST['fname']);
$l_name=addslashes($_POST['lname']);
$post=addslashes($_POST['dg']);
}
//----------------connection to database using Pdo------------------
$hostname="localhost";
$uname="root";
$password="";
$database_name="test";
$conn= new mysqli($hostname,$uname,$password) or die("cannot connect to database Mysql");
$stm=$conn->prepare("insert into s_detail(F_Name,L_Name,Designation) values(?,?,?)");
$stm->bind_param("sss",$f_name,$l_name,$post);
//set parameter and execute
$f_name=addslashes($_POST['fname']);
$l_name=addslashes($_POST['lname']);
$post=addslashes($_POST['dg']);
if($stm->execute())
{
$stm->close();
echo "data is inserted successfully";
}
else
{
echo "failed to insert";
}
}
else
{
echo "Don't be oversmart with me";
}
?>
的误差。 ..
Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:\xampp_7\htdocs\oops in php\oops.php:24 Stack trace: #0 {main} thrown in C:\xampp_7\htdocs\oops in php\oops.php on line 24
plz帮助.....
答
您还需要添加数据库参数。这是缺少
$conn= new mysqli($hostname,$uname,$password,$database_name);
成为习惯,经常检查,看看你是成功连接到数据库的目的
if($conn ==== false) {
die('error on connecting to database '.$conn->connect_error);
}