問題Fatal error: Call to a member function bind_param() on a non-object in
<?php
header('content-type:text/html;charset=utf-8');
$mysqli=new?mysqli('localhost','root','','tamia');
if?($mysqli->errno)?{
????die("Connect?Error:".$mysqli->error);
}
$mysqli->set_charset('UTF8');
$username=$_POST['username'];
$password=md5($_POST['password']);
/*$sql="SELECT?*?FROM?users?WHERE?username='{$username}'?AND?password='{$password}'";
$mysqli_result=$mysqli->query($sql);
if($mysqli_result?&&?$mysqli_result->num_rows>0){
????echo?'登錄成功';
}else{
????echo?'登錄失敗';
}*/
$sql="SELECT?*?FROM?user?WHERE?username=??AND?password=?";
$mysqli_stmt=$mysqli->prepare($sql);
$mysqli_stmt->bind_param('ss',$username,$password);
if?($mysqli_stmt->execute())?{
????$mysqli_stmt->store_result();
????if?($mysqli_stmt->num_rows>0)?{
????????echo?'登錄成功';
????}else{
????????echo?'登錄失敗';
????}
}
//釋放結(jié)果集
$mysqli_stmt->free_result;
//關(guān)閉預(yù)處理語句
$mysqli_stmt->close();
//關(guān)閉連接
$mysqli->close();
?>老師的源代碼也是如此，請(qǐng)問是什么問題
2019-06-05
代碼里有錯(cuò)誤代碼引起的
2016-11-13
我也出現(xiàn)這種情況，我是先先用var_dump($mysqli_stmt);
打印一下$mysqli_stmt的值是否為true，我打印出來的是假，我就發(fā)現(xiàn)我打錯(cuò)一個(gè)字母，希望你頁能找一下，是否有語法錯(cuò)誤吧
2016-07-08
對(duì)不起，暫時(shí)看不出來