inanepain/db

Some helpers for database task and query construction.

0.2.0 2025-04-24 22:53 UTC

Requires

• php: >=8.1
• inanepain/stdlib: * || dev-master || dev-develop

Unlicense

• Philip Michael Raab

• database
• sql
• db
• mysql
• query
• builder
• inane
• PostgresSQL

README

Table of Contents

• inanepain/db
• Install
• Usage
  • SQLQueryBuilder
• Revision

inanepain/db

Some helpers for database task and query construction.

Install

Example 1. composer

composer require inanepain/db

Usage

SQLQueryBuilder

$qb = new SQLQueryBuilder();
$query = $qb
    ->select('users', ['name', 'email', 'password'])
    ->where('age', 18, '>')
    ->where('age', 30, '<')
    ->limit(10, 20);

echo "-- Testing MySQL query builder:\n";
echo $qb->getSQLFor(new MysqlQueryBuilder());

echo "\n\n";

echo "-- Testing PostgresSQL query builder:\n";
echo $qb->getSQLFor(new PostgresQueryBuilder());

Which should give you:

-- Testing MySQL query builder:
SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10, 20;

-- Testing PostgresSQL query builder:
SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10 OFFSET 20;

Revision

version: $Id$ ($Date$)