PHP:致命错误:在非对象上调用成员函数bind_param() [英] PHP: Fatal error: Call to a member function bind_param() on a non-object

问题描述

该错误发生在第42行:

The error occurs on line 42:

$result->bind_param("ssssisssss", $Firma, $Partner, $Abteilung, $Strasse, $PLZ, $Ort, $Telefon, $Email, $Website, $Info );

这是整个准备好的声明:

This is the whole prepared statement:

$sql = "INSERT INTO `firmen` (`Firma`, `Ansprechpartner`, `Abteilung`, `Strasse`, `PLZ`, `Ort`, `Telefon`, `Email`, `Website`, `Zusatzinfos`) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";     
$result = $db->prepare( $sql ); 
$result->bind_param("ssssisssss", $Firma, $Partner, $Abteilung, $Strasse, $PLZ, $Ort, $Telefon, $Email, $Website, $Info );
$result->execute();

我找不到错误，我已经读过几乎所有具有相同错误的问题，而且我也将我的代码与很多教程进行了比较，看起来完全一样...

I can't find the mistake, I already read almost every question with the same mistake an I also compared my Code with a lot of Tutorial and it looks exactly the same...

提前谢谢！

推荐答案

...通常，当您在prepare语句中出现错误时，就会发生这种情况， 您可能在sql prepare中有错字.验证这一点. 使用此

...usually this occurs when you have an error in prepare statement, It might happen that you have a typo in sql prepare. to verify that. check the error with this

       $stmt = $this->db->prepare("INSERT INTO ".TB_ADMINISTRATION."(name, password, email) VALUES (?, ?, ?)"); 
       if(!$stmt)  //if there is an error, then it will be shown!. 
         { // show error                                                                                                       
          echo $this->db->error;
          } else {
           // everything is good to go !. 
         }

这篇关于PHP:致命错误:在非对象上调用成员函数bind_param()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！