All Projects → izniburak → Pdox

izniburak / Pdox

Licence: mit
useful query builder class that works with PHP PDO class for simple access your data.

Projects that are alternatives of or similar to Pdox

React Awesome Query Builder
User-friendly query builder for React
Stars: ✭ 682 (+214.29%)
Mutual labels:  sql, query-builder
Evolutility Server Node
Model-driven REST or GraphQL backend for CRUD and more, written in Javascript, using Node.js, Express, and PostgreSQL.
Stars: ✭ 84 (-61.29%)
Mutual labels:  sql, query-builder
Reiner
萊納 - A MySQL wrapper which might be better than the ORMs and written in Golang
Stars: ✭ 19 (-91.24%)
Mutual labels:  sql, query-builder
Loukoum
A simple SQL Query Builder
Stars: ✭ 305 (+40.55%)
Mutual labels:  sql, query-builder
Sqlkit
SQL builder and powerful database toolkit for Golang
Stars: ✭ 117 (-46.08%)
Mutual labels:  sql, query-builder
Latitude
A SQL query builder with zero dependencies
Stars: ✭ 554 (+155.3%)
Mutual labels:  sql, query-builder
Squid
🦑 Provides SQL tagged template strings and schema definition functions.
Stars: ✭ 57 (-73.73%)
Mutual labels:  sql, query-builder
Android Orma
An ORM for Android with type-safety and painless smart migrations
Stars: ✭ 442 (+103.69%)
Mutual labels:  sql, query-builder
Postguard
🐛 Statically validate Postgres SQL queries in JS / TS code and derive schemas.
Stars: ✭ 104 (-52.07%)
Mutual labels:  sql, query-builder
Go Structured Query
Type safe SQL query builder and struct mapper for Go
Stars: ✭ 101 (-53.46%)
Mutual labels:  sql, query-builder
Sqliterally
Lightweight SQL query builder
Stars: ✭ 231 (+6.45%)
Mutual labels:  sql, query-builder
Querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Stars: ✭ 2,111 (+872.81%)
Mutual labels:  sql, query-builder
Sqlz
SQL Query Builder for Go
Stars: ✭ 36 (-83.41%)
Mutual labels:  sql, query-builder
Sql
A delightful SQL ORM ☺️
Stars: ✭ 89 (-58.99%)
Mutual labels:  sql, query-builder
Dbr
Additions to Go's database/sql for super fast performance and convenience. (fork of gocraft/dbr)
Stars: ✭ 140 (-35.48%)
Mutual labels:  sql, query-builder
Sqorn
A Javascript library for building SQL queries
Stars: ✭ 1,871 (+762.21%)
Mutual labels:  sql, query-builder
Pgbadger
A fast PostgreSQL Log Analyzer
Stars: ✭ 2,522 (+1062.21%)
Mutual labels:  sql
Splitgraph
Splitgraph command line client and python library
Stars: ✭ 209 (-3.69%)
Mutual labels:  sql
Pgsodium
Modern cryptography for PostgreSQL using libsodium.
Stars: ✭ 202 (-6.91%)
Mutual labels:  sql
Steampipe
Steampipe command line interface (CLI)
Stars: ✭ 200 (-7.83%)
Mutual labels:  sql

PDOx

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

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

Total Downloads Latest Stable Version Latest Unstable Version License

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
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].