PHP Classes

Search Query Generator for MySQL Database: Generate an SQL query for searching values

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 30%Total: 2,944 All time: 1,269 This week: 455Up
Version License Categories
querygenerator 1.0.0GNU General Publi...Databases, Searching
Description 

Author

This is a very simple class that can be used to build a SQL WHERE clause for performing a query that search for given field values.

It takes as parameter an associative array with the field names as indexes and the field search parameter values as array entry values.

It generates an SQL SELECT query to retrieve all table fields of the records that match a condition defined by the combination of all fields and values defined by the parameter associative array.

Picture of Shoeb
Name: Shoeb <contact>
Classes: 3 packages by
Country: United Arab Emirates United Arab Emirates
Age: 41
All time rank: 3421 in United Arab Emirates United Arab Emirates
Week rank: 321 Up1 in United Arab Emirates United Arab Emirates Equal

  Files folder image Files  
File Role Description
Plain text file generator.class.php Class This is the main class to generate the query
Accessible without login Plain text file Usage_Example Example this is the post submit part

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,944
This week:0
All time:1,269
This week:455Up
 User Ratings  
 
 All time
Utility:41%StarStarStar
Consistency:41%StarStarStar
Documentation:-
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:30%StarStar
Rank:4266