MySQLi Insert() on a non-object

Question

I cannot get my insert function working. I have used this frame work.

https://github.com/ajillion/PHP-MySQLi-Database-Class

The error i get is

Fatal error: Call to a member function insert() on a non-object in /home/hghdigib/public_html/backup/feed/classes/xml_upload.php on line 39

I have stripped lost out to make it easier to follow.

Any help would be much appreciated been scratching my head for a while.

My Global Class File

require_once("classes/database.php");
require_once("classes/xml_upload.php");
$db = new Mysqlidb('localhost', '', '', '');
$dataupload = new DataUpload($db);
$dataupload->getAllProducts($db);

My xml_upload.php class

class DataUpload {

    public $db;
    public $xml_upload;

    function __construct($db) {
        $this->db = $db;
    }   

    public function getAllProducts() {
        foreach ($propertys as $results)
        {
            $insertData = array(
                'prop_id' => $results['prop_id'],
                'lastchanged' => $results['lastchanged'],
                'url' => $results['url']
            );

            if($db->insert('propertie_ids', $insertData)) echo 'success!';
        }

    }       

}

Remember that PHP has **no** automatic scope as for example in Java! — Matteo Tassinari, Sep 20 '13 at 11:12

score 2 · Accepted Answer · answered Sep 20 '13 at 11:11

2

if($db->insert('propertie_ids', $insertData)) echo 'success!';

Use $this->db instread of $db. You must refer to $this if you want to access class members.

$this->db->insert('propertie_ids', $insertData)

answered Sep 20 '13 at 11:11

Tim S.

13,597
7
46
72

OMFG, Thanks dude, been going mad haha. Thanks – Brent Sep 20 '13 at 11:13
Why was I marked down? – Brent Sep 20 '13 at 11:17
@BrentFrench Glad I could help! If it worked for you, always check the big outlined V left to the correct answer ;) I don't know who marked you down or why. – Tim S. Sep 20 '13 at 13:17

MySQLi Insert() on a non-object

1 Answers1