Tag Archives: MySQL

MySQL to SQLite migration cheat sheet

At work, we needed to migrate from MySQL to SQLite. All of this thanks to this cheatsheet we got the migration an easy task. But it didn’t explain many things, just the major part in a step by step process. Tools : SQLite Database Browser MySQL with phpMyAdmin Text Editor such as TextEdit (we used … Continue reading MySQL to SQLite migration cheat sheet

PHP: DBClass

DBClass is a simple PHP database class that will help ease database connection usage. You can download the script in the links listed below. DBClass Download links Gist Sample Usage : $dbClass = new DBClass(); $result = $dbClass->query( $dbQuery ); while ( $content = $dbClass->fetchAssoc( $result ) ) { echo $content[‘description’]; } Functions : query() … Continue reading PHP: DBClass