KOPDO::connect(DB_STRING, DB_USER, DB_PASS);
$id = KOPDO::insert('test', [
'name'=> 'Flavio',
'surname'=> 'Kopiro',
'friends'=> ['A','B','C']
'phones'=> [
'ita'=> '+391231231234',
'usa'=> '+02998898',
'uk'=> ['09956','923752']
]
]);
The data passed as array/objects are automatically serialized in the database.
KOPDO::all('test', 'name, surname, friends, phone');
Data are automatically unserialized when requested.
Will return an indexed array with inside an associative array with datas.
KOPDO::update('test', ['name'=> 'Flavioooo'], 'id=:id', [ ':id'=>$id ]);
KOPDO::first('test', '*', 'id=:id', [':id'=>$id]);
KOPDO::first('test', '*', "name LIKE '%:name%'", [':name'=>'flavio']);
or
KOPDO::first('test', '*', 'id=1');
Will return an associative array with datas.
KOPDO::indexed('test', 'id');
Will return an indexed array of IDs. [1,2,3,4]
KOPDO::delete('test', "name LIKE '%:name%'", [':name'=>'flavio']);