rkr/php-mysql-query-builder

Easy to use query builder for PHP7.1+/PDO


README

Scrutinizer Code Quality Build Status Latest Stable Version License

Simple mysql query builder to build select, insert, update and delete queries with conditional parts. This library was initially not intended to build prepared statements, but this is also possible. The main motive for this library is an environment where a lot of things are automated.

Here a few things to keep in mind:

  • The charset is up to you. No special binding to UTF8, although UTF8 is the default.
  • You're allowed to nest most queries to build big and powerful queries.
  • The order of method-calls of each statement-builder is irrelevant. The resulting query will always render the right order.

Some simplified examples

Some extended examples