gurpreetkaits/simple-query-builder

A simple query builder for php applications

0.0.1 2023-10-30 13:07 UTC

Requires

• php: ^8.1

Requires (Dev)

• phpunit/phpunit: ^9.5

MIT

• Robin kashyap

README

Simple Query Builder is a PHP library that provides a simple and easy-to-use query builder for constructing SQL queries. It allows you to build SELECT queries with various conditions, joins, and more. Currently building the library, it's not available for all types of databases. Contributions are welcome ❤️

Installation

 
composer require gurpreetkaits/simple-query-builder 

Simple Example Of Execution

 <?php

ini_set('display_errors', 1);

use GurpreetKaits\Builder\Connection;
use GurpreetKaits\Builder\Query;

require 'vendor/autoload.php';


$config = [
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'password',
    'database' => 'test'
];
$connection = (new Connection($config))::connect();

$selectQuery = (new Query($connection))
    ->table('award_icons')
    ->select('*')
    ->where('id', '=', 33)
    ->get();

echo '<pre>';
print_r($selectQuery);

Array
(
    [0] => Array
        (
            [id] => 33
            [title] => Award
            [icon] => award
            [created_at] => 2023-10-09 14:59:17
            [updated_at] => 2023-10-09 14:59:17
        )

)