Simple Query Builder

Introduction

simple-query-builder is a lightweight and flexible query builder designed for developers who work with Core PHP and want an easy, fluent API to interact with databases. Whether you are building a small application or integrating into an existing project, this package provides an intuitive way to construct SQL queries dynamically.

With method chaining, automatic parameter binding, and support for SELECT, INSERT, UPDATE, DELETE, JOINs, ORDER BY, GROUP BY, this package simplifies database interactions while maintaining security and efficiency.

🚀 Features

• Fluent API: Chain methods to build SQL queries easily.
• Parameter Binding: Prevents SQL injection by using prepared statements.
• Supports WHERE, AND, OR, JOINs, ORDER BY, GROUP BY
• Lightweight: No dependencies apart from PHP and PDO.
• Supports Pagination with LIMIT and OFFSET
• Easy Integration: Works with any Core PHP project.

🔧 Installation

To install simple-query-builder, run the following command:

composer require robinksp/simple-query-builder

                
                Copy
            

🏗️ Basic Usage

1. Connecting to the Database

<?php
require 'vendor/autoload.php';

use robinksp\querybuilder\Connection;
use robinksp\querybuilder\Query;

$config = [
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'password',
    'database' => 'test'
];

$connection = (new Connection($config))::connect();

                
                Copy
            

2. Running a Simple Select Query

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

print_r($users);

                
                Copy
            

3. Insert Data

$insertId = (new Query($connection))
    ->table('users')
    ->insert([
        'name' => 'John Doe',
        'email' => 'john@example.com'
    ]);

echo "Inserted record with ID: $insertId";

                
                Copy
            

4. Update Data

$rowsAffected = (new Query($connection))
    ->table('users')
    ->where('id', '=', 33)
    ->update([
        'name' => 'Updated Name'
    ]);

echo "Updated $rowsAffected record(s)";

                
                Copy
            

5. Delete Data

$deletedRows = (new Query($connection))
    ->table('users')
    ->where('id', '=', 33)
    ->delete();

echo "Deleted $deletedRows record(s)";

                
                Copy
            

6. Using WHERE with Multiple Conditions

$query = (new Query($connection))
    ->table('users')
    ->select('*')
    ->where('status', '=', 'active')
    ->andWhere('role', '=', 'admin')
    ->get();

print_r($query);

                
                Copy
            

7. Using Joins

$usersWithCars = (new Query($connection))
    ->table('users')
    ->select('users.*, cars.model')
    ->join('cars', 'users.id', '=', 'cars.user_id')
    ->where('cars.color', '=', 'blue')
    ->get();

print_r($usersWithCars);

                
                Copy
            

8. Ordering and Grouping Data

$orderedUsers = (new Query($connection))
    ->table('users')
    ->select('*')
    ->groupBy('role')
    ->orderBy('name', 'ASC')
    ->get();

print_r($orderedUsers);

                
                Copy
            

9. Count Rows

$userCount = (new Query($connection))
    ->table('users')
    ->where('status', '=', 'active')
    ->count();

echo "Total active users: $userCount";

                
                Copy
            

10. Raw SQL Output

If you want to see the raw SQL query being generated, use toSql():

$query = (new Query($connection))
    ->table('users')
    ->select('*')
    ->where('status', '=', 'active')
    ->toSql();

echo $query;

                
                Copy
            

🎯 Contributing

Contributions are welcome! If you would like to improve simple-query-builder, follow these steps:

1. Fork the repository on GitHub.

2. Clone your fork:

   git clone https://github.com/your-username/simple-query-builder.git
   
                   
                   Copy
               

3. Navigate to the project folder:

   cd simple-query-builder
   
                   
                   Copy
               

4. Install dependencies:

   composer install
   
                   
                   Copy
               

5. Run tests:

   composer test
   
                   
                   Copy
               

6. Make your changes and commit them:

   git commit -m "Added a new feature"
   
                   
                   Copy
               

7. Push to your fork:

   git push origin main
   
                   
                   Copy
               

8. Create a Pull Request (PR) on GitHub.

📜 License

This project is licensed under the MIT License.

💬 Need Help?

If you have any questions or suggestions, feel free to open an issue on GitHub or contact the author.

Happy coding! 🚀