dbpp is a library that simplifies database queries by collecting them into one class.
WARNING! Repository migrated to https://github.com/PPEco/dbpp
dbpp requires composer and php 8.0 or higher.
For installation run this command in composer:
composer require levkopo/dbpp
The main class for dbpp is Database. Create a class extended from Database from dbpp.
class SimpleDatabase extends Database {
}
Create a class that will contain all the queries for a specific table. The class should be extended from the Dao class from dbpp.
class TableDao extends Dao {
}
Create functions with query annotations from dbpp. They can be Query and Insert. Functions should call a function from parent (IDE may throw an error, but don't worry).
class TableDao extends Dao {
#[Query("SELECT * FROM `table`")
public function getAll(): array|false {
parent::getAll();
}
#[Query("SELECT * FROM `table` WHERE `id` = :id")
public function getById(int $id){
parent::getAll($id);
}
#[Insert("table")
public function insert(Value $value): bool{
parent::insert($value);
}
}
Link your Dao to Database via class properties.
class SimpleDatabase extends Database {
public TableDao $table;
}
Well, the final steps. Create PDO object and call static method from DBPP: init
$pdo = new PDO(*data*);
$database = new SimpleDatabase();
DBPP::init($database, $pdo);
Now you can call methods from the Database class