sapistudio / filedatabase
This package is abandoned and no longer maintained.
No replacement package was suggested.
Fork after https://github.com/Greg0/Lazer-Database
2.0.5
2024-09-22 22:17 UTC
Requires
- php: >=5.6
README
composer require sapistudio/filedatabase
Ending methods
addFields()
- append new fields into existing tabledeleteFields()
- removing fields from existing tablesave()
- insert or Update data.delete()
- deleting data.getConfig()
- returns object with configuration.fields()
- returns array with fields name.schema()
- returns assoc array with fields name and fields typefield => type
.get()
- returns one row with specified ID.findAll()
- returns all rowsasArray()
- returns data as indexed or assoc array:['field_name' => 'field_name']
. Should be used after ending methodselect
.count()
- returns the number of rows. Should be used after ending methodfind_all()
orfind()
.
Initiate
use \SapiStudio\FileDatabase\Handler as Database; $dbObject = Database::load($dbname,['dir' => 'path/to/database/dir','fields' => $[{field_name} => {field_type}]]);
Remove database
$dbObject->removeDatabase();
Check if a database exists
$dbObject->exists();//return boolean
Multiple select
$rows = $dbObject->findAll(); foreach($rows as $row) { print_r($row); }
Single record select
$row = $dbObject->get(1); echo $row->id;
Insert
If the field doesnt exists,it will append that field,with type of string
$dbObject->nickname = 'new_user'; $dbObject->save();
Do not set the ID.
Update
$row = $dbObject->get(1); //Edit row with ID 1 $row->nickname = 'edited_user'; $row->save();
Single record deleting
$dbObject->get(1)->delete(); //Will remove row with ID 1
Multiple records deleting
$dbObject->query()->where('name', '=', 'John')->find()->delete(); //Will remove John from DB
Clear table
$dbObject->truncate();