mamadou-aly-sy / query-builder
A simple php query builder
1.0.0
2021-10-14 21:55 UTC
Requires
- ext-pdo: *
Requires (Dev)
- phpunit/phpunit: ^9.5
This package is auto-updated.
Last update: 2024-06-09 02:05:28 UTC
README
A simple php query builder form mysql database
Requirements
php version:
>=8.0
Basic Usage
<?php require_once './vendor/autoload.php'; queryBuilder = new \MamadouAlySy\QueryBuilder(); $query = $queryBuilder ->from('user') ->select() ->everything() ->getQuery(); $sql = $query->getSql(); $parameters = $query->getParameters();
NOTE:
In order to execute the query directly inside the query builder you should pass an object
in the constructor that implement the following interface:
ConnectionInterface.php
:
<?php namespace MamadouAlySy\Interfaces; interface ConnectionInterface { public function open(): \PDO; }
after that you can use get, first, commit
methods to execute queries.
commit()
execute a query without resultfirst()
execute a query and get one resultget()
execute a query and get all result
<?php // Create the user table $queryBuilder->create() ->table('users') ->field('id')->int()->notNull()->autoIncrement() ->field('username')->string()->default('mamadou') ->commit(); // Getting all users $users = $queryBuilder ->from('user') ->select()->everything() ->get(); // Getting one user $user = $queryBuilder ->from('user') ->where('id')->equal(1) ->select()->everything() ->first(); // Insert a user $queryBuilder ->insert(['username' => 'Mamadou'])->into('user') ->commit();