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,229 All time: 1,087 This week: 57Up
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 ... <contact>
Classes: 11 packages by
Country: Brazil Brazil
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,229
This week:0
All time:1,087
This week:57Up