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,898 This week: 1All time: 1,200 This week: 1,133Up
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: 32
All time rank: 3321 in United Arab Emirates United Arab Emirates
Week rank: 284 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,898All time:1,200
 This week:1This week:1,133Up
 User Ratings  
 All time