LIZ DB is very easy to install. All You have to do is simply download the newest version and unzip downloaded archive to Your working directory.
1. Defining LIZDB_PATH constant
First, in order to start working with LIZ DB we need to define LIZDB_PATH that points to the directory in which we have installed (unzipped) our archive.
Example 1. Defining LIZDB_PATH.
// LIZDB_PATH must point to directory where LIZ DB is installed
define('LIZDB_PATH', '/home/xh/public_html/lizdb_test/LIZDB');
LIZDB_PATH can be also set dynamically, the below code will work
assuming LIZ DB was installed into current directory.
Example 2. Automatic defining LIZDB_PATH.
if (false == is_dir(LIZDB_PATH)) {
define('LIZDB_PATH', getcwd() . '/LIZDB');
}
Now we're ready to create DB objects and connect to our database.
2. Creating DB object
Currently LIZ DB 2.0 provides implementation only for MySQL5.
We need to include class definition and create its instance.
There is MySQLimp class (imp stands for improved, not implementation) in
LIZDB_PATH . '/classes/MySQLimp.inc.php' file.
MySQLimp's constructor expects associative array that must define following:
- server - name or IP of MySQL server
- user - username for authorisation
- passwd - password for authorisation
- database - database to connect to
There are two types of exceptions that can be thrown during script's execution:
- Exception - all generic PHP5 exceptions
- LIZDBException - thrown explicitly by LIZ DB, these exceptions are strictly linked with database errors
require LIZDB_PATH . '/classes/MySQLimp.inc.php';
// change Your settings!
// or run sql/create_user.sql to create lizdb user
$config = array();
$config['server'] = 'localhost';
$config['user'] = 'lizdb';
$config['passwd'] = 'lizdb';
$config['database'] = 'test';
try {
$db = new MySQLimp($config);
$db->CloseConnection();
} catch (LIZDBException $e) {
echo $e->getMessage() . "\n";
echo $e->GetQuery();
} catch (Exception $e) {
echo $e->getMessage();
}
3. Basic fields and methods
There is only one public field in MySQLimp class:
- public $Query - this field stores SQL statement to be executed (any valid MySQL statement!)
- public Select() - returns array of records
- public SelectOne() - returns single record
- public SelectColumn() - return array of given column's values
- public RunQuery() - runs INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT, REVOKE, and more...
Example 4. The very basic usage of SelectOne and RunQuery methods.
$db->Query = 'SELECT * FROM `lizdb_test_table` ORDER BY id DESC LIMIT 1';
$record = $db->SelectOne();
$db->Query = "INSERT INTO `lizdb_test_table` VALUES (NULL, '{$chars}', {$int}, {$double})";
$newId = $db->RunQuery();
Stay tuned for more examples!
No comments:
Post a Comment