jshadowman/sdb

Database helper for PHP

SDB

Database query helper. Simple, powerful and expandability., _(*1)

, _(*2)

<?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',
        ...
    ),
    ...
)

Table of Contents

• Requirements
• Installation
• Features
• Usage
• License

Requirements

SDB requires the following to run - PHP: 5.4 or greater, _(*3)

Installation

Installation is possible using Composer, _(*4)

composer require jshadowman/sdb

Features

• List of Programming
• Automatically generated query
• Humanization design
• Expandability
• PSR4 standard
• Secure

Usage

• SELECT

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();

• INSERT

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();

• UPDATE

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();

• DELETE

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();

License

SDB is licensed under the MIT license. Copyright (C) 2016, ChengJie Wang, _(*9)