2017 © Pedro Peláez
 

library sdb

Database helper for PHP

image

jshadowman/sdb

Database helper for PHP

  • Saturday, October 8, 2016
  • by JShadowMan
  • Repository
  • 1 Watchers
  • 0 Stars
  • 7 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 2 Versions
  • 0 % Grown

The README.md

SDB

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

Build Status Coverage Status Latest Stable Version License, (*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

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)

The Versions

08/10 2016

dev-master

9999999-dev

Database helper for PHP

  Sources   Download

MIT

The Requires

  • php >=5.4.0

 

The Development Requires

database library

03/09 2016

v1.0.0

1.0.0.0

Database helper for PHP

  Sources   Download

MIT

The Requires

  • php >=5.4.0

 

The Development Requires

database library