PHP Classes

Advanced Search: Compose and execute MySQL database SELECT queries

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
Not enough user ratingsTotal: 3,227 All time: 1,088 This week: 44Up
Version License PHP version Categories
advanced_search 1.0GNU Free Document...5.0HTML, PHP 5, Databases, Searching
Description 

Author

This class can be used to compose and execute MySQL database SELECT queries.

It can generate HTML to display form inputs to choose fields or conditions for the SQL WHERE clause.

The class can assemble the SQL to perform a search with the given fields and conditions in a given MySQL database table.

The code and comments are in Portuguese.

In Portuguese:

Com essa classe é possível fazer buscas avançadas com diversas clausulas, listar seus resultados com os campos que quiser, e fazer uma busca com várias palavras usando o operador boleano OR.

Picture of Igor Herson Aquino de França
Name: Igor Herson Aquino de ... is available for providing paid consulting. Contact Igor Herson Aquino de ... .
Classes: 11 packages by
Country: Brazil Brazil
Age: 41
All time rank: 22614 in Brazil Brazil
Week rank: 197 Up16 in Brazil Brazil Down
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file cidades.sql Data sql for test
Plain text file search.class.php Class class source
Accessible without login Plain text file test.php Example file for test

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:3,227
This week:0
All time:1,088
This week:44Up