1. Go to this page and download the library: Download amin.rz3/pdo-query-builder library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
amin.rz3 / pdo-query-builder example snippets
use App\Database\PDODatabaseConnection;
use App\Database\PDOQueryBuilder;
use App\Exceptions\ConfigValidException;
use App\Exceptions\DatabaseConnectionException;
$config = [
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'db_name',
'db_user' => 'db_user',
'db_password' => 'db_password',
];
try {
$databaseConnection = new PDODatabaseConnection($config);
} catch (ConfigValidException $e) {
}
try {
$pdoQueryBuilder = new PDOQueryBuilder($databaseConnection->connect());
} catch (DatabaseConnectionException $e) {
}
//select all columns
$datas = $pdoQueryBuilder->table('users')->get();
//select two column
$datas = $pdoQueryBuilder->table('users')->get(['name','family']);
//select with where
$datas = $pdoQueryBuilder->table('users')->where(['instagram'=>'amin.rz3'])
->get(['name','family']);
// WHERE name = 'Amin'
$datas = $pdoQueryBuilder->table('users')
->where(['name'=>'Amin'])
->get();
// WHERE id > 50
$datas = $pdoQueryBuilder->table('users')
->where(['id[>]'=>50])
->get();
// WHERE id >= 50
$datas = $pdoQueryBuilder->table('users')
->where(['id[>=]'=>50])
->get();
// WHERE id < 50
$datas = $pdoQueryBuilder->table('users')
->where(['id[<]'=>50])
->get();
// WHERE id <= 50
$datas = $pdoQueryBuilder->table('users')
->where(['id[<=]'=>50])
->get();
// WHERE id != 50
$datas = $pdoQueryBuilder->table('users')
->where(['id[!]'=>50])
->get();
$datas = $pdoQueryBuilder->table('users')
->where([
'OR'=>[
'name[!]'=>'Amin',
'Family[!]'=>'Rahimzadeh'
]])
->get();
// Where name!='Amin' OR Family!='Rahimzadeh'
$datas = $pdoQueryBuilder->table('users')
->where([
'OR'=>[
'name[!]'=>'Amin','
AND'=>[
'Family[!]'=>'Rahimzadeh',
'instagram'=>'amin.rz3'
]
]
])
->get();
// Where name!='Amin' OR (Family!='Rahimzadeh' AND instagram=amin.rz3)
$datas = $pdoQueryBuilder->table('users')
->where([
'name[~]'=>'A'
])
->get();
// Where name LIKE '%A%'
$datas = $pdoQueryBuilder->table('users')
->where([
'name[~]'=>[
'OR'=>[
'A','AM'
]
]
])
->get();
// Where name LIKE '%A%' OR LIKE '%AM%'
$data = $pdoQueryBuilder->table('users')
->where([
'name=>'Amin',
'ORDER'=>[
'id'=>'DESC'
]
])
->get();
// Where name name='Amin' ORDER BY id DESC
$data = $pdoQueryBuilder->table('users')
->where([
'ORDER'=>[
'id'=>[1,2,3,4,5]
]
])
->get();
// ORDER BY FIELD(id,1,2,3,4);
$data = $pdoQueryBuilder->table('users')
->where([
//Get the First 50 Of rows
'LIMIT'=>50,
//Started from the top 10 rows, and the get next 50
'LIMIT'=>[10,50],
])
->get();
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.