Projects / SQL Query Builder

SQL Query Builder

SQL Query Builder is a PHP 5 class that generates simple SQL queries (select, insert, update, and delete) that can be sent to an SQL server. It provides an intuitive class-based way to build queries instead of crafting complicated one-line or concatenated-string queries by hand. It is very useful for dynamic queries, and is appropriate for AJAX applications. It also features simple and optional error reporting.

Tags
Implementation

Recent releases

  •  06 Jan 2006 12:30

    No changes have been submitted for this release.

    Recent comments

    06 Jan 2006 07:56 aaronmueller

    Uhm ...
    Sorry, but this pice of code is useless (for me). I write the query much faster in one line instead of set all query-parameters with seperate methods.

    The Insert-Method is good, but you can overload the method to set a new colum + value in one line e.g.

    $query->addColumn("email", "david@example.com");

    Screenshot

    Project Spotlight

    OpenStack4j

    A Fluent OpenStack client API for Java.

    Screenshot

    Project Spotlight

    TurnKey TWiki Appliance

    A TWiki appliance that is easy to use and lightweight.