PHP Classes

PHP SQL builder class: Build and execute MySQL queries from parameters

Recommend this page to a friend!
  Info   View files Documentation   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 596 All time: 5,203 This week: 189Up
Version License PHP version Categories
php-sql-builder 1.0GNU Lesser Genera...5PHP 5, Databases


This class can build and execute MySQL queries from parameters.

It can take parameters that define a table name, table fields, field values and condition clauses.

The class can assemble a SQL query of a given type (SELECT, INSERT, UPDATE and DELETE) and executes the query in a MySQL database.

Picture of Goran Jordanoski
Name: Goran Jordanoski <contact>
Classes: 1 package by
Country: Macedonia Macedonia
Age: 50
All time rank: 30462 in Macedonia Macedonia
Week rank: 410 Up1 in Macedonia Macedonia Up

This is simple class that I use to get user friendly insert/update SQL. Instead of INSERT INTO (field, field, field, field) VALUES(value, value, value value); /* Example: $SQLbuilder = new SQLbuilder(); $SQLbuilder->setTableName('SQLbuilder'); $SQLbuilder->addField('creator_first_name', 'Goran'); $SQLbuilder->addField('creator_last_name', 'Jordanoski'); $SQLbuilder->addField('creator_email', ''); $SQLbuilder->addField('creator_linkedin', ''); $SQLbuilder->addField('creator_occupation', 'outsourcing'); $SQLbuilder->addField('date_entered', 'NOW()', 'not_quoted'); $query = $SQLbuilder->getSQL();
  Files folder image Files  
File Role Description
Plain text file README.txt Doc. text file
Plain text file SQLbuilder.php Class Class file

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:5,203
This week:189Up