Call to a member function fetch_field() on a non-object MySQLiDB

Question

Hi i cant use INSERT UPDATE function with this class: MySQLiDB. Im trying write data to mysql and if exists this data then need update. So i use INSERT ... ON DUPLICATE KEY UPDATE.... My code like this:

$db->rawQuery("INSERT INTO table1 (field1,field2,field3) VALUES (?,?,?) ON DUPLICATE KEY UPDATE field2=VALUES(field2),field3=VALUES(field3)", array("value1",value2,value2));

this code works fine. But when use this code in cycle and give values by another array shows me this error: Call to a member function fetch_field() on a non-object in.... This is code in cycle:

$db->rawQuery("INSERT INTO table1 (field1,field2,field3) VALUES (?,?,?) ON DUPLICATE KEY UPDATE field2=VALUES(field2),field3=VALUES(field3)", array($value[$i][value1],$value[$i][value2],$value[$i][value3]));

What i can do in this situation?

-1 for providing not an error message but only stub. How we are supposed to know the code that leads to the error? — Your Common Sense, Sep 02 '13 at 05:53
im sorry but its Fatal error: Call to a member function fetch_field() on a non-object in... Really fatal error — iProgrammer, Sep 02 '13 at 05:58
still only a stub. Why do you continuously omit the vital part? — Your Common Sense, Sep 02 '13 at 06:00
https://github.com/ajillion/PHP-MySQLi-Database-Class this is source of class — iProgrammer, Sep 02 '13 at 06:04
The vital part of the **error message**. Why not to post it whole, not cutting out the **file name** and the **line number**? — Your Common Sense, Sep 02 '13 at 06:06
Okay Fatal error: Call to a member function fetch_field() on a non-object in /project/classes/mysqlidb.class.php on line 427 — iProgrammer, Sep 02 '13 at 06:10
Thank you for answer. But my codes wrote in MySQLiDB class it takes more time to change. I cant change all codes. — iProgrammer, Sep 02 '13 at 06:40
Well, if you want to stick to that faulty library, you have to debug its faulty code, find the error and fix it. — Your Common Sense, Sep 02 '13 at 06:51

Your Common Sense · Accepted Answer · 2013-09-02T06:53:06.087

Do not use MySQLiDB. It is unusable in many ways.

You can use safemysql instead:

$sql = "INSERT INTO table1 (field1,field2,field3) VALUES (?s,?s,?s) 
        ON DUPLICATE KEY UPDATE field2=VALUES(field2),field3=VALUES(field3)";
$db->query($sql, $value[$i]['value1'],$value[$i]['value2'],$value[$i]['value3']);

Or, in a much simpler way:

foreach ($value as $row)
{
    $sql = "INSERT INTO table1 SET ?u
            ON DUPLICATE KEY UPDATE field2=VALUES(field2),field3=VALUES(field3)";
    $db->query($sql, $row);
}

(only if $value coming from the trusted source though)

You could also create a query for the single insert

$ins = array();
foreach ($value as $row) {
    $ins[] = $db->parse("(?s,?s,?s)",$row['value1'],$row['value2'],$row['value3']);
}
$instr = implode(",",$ins);
$sql = "INSERT INTO table1 (field1,field2,field3) VALUES ?p 
        ON DUPLICATE KEY UPDATE field2=VALUES(field2),field3=VALUES(field3)";
$db->query($sql, $ins);

Call to a member function fetch_field() on a non-object MySQLiDB

1 Answers1