Download the PHP package hasan-22/query-builder without Composer

PDO QUERY BUILDER

PHP SQL query builder using PDO. It's a quick and light library featuring a smart join builder, which automatically creates table joins for you.

Features

• Easy interface for creating robust queries
• Supports any database compatible with PDO
• Ability to build complex SELECT, INSERT, UPDATE & DELETE queries with little code
• Type hinting for magic functions with code completion in smart IDEs

  ---

  Install

Driver:

First make the config file exactly like this Config file is not necessary config.php

Then create a custom driver class for the connection like this

Mysql.php

Then create new instance of DB

Set table and fetch all records

In the get() function, you can specify which columns to get

Or you can use all() function to get all records

Execute queries for a single or many record by ID

If you want add condition follow my lead

Some Where functions

Some Having functions

Join functions

You can use where or having condition with join functions

CRUD functions

For insert data use create function

Insert single data

Insert multiple data

Update record

Delete record

Transaction

Debug

Only works on functions whose return value is Object of class DB.

Functions