Simple Mysql PDO CRUD library
Install with Composer
Add cahkampung/landa-db to require in composer.json
"require": { "cahkampung/landa-db": "^1.2" },
Run composer install
$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);
$db->insert(TABLE_NAME, DATA);
Example :
$data = [
'name' => 'john',
'email' => '[email protected]'
];
$db->insert('user_table', $data);
$db->update(TABLE_NAME, DATA, PARAMS);
Example :
$data = [
'name' => 'john',
'email' => '[email protected]'
];
$db->update('user_table', $data, ['id' => 1]);
$db->delete(TABLE_NAME, PARAMS);
Example :
$db->delete('user_table', ['id' => 1]);
select(FIELDS)
FIELDS can be array format, default value is *
from(TABLE)
where(FIELD_NAME, FILTER, VALUE)
andWhere(FIELD_NAME, FILTER, VALUE)
andWhere(FIELD_NAME, FILTER, VALUE)
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 TYPE, TABLE, ONCLAUSE)
leftJoin(TABLE, ONCLAUSE)
rightJoin(TABLE, ONCLAUSE)
innerJoin(TABLE, ONCLAUSE)
limit(INT)
offset(INT)
orderBy(FIELD)
groupBy(FIELD)
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();
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();
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent