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: 595 All time: 5,193 This week: 186Up
Version License PHP version Categories
php-sql-builder 1.0GNU Lesser Genera...5PHP 5, Databases
Description Author

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: 49
All time rank: 30362 in Macedonia Macedonia
Week rank: 595 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);


$SQLbuilder = new 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,193
This week:186Up
For more information send a message to info at phpclasses dot org.