On 5 Aug 2017, at 10:53am, Edmondo Borasio <edmondobora...@gmail.com> wrote:
> Hey, do you know where I can find good instructions on how to use SQLITE in > PHP? I used to do that for a living. First, use the sqlite3 module. Don’t use the PDO module which can access many types of database. So you should be doing "new SQLite3()" like this: $db = new SQLite3('mysqlitedb.db'); $results = $db->query('SELECT bar FROM foo'); while ($row = $results->fetchArray()) { var_dump($row); } Second, I have not found any better examples than you find in the documentation <http://php.net/manual/en/book.sqlite3.php> which is rather annoying since there aren’t many examples of some calls. Third, I recommend you try to do object-oriented programming in PHP where possible, and the sqlite3 module works well with that. So although the call provided is $row = $results->fetchArray() I frequently do $row = (object) $results->fetchArray() and the var_dump line in the above example will show you how this changes what you get. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users