2017 © Pedro Peláez
 

library rdb

Relations database connector for Door framework

image

door/rdb

Relations database connector for Door framework

  • Sunday, August 2, 2015
  • by serega3000
  • Repository
  • 1 Watchers
  • 0 Stars
  • 4 Installations
  • PHP
  • 1 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 1 Versions
  • 0 % Grown

The README.md

Fork of kohana/database module. Maked it for using standalone., (*1)

Usage example:, (*2)

//creating connection
$database = new Door\RDB\Database\MySQL(array(
    'connection' => array(
        'hostname'   => 'localhost',
        'database'   => 'databasename',
        'username'   => 'username',
        'password'   => 'password',
        'persistent' => FALSE,
    ),
    'table_prefix' => '',
    'charset'      => 'utf8',
    'caching'      => FALSE,
));

//performing queries
$database->list_tables();
$database->list_columns('users');
$database->query(Door\RDB\Database::SELECT, "select * from roles")
    ->execute()
    ->as_array();
$database->select("id,name,email")
    ->from('users')
    ->where('registered',">","2014-01-01")
    ->execute()
    ->as_array();
$database->delete('users')->where('id', '=', 25)->execute();

The Versions

02/08 2015

dev-master

9999999-dev

Relations database connector for Door framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0