普通网友 2013-03-11 01:35
浏览 9
已采纳

致命错误:调用成员函数准备非对象[重复]

This question already has an answer here:

Can somebody point me in the right direction as to why the following piece of code is failing..

MySQLDb.php:

class MySQLDb 
{
        protected $_mysql; 
        protected $_query;


        function __constructor($host,$username,$password,$db)
        {
            $this->_mysql = new mysqli($host,$username,$password,$db) or die('Problem connecting to the DB.');

        }


        function query($query)
        {
            $this->_query =  filter_var($query,FILTER_SANITIZE_STRING);
            $stmt = $this->_prepareQuery();
            $stmt->execute();
            $results = $stmt->_dynamicBindResult($stmt);
        }


 protected function _prepareQuery(){

            $dbh = $this->_mysql;
            if ( !$stmt = $dbh->prepare($this->_query) ) {
                trigger_error('Problem preparing query', E_USER_ERROR);

            }

            return $stmt;
        }

index.php:

require_once('MYSQLDb.php');

$Db = new MySQLDb('localhost','root','','blog');


$results =$Db->query("SELECT * FROM posts");

When I run the program it spits out the error fatal error: call to a member function prepare on a non-object at if ( !$stmt = $dbh->prepare($this->_query) ) {

I'm trying to learn the object oriented way of doing this things so not very clued in on how to troubleshoot this.

thanks.

</div>
  • 写回答

1条回答 默认 最新

  • duanqiao2225 2013-03-11 01:39
    关注

    The problem is in your constructor:

    function __constructor($host,$username,$password,$db) {
    

    The actual PHP "class constructor" name is __construct, not __constructor, so your version is never being called and $this->_mysql is null (i.e. - not an object).

    Try update the function to the following and it should work:

    function __construct($host,$username,$password,$db) {
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Pythontxt文本可视化
  • ¥15 如何基于Ryu环境下使用scapy包进行数据包构造
  • ¥15 springboot国际化
  • ¥15 搭建QEMU环境运行OP-TEE出现错误
  • ¥15 Minifilter文件保护
  • ¥15 有限元软件终止时间超过设定值
  • ¥15 onvif框架引用一直报错
  • ¥50 C#和C++混合编程,使用CLR托管,报错System.Runtime.InteropServices.SEHException
  • ¥30 .NET使用sqlite发布后报错
  • ¥15 Unity在WebGL平台导出Word报错问题