easySQL

a php database wrapper for easy read and write actions on a sql db (SQLite, MySQL, PostgreSQL, …)

easySQL Examples

• Example 1 SQLite (everything a bit)
• Example 2 SQLite (return above 5)
• Example 3 SQLite (return 5 random)
• Example 4 SQLite (export csv)
• Example 5 MySQL (everything a bit)
• Example 6 MySQL (get last 5 and get highest vcounter)
• Example 7 MySQL (get highest id, timestam and vcounter)
• Example 8 SQLite and MySQL
• Twitter Example SQLite (import tweets to SQLite file and export to HTML list

Create Database/Table

//sqlite:
    $array[0] = './path/to/sqliteDB.sql';
    $array[1] = 'tablename';

//mysql:
    $array[0][0] = 'server.tld';
    $array[0][1] = 'username';
    $array[0][2] = 'password';
    $array[1] = 'tablename';

$array['id'] = 'integer PRIMARY KEY AUTOINCREMENT';
$array['username'] = 'varchar NOT NULL UNIQUE';
$array['password'] = 'varchar NOT NULL';
$array['column'] = '...'; // constraints

easysql_sqlite_create($array);

Insert

$array[0] = './path/to/sqliteDB.sql';
$array[1] = 'tablename';
$array['username'] = 'John Doe';
$array['password'] = 'lorem ipsum';
$array['column'] = '...';

easysql_sqlite_create($array);

Update

$array[0] = './path/to/sqliteDB.sql';
$array[1] = 'tablename';
$array[2]['id'] = 1337;
$array[3]['password'] = 'new_password';

easysql_sqlite_update($array);

Select

$array[0] = './path/to/sqliteDB.sql';
$array[1] = 'tablename';
$array['id'] = '3';

var_dump(easysql_sqlite_select($array));

Export

$array[0] = './path/to/sqliteDB.sql';
$array[1] = 'tablename';

easysql_sqlite_export($export, 'csv', './file.csv');

Info

Demo: here
License: MIT
Version: 0.4.1
Date: September 2012