PHP Classes

MySQL Query Builder: Build and execute MySQL queries from parameters

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 55%Total: 1,174 All time: 3,224 This week: 146Up
Version License PHP version Categories
mysql-query-builder 1.3GNU General Publi...5.3PHP 5, Databases, Security
Description 

Author

This class can build and execute MySQL queries from parameters.

It can build SQL statements that define query parameters such as table name, field names and values, condition clauses, etc.

Currently it can build and execute SQL statements of SELECT, INSERT, UPDATE, DELETE and REPLACE queries.

The class encodes all the names of tables and fields, and text field values before executing to prevent SQL injection security exploits.

Picture of Rodrigo Brandão
  Performance   Level  
Name: Rodrigo Brandão <contact>
Classes: 4 packages by
Country: Brazil Brazil
Age: 38
All time rank: 87560 in Brazil Brazil
Week rank: 164 Up12 in Brazil Brazil Up

  Files folder image Files (4)  
File Role Description
Files folder imagelib (2 files)
Accessible without login Plain text file example.php Example How to use the class.
Accessible without login HTML file readme.html Doc. Documentation

  Files folder image Files (4)  /  lib  
File Role Description
  Accessible without login Plain text file config.php Conf. The config file
  Plain text file mysql.class.php Class The class

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:1,174
This week:0
All time:3,224
This week:146Up
User Ratings User Comments (1)
 All time
Utility:68%StarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:62%StarStarStarStar
Examples:62%StarStarStarStar
Tests:-
Videos:-
Overall:55%StarStarStar
Rank:1990