PHP Classes

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-09-23 (8 years ago) RSS 2.0 feedStarStar 30%Total: 2,903 All time: 1,211 This week: 1,104Up
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: 33
All time rank: 3311 in United Arab Emirates United Arab Emirates
Week rank: 555 Down1 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,903All time:1,211
 This week:0This week:1,104Up
 User Ratings  
 All time