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,212 This week: 189Up
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: 50
All time rank: 30562 in Macedonia Macedonia
Week rank: 312 Up1 in Macedonia Macedonia Up

Documentation

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', 'berezitski@gmail.com'); $SQLbuilder->addField('creator_linkedin', 'http://www.linkedin.com/in/berezitski'); $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  
 0%
Total:596
This week:0
All time:5,212
This week:189Up