izniburak/pdox

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

v1.6.0 2021-09-20 20:24 UTC

Requires

• php: >=5.5
• ext-json: *
• ext-pdo: *

MIT

• İzni Burak Demirtaş

• php
• sql
• query
• pdo
• builder

README

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

Fast, efficient and useful Query Builder and PDO Class for #PHP

Install

composer.json file:

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

after run the install command.

$ composer install

OR run the following command directly.

$ 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

Support

izniburak's homepage

izniburak's twitter

Licence

MIT Licence

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