PHP Classes

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

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
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: 42
All time rank: 3421 in United Arab Emirates United Arab Emirates
Week rank: 214 Up1 in United Arab Emirates United Arab Emirates Equal

  Files folder image Files (2)  
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

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: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:4303