cahkampung/landa-db

Mysql POD library

1.3.2 2021-12-23 04:03 UTC

Requires

• php: >=5.4
• ext-pdo: *

AFL-1.1

• Wahyu Agung Tribawono

• framework
• database
• pdo
• slim

README

Simple Mysql PDO CRUD library

Installation

Install with Composer

Add cahkampung/landa-db to require in composer.json

"require": { "cahkampung/landa-db": "^1.2" },

Run composer install

How To Use

Connection

$config = [
  'DB_DRIVER'      => 'mysql',
  'DB_HOST'        => 'localhost',
  'DB_USER'        => 'root',
  'DB_PASS'        => 'password',
  'DB_NAME'        => 'database',
  'CREATED_USER'   => 'created_by',
  'CREATED_TIME'   => 'created_at',
  'CREATED_TYPE'   => 'int',
  'MODIFIED_USER'  => 'modified_by',
  'MODIFIED_TIME'  => 'modified_at',
  'MODIFIED_TYPE'  => 'int',
  'DISPLAY_ERRORS' => false,
  'USER_ID'        => $_SESSION['user']['id'],
];

$db = new Cahkampung\Landadb($config);

Insert

$db->insert(TABLE_NAME, DATA);

Example :

$data = [
  'name' => 'john',
  'email' => '[e-mail]'
];

$db->insert('user_table', $data);

Update

$db->update(TABLE_NAME, DATA, PARAMS);

Example :

$data = [
  'name' => 'john',
  'email' => '[e-mail]'
];

$db->update('user_table', $data, ['id' => 1]);

Delete

$db->delete(TABLE_NAME, PARAMS);

Example :

$db->delete('user_table', ['id' => 1]);

Select

select()

select(FIELDS)

FIELDS can be array format, default value is *

from()

from(TABLE)

where()

where(FIELD_NAME, FILTER, VALUE)

andWhere()

andWhere(FIELD_NAME, FILTER, VALUE)

orWhere()

andWhere(FIELD_NAME, FILTER, VALUE)

customWhere()

customWhere(WHERE_STRING, FILTER)

Default filter is And

Example :

customWhere('name = "john" or nationallity = "indonesia"', 'AND');

Will generate AND (name="john" or nationallity="indonesia");

join()

join(JOIN TYPE, TABLE, ONCLAUSE)

leftJoin()

leftJoin(TABLE, ONCLAUSE)

rightJoin()

rightJoin(TABLE, ONCLAUSE)

innerJoin()

innerJoin(TABLE, ONCLAUSE)

limit()

limit(INT)

offset()

offset(INT)

orderBy()

orderBy(FIELD)

groupBy

groupBy(FIELD)

findAll()

Fetch all result from query

Example :

$db->findAll('select * from user_table where name like "%john%" order by name ASC limit 10 offset 0');

Or

$db->select()
    ->from('user_table')
    ->where('name','LIKE','john')
    ->limit(10)
    ->offset(0)
    ->orderBy('name ASC')
$getUsers = $db->findAll();

find()

Fetch 1 results from query

Example :

$db->find('select * from user_table where name like "%john%" order by name ASC');

Or

$db = new Cahkampung\Landadb;
$db->select()
    ->from('user_table')
    ->where('name','LIKE','john')
    ->orderBy('name ASC')
$getUsers = $db->find();