dev-master
9999999-devDatabase helper for PHP
MIT
The Requires
- php >=5.4.0
The Development Requires
database library
v1.0.0
1.0.0.0Database helper for PHP
MIT
The Requires
- php >=5.4.0
The Development Requires
database library
Database helper for PHP
Database query helper. Simple, powerful and expandability., (*1)
<?php # Import SDB packages use SDB\Helper; # Add database server Helper::server('server.address', '3306', 'user', 'password', 'database'); # Create Helper instance. The first parameter is the table prefix $helper = new Helper('table_'); # Execute SELECT query $helper->select()->from('table.name')->query(); # Getting query data $result = $helper->fetchAll(); # $result like follows $result = array( 0 => array( 'field_1' => 'data', 'field_2' => 'data', ... ), 1 => array( 'field_1' => 'data', 'field_2' => 'data', ... ), ... )
SDB requires the following to run
- PHP
: 5.4 or greater, (*3)
Installation is possible using Composer, (*4)
composer require jshadowman/sdb
Simple Example like following. Complete SELECT documentation, (*5)
<?php # Import SDB packages use SDB\Helper; # Add database server Helper::server('server.address', '3306', 'user', 'password', 'database'); # Create Helper instance. The first parameter is the table prefix $helper = new Helper('table_'); # Execute SELECT query $helper->select()->from('table.students')->order('name')->limit(5)->query();
Simple Example like following. Complete INSERT documentation, (*6)
<?php # Import SDB packages use SDB\Helper; # Add database server Helper::server('server.address', '3306', 'user', 'password', 'database'); # Create Helper instance. The first parameter is the table prefix $helper = new Helper('table_'); # Execute SELECT query $helper->insert('table.students')->rows(array( 'name' => 'Kim', 'age' => '10', 'gender' => 'female' ))->query();
Simple Example like following. Complete UPDATE documentation, (*7)
<?php # Import SDB packages use SDB\Helper; use SDB\Expression; # Add database server Helper::server('server.address', '3306', 'user', 'password', 'database'); # Create Helper instance. The first parameter is the table prefix $helper = new Helper('table_'); # Execute SELECT query $helper->update('table.students')->set(array( 'name' => 'Amy' ))->where(Expression::equal('name', 'Kim'))->query();
Simple Example like following. Complete DELETE documentation, (*8)
<?php # Import SDB packages use SDB\Helper; use SDB\Expression; # Add database server Helper::server('server.address', '3306', 'user', 'password', 'database'); # Create Helper instance. The first parameter is the table prefix $helper = new Helper('table_'); # Execute SELECT query $helper->delete('table.students')->where(Expression::equal('name', 'Amy'))->query();
SDB is licensed under the MIT license. Copyright (C) 2016, ChengJie Wang, (*9)
Database helper for PHP
MIT
database library
Database helper for PHP
MIT
database library