Login   Register  
PHP Classes
elePHPant
Icontem

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 del.icio.us Bookmark in del.icio.us
  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,877 This week: 3All time: 1,203 This week: 418Up
Version License Categories  
querygenerator 1.0.0GNU General Public Lice...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: 3331 in United Arab Emirates United Arab Emirates
Week rank: 108 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,877All time:1,203
 This week:3This week:418Up
 User Ratings  
 
 All time
Utility:41%StarStarStar
Consistency:41%StarStarStar
Documentation:-
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:30%StarStar
Rank:2368