Download the PHP package solophp/query-builder without Composer

Solo Query Builder 🛠

A lightweight, fluent SQL query builder for PHP, providing secure and intuitive database interactions.

✨ Features

• Fluent Interface: Chainable methods for building queries.
• CRUD Support: Quickly create, read, update, and delete.
• Secure Binding: Automatic placeholder handling to prevent SQL injection.
• Alias Parsing: Easy table aliasing (e.g., answers_services|a).
• Condition Groups: Complex WHERE clauses with closures.
• Join Clauses: INNER JOIN, LEFT JOIN, RIGHT JOIN support.
• Raw SQL: Safely insert raw SQL snippets when needed.
• HAVING Support: Add HAVING clauses the same way you use WHERE.
• Search Functionality: Easily implement search with keywords across fields.

📥 Installation

Install via Composer:

composer require solophp/query-builder

🚀 Usage

Initialization

use App\Core\QueryBuilder\QueryBuilder;
use Solo\Database;

$db = new Database(/* your config */);
$qb = new QueryBuilder($db);

SELECT

$results = $qb
    ->select(['id', 'title'])
    ->from('posts|p')
    ->where('p.created_at', '>', '2023-01-01')
    ->leftJoin('users|u', 'u.id = p.author_id')
    ->orderBy('p.id', 'DESC')
    ->limit(10)
    ->get();

INSERT

$qb->insert('posts')
    ->values([
        'title' => 'Hello World',
        'content' => 'Welcome to my blog!',
        'author_id' => 1
    ])
    ->execute();

UPDATE

$qb->update('posts')
    ->set(['title' => 'Updated Title'])
    ->where('id', '=', 5)
    ->execute();

DELETE

$qb->delete('posts')
    ->where('id', 'IN', [4, 5, 6])
    ->execute();

Raw SQL

$qb->select()
    ->from('users')
    ->whereRaw('LENGTH(username) > ?i', [10])
    ->get();

Using WHERE

$qb->select()
    ->from('orders|o')
    ->whereGroup(function ($builder) {
        $builder->where('o.status', '=', 'pending')
                ->orWhere('o.payment_status', '=', 'failed');
    })
    ->get();

Using HAVING

You can add HAVING conditions similarly to WHERE. For example, if you want to find categories with more than 10 products:

$results = $qb
    ->select(['p.category', 'COUNT(p.id) AS total'])
    ->from('products|p')
    ->groupBy('p.category')
    ->having('total', '>', 10)
    ->get();

You can also chain multiple conditions, use andHavingGroup(), orHaving(), etc., just like with WHERE.

Using Search

The search method provides a convenient way to search for keywords in specific fields:

You can also search in a specific field using a colon syntax:

The search functionality supports multiple keywords (space-separated) and will apply them with an AND condition.

📘 API Reference

Core Methods

Query Methods (SELECT)

Execution & Results

Examples

Indexed Results:

$users = $qb->select()
    ->from('users')
    ->getIndexedBy('id'); 
// Returns array keyed by user ID

Counting Records:

$total = $qb->select()
    ->from('posts')
    ->where('status', '=', 'published')
    ->count();

Complex Grouping with WHERE:

$results = $qb->select()
    ->from('orders')
    ->whereGroup(function ($builder) {
        $builder->where('status', '=', 'pending')
                ->orWhere('priority', '>', 5);
    })
    ->get();

Using HAVING:

$results = $qb->select(['p.category', 'COUNT(p.id) AS total'])
    ->from('products|p')
    ->groupBy('p.category')
    ->having('total', '>', 10)
    ->get();
```

**Using Search:**

## ✅ Requirements

- PHP 8.2+
- [solophp/database](https://github.com/solophp/database) for database connections

## 📄 License

MIT License. See [LICENSE](LICENSE).