izniburak / Pdox
Licence: mit
useful query builder class that works with PHP PDO class for simple access your data.
Stars: ✭ 217
Labels
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
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
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
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
PDOx
_____ _____ ____
| __ \| __ \ / __ \
| |__) | | | | | | |_ __
| ___/| | | | | | \ \/ /
| | | |__| | |__| |> <
|_| |_____/ \____//_/\_\
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
Licence
Contributing
- Fork it ( https://github.com/izniburak/pdox/fork )
- Create your feature branch (git checkout -b my-new-feature)
- Commit your changes (git commit -am 'Add some feature')
- Push to the branch (git push origin my-new-feature)
- 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].