connect multiple db using Sqlite

Question

The code below is an attempt to connect more than one database using PHP PDO and SQLite. No matter what I tried, it does not accept the select test1.table1. If I remove the database name the select works; so how do I reference more than one database in the select?

<?php

  // connect to SQLite3 database 
  $query = "test1.sqlite3";
  $db = new PDO("sqlite:$query"); 

  // connect to second db
  $query = "attach test2.sqlite3";
  $db->query($query); 

  $query  = "Select * FROM test1.table1 ";
  $result = $db->query($query);
  $rows   = $result->fetchall(PDO::FETCH_ASSOC);

  foreach ($rows as $row) {
    echo "<pre>".print_r($row)."</pre>";
  }  

?>

Please note that the ATTACH statement requires an AS clause; your second connection did not work. — CL.
– CL., Commented Jul 21, 2014 at 7:24

Colonel Thirty Two · Accepted Answer · 2014-07-21 01:49:27Z

1

The first database you connect to (test1.sqlite3 in your case) is always called main, regardless of the actual filename. Try SELECT * FROM main.table1.

answered Jul 21, 2014 at 1:49

Colonel Thirty Two

27k9 gold badges52 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

connect multiple db using Sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related