title: using sqlite with php and sqlite-programs
body: <p>I'm trying to use sqlite with php.</p>
  
  <p>I used some tutorial:</p>
  
  <pre><code>$db = sqlite_open("db.sqlite");
  
  sqlite_query($db , "CREATE TABLE foo (id INTEGER PRIMARY KEY, name CHAR(255))");
  
  sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia')");
  sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia2')");
  sqlite_query($db, "INSERT INTO foo (name) VALUES ('Ilia3')");
  
  $result = sqlite_query($db, "SELECT * FROM foo");
  
  while ($row = sqlite_fetch_array($result)) print_r($row);
  </code></pre>
  
  <p>It works, but file db.sqlite can't be opened by any sqlite program.
  And vice-versa, files that were created by sqlite programs can't be opened with php sqlite_open:</p>
  
  <blockquote>
    <p>Warning: sqlite_open()
    [function.sqlite-open]: file is
    encrypted or is not a database in
    ...\public_html\test\test.php
    on line 2</p>
  </blockquote>
  
  <p>What can be the problem here?</p>