note 106779 added to book.sqlite3

As of PHP 5.4 support for Sqlite2 has been removed. I have a large web app that was built with sqlite2 as the database backend and thus it exploded when I updated PHP. If you're in a similar situation I've written a few wrapper functions that will allow your app to work whilst you convert the code to sqlite3. Firstly convert your DB to an sqlite3 db. sqlite OLD.DB .dump | sqlite3 NEW.DB Then add the following functions to your app: function sqlite_open($location,$mode) { $handle = new SQLite3($location); return $handle; } function sqlite_query($dbhandle,$query) { $array['dbhandle'] = $dbhandle; $array['query'] = $query; $result = $dbhandle->query($query); return $result; } function sqlite_fetch_array(&$result,$type) { #Get Columns $i = 0; while ($result->columnName($i)) { $columns[ ] = $result->columnName($i); $i++; } $resx = $result->fetchArray(SQLITE3_ASSOC); return $resx; } They're not perfect by any stretch but they seem to be working ok as a temporary measure while I convert the site. Hope that helps someone ---- Server IP: 69.147.83.197 Probable Submitter: 94.23.153.89 ---- Manual Page -- http://www.php.net/manual/en/book.sqlite3.php Edit -- https://master.php.net/note/edit/106779 Del: integrated -- https://master.php.net/note/delete/106779/integrated Del: useless -- https://master.php.net/note/delete/106779/useless Del: bad code -- https://master.php.net/note/delete/106779/bad+code Del: spam -- https://master.php.net/note/delete/106779/spam Del: non-english -- https://master.php.net/note/delete/106779/non-english Del: in docs -- https://master.php.net/note/delete/106779/in+docs Del: other reasons-- https://master.php.net/note/delete/106779 Reject -- https://master.php.net/note/reject/106779 Search -- https://master.php.net/manage/user-notes.php