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

Question

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('Via 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)

Answer 1

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.

Answer 2

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)