emma / dbal
Emma Database Access Layer. Rely solely on the in-built PHP PDO and FAST. Also, comes with advanced Query Builder for more flexibility and searching and with parameterized queries to prevent against sqli or other sql attacks
Installs: 35
Dependents: 4
Suggesters: 0
Security: 0
Stars: 0
Watchers: 1
Forks: 0
Open Issues: 0
pkg:composer/emma/dbal
Requires
- php: >=8.0
- emma/common: ^1.1.4
README
Emma Database Access Layer. Rely solely on the in-built PHP PDO and FAST. Also, comes with advanced Query Builder for more flexibility and searching and with parameterized queries to prevent against sqli or other sql attacks
#Example:
$connection = ConnectionManager::createConnection([
"host" => "localhost",
"username" => "root",
"password" => "",
"dbname" => "mytest",
"port" => 3306,
"driver" => \Emma\Dbal\Connection\Drivers::MYSQL
]);
$sqlQuery = new Query();
$sqlQuery->QB()->delete()->from("table");
$criteria = []; //KeyValue pair
$dataTypes = []; //Optional
$sqlQuery = CriteriaHandler::handle($sqlQuery, $criteria, $dataTypes);
$sqlQuery->execute();
More documentation coming...