Archive

Posts Tagged ‘mysql’

Easier And Better Mysql/Sqlite in PHP

September 3rd, 2009

Update: fixed Mysql Class

Most websites that use php mostly use MySql, People use it because it’s dynamic, fast(in most cases) and popular.
But most of you don’t know that there’s also something called “Sqlite” it’s also an Sql database, but it stores the database in a file.

Problem

There are two main problems with using mysql and sqlite these days:

  1. To switch between mysql and sqlite you have to go and replace mysql_query with sqlite_query in every file that uses mysql.
  2. If your’e obfuscating your code then you can’t obfuscate functions.
  3. If you want to process some code or an sql query before each time a mysql or an sqlite function is run like counting the number of queries in a page, and a lot of other uses.

There are a lot of inconvenience when using mysql or sqlite functions, everyone with their own problems, and this should help you solve most of them.
Read more…

admin mysql, php, sqlite , ,