hilmanrdn/pirlo-db

Simple class to work with database

Pirlo_DB :: PDO Abstract Class

Abstract database class using PDO, the end syntax inspired by Eloquent from laravel but more basic implementations [Eloquent Laravel] (https://laravel.com/docs/5.1/eloquent). Not much tested yet, it made for my own learning purpose but feel free to use it on your project, and let me know if there are any bugs or anything i can improve., _(*1)

Install

composer require "hilmanrdn/pirlo-db: dev-master"

Todo

• show error, success or fail
• return as JSON
• join
• other relations

Usage Example

• Load database, _(*2)

  use PirloDB\Database;
  
  require_once 'vendor/autoload.php';
  
  $test = Database::getInstance($server, $user, $pass, $db_name);
  $test->setTable($tableName);
  

• Select and retrieve data, _(*3)

  Always use select!, _(*4)

  Select() can be blank to select all columns, or specify column(s) name in one string., _(*5)

  There are two possibilities, use all() to get an array, or first() for only one data, _(*6)

  $test->select()->all();
  $test->select()->first();
  $test->select('username, id')->first();
  

• Where, _(*7)

  Where() has 3 parameters (column, sign and value), _(*8)

  It can be used multiple times to use 'AND', or use orwhere() to use 'OR', _(*9)

  $test->where('username', '=', 'name')->first();
  $test->select('username')->where('username', '=', 'name')->all();
  $test->where('username', '=', 'hilman')->where('password', '=', 'password')->all();
  $test->where('username', '=', 'name1')->orWhere('username', '=', 'name2')->all();
  

• Insert, _(*10)

  Use create() and associatve array which formatted by column_name => column_value, _(*11)

  $test->create([
  'username' => 'name',
  'password' => 'pass',
  ]);  
  

• Update, _(*12)

  Use where() to select which row want to be entered, _(*13)

  $test->where('username', '=', 'name')->update([
  'username' => 'newName',
  'password' => 'newPass',
  ]);
  

• Delete, _(*14)

  Use where() to select which row want to be deleted, _(*15)

  $test->where('username', '=', 'name')->delete();
  

• orderBy, _(*16)

  orderBy() has two parameter (column and type[DESC or ASC]), _(*17)

  $test->select()->orderBy('username', 'DESC')->all();
  

• take, _(*18)

  take to limit the result, put the number as parameter, if chained with orderBy(), orderBy() must be used first, _(*19)

  $test->select()->orderBy('username', 'DESC')->take(3)->all();