PHP/SQLite with multiple SQL statements: $db->Query() works, $this->db_sqlite->query() fails

I am creating a class that handles various SQLite actions. My problem is: When I make a SQL string with multiple statements then it works when using standard PHP => $db->query() ... but it fails when making the same request from a method. It seems that the OO method skips everything after the first ";"-symbol in my SQL statement. Why is that, and how to fix it?

Thanks.

// Fails - line 2 is not inserted, why?
$this->db_sqlite->query("
    INSERT INTO foo (name) VALUES('Via class multi-lines 1');
    INSERT INTO foo (name) VALUES('Via class multi-lines 2');
");

// Works - both lines are inserted.
$GLOBALS[db]->query("
    INSERT INTO foo (name) VALUES('Direct multi-lines 1');
    INSERT INTO foo (name) VALUES('Direct multi-lines 2');
");

Full example:

<?php

class db_sqlite {

    function __construct() {
        $this->connect();
    }

    function connect() {
        $GLOBALS[db] = new SQLiteDatabase("dbsqlite.php.db");
    }

    function query($sql) {
        return $GLOBALS[db]->query($sql);
    }

}


class something {

    function setup() {
        $this->db_sqlite = new db_sqlite();

        $this->db_sqlite->query("CREATE TABLE foo ( id INTEGER PRIMARY KEY, name CHAR(255) );");

        // Works
        $this->db_sqlite->query("INSERT INTO foo (name) VALUES('V开发者_Go百科ia class one line 1');");
        $this->db_sqlite->query("INSERT INTO foo (name) VALUES('Via class one line 2');");

        // Fails (why?)
        $this->db_sqlite->query("
            INSERT INTO foo (name) VALUES('Via class multi-lines 1');
            INSERT INTO foo (name) VALUES('Via class multi-lines 2');
        ");

        // Works
        $GLOBALS[db]->query("
            INSERT INTO foo (name) VALUES('Direct multi-lines 1');
            INSERT INTO foo (name) VALUES('Direct multi-lines 2');
        ");

        foreach($this->db_sqlite->query("SELECT * FROM foo") as $v) {
            echo $v[id] . " - " . $v[name] ."<br>";
        }
    }
}

$something = new something();
$something->setup();
?>

Output:

1 - Via class one line 1 (correct)

2 - Via class one line 2 (correct) 3 - Via class multi-lines 1 (incorrect)

4 - Direct multi-lines 1 (correct)

5 - Direct multi-lines 2 (correct)

---

The PHP manual page for sqlite_query() says, about using multiple statements in one function call, "...this works only when the result of the function is not used - if it is used, only the first SQL statement would be executed." Since you're returning the result, you're "using" it. That's my guess, anyway.

---

You can pass an errorMsg holder variable that will be set if any error occur. It could be a good idea to check if sqlite returns anything there:

syntax: query ( string $query [, int $result_type [, string &$error_msg ]] )

$result_type could be SQLITE_BOTH (default)