library pdox

izniburak/pdox

Useful Query Builder, PDO Class for PHP. A simple access to your SQL records.

PDOx

 _____  _____   ____       
 |  __ \|  __ \ / __ \      
 | |__) | |  | | |  | |_  __
 |  ___/| |  | | |  | \ \/ /
 | |    | |__| | |__| |>  <
 |_|    |_____/ \____//_/\_\

Fast, efficient and useful Query Builder and PDO Class for #PHP, _(*1)

, _(*2)

Install

composer.json file:, _(*3)

{
    "require": {
        "izniburak/pdox": "^1"
    }
}

after run the install command., _(*4)

$ composer install

OR run the following command directly., _(*5)

$ composer require izniburak/pdox

Example Usage

require 'vendor/autoload.php';

$config = [
    'host'      => 'localhost',
    'driver'    => 'mysql',
    'database'  => 'test',
    'username'  => 'root',
    'password'  => '',
    'charset'   => 'utf8',
    'collation' => 'utf8_general_ci',
    'prefix'     => ''
];

$db = new \Buki\Pdox($config);

$records = $db->table('users')
        ->select('id, name, surname, age')
        ->where('age', '>', 18)
        ->orderBy('id', 'desc')
        ->limit(20)
        ->getAll();

var_dump($records);

Docs

Documentation page: PDOx Docs, _(*6)

Support

izniburak's homepage, _(*7)

izniburak's twitter, _(*8)

Licence

MIT Licence, _(*9)

Contributing

1. Fork it ( https://github.com/izniburak/pdox/fork )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request

Contributors

• izniburak İzni Burak Demirtaş - creator, maintainer
• Others