2017 © Pedro Peláez
 

library db-querybuilder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

image

hybridlogic/db-querybuilder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

  • Saturday, January 12, 2013
  • by Dachande663
  • Repository
  • 2 Watchers
  • 10 Stars
  • 22 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 1 Forks
  • 0 Open issues
  • 4 Versions
  • 0 % Grown

The README.md

DB Query Builder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases., (*1)

0.0 Table of Contents

  • Introduction
  • Examples
  • Running Tests
  • Troubleshooting
  • Changelog

1.0 Introduction

Query Builder makes it effortless to create complex SQL statements from simple method calls. With support for escaping and aliasing, you'll never worry about injecting the wrong data into your database ever again., (*2)

Query Builder currently targets the MySQL version of the SQL specification., (*3)

@todo Add composer dependency for github.com/Dachande663/PHP-DB, (*4)

2.0 Examples

$sql = Query::select(array('m.name', 'movie'), array('t.name', 'theatre_name'), 'visited_date')
    ->from(array('visits', 'v'))
    ->join(array('movies', 'm'))->on('v.movie_id', '=', 'm.id')
    ->join(array('theatres', 't'))->on('v.theatre_id', '=', 't.id')
    ->where('m.rating', '>=', 80)
    ->order_by('v.visited_date', 'DESC')
    ->limit(5)
    ->as_object('MovieVisit')
    ->sql();

3.0 Running Tests

phpunit tests, (*5)

Please note the test suite is currently incomplete., (*6)

4.0 Troubleshooting

@todo, (*7)

5.0 Changelog

  • [2012-12-08] Initial Version
  • [2013-01-02] First Release

The Versions

12/01 2013

dev-master

9999999-dev https://github.com/Dachande663/PHP-DB-QueryBuilder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

  Sources   Download

MIT

The Requires

 

by Luke Lanchester

sql query mysql db querybuilder

12/01 2013

v1.0.2

1.0.2.0 https://github.com/Dachande663/PHP-DB-QueryBuilder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

  Sources   Download

MIT

The Requires

 

by Luke Lanchester

sql query mysql db querybuilder

12/01 2013

v1.0.1

1.0.1.0 https://github.com/Dachande663/PHP-DB-QueryBuilder

A MySQL Query Builder for effortlessly composing SQL statements with support for executing them against databases.

  Sources   Download

MIT

The Requires

 

by Luke Lanchester

sql query mysql db querybuilder

03/01 2013

v1.0.0

1.0.0.0

SQL Query Builder for easily generating dynamic queries

  Sources   Download

The Requires

  • php >=5.3.0

 

sql query mysql db querybuilder