PHP Classes

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

Recommend this page to a friend!
  Info   Documentation   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 24%Total: 597 All time: 5,220 This week: 455Up
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

 

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 (2)  
File Role Description
Plain text file README.txt Doc. text file
Plain text file SQLbuilder.php Class Class file

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:597
This week:0
All time:5,220
This week:455Up
 User Ratings  
 
 All time
Utility:25%StarStar
Consistency:58%StarStarStar
Documentation:66%StarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:24%StarStar
Rank:4453