PHP Classes

PHP Search: Search for data MySQL tables and show the results

Recommend this page to a friend!
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 67%Total: 8,726 All time: 186 This week: 555Down
Version License Categories
phpsearch 1.0.0GNU General Publi...Databases, Searching
Description 

Author

This class can perform basic searches in MySQL tables.

It can take parameters that define the tables and fields to be searched and retrieved and the fields that define the results sorting order.

The class returns the search results in the form of an HTML table or a text displaying a message when the search query did not return any results.

Picture of Vick
Name: Vick <contact>
Classes: 1 package by
Country: Canada Canada
Age: 43
All time rank: 29313 in Canada Canada
Week rank: 4277 Down88 in Canada Canada Down

Recommendations

Find a record into table
I need search any item into table

Keywords search on multiple table fields of a MySQL database
Search two fields of MySQL database for multiple keywords

Details

1-Edit the config file 2-Include the recherche.class.inc file in the appropriate file 3-Instanciate the class and call the _show() function with the appropriate parameters exactly where you want it ***Note that all parameters are required and specially the primary key of the table**** it goes like this: <? $r= new RECHERCHE(); $r->_show('search_file', 'searched_table', $arr=array("*Primary_key*", "field1", "field2", ...), 'url_for_selected_item', 'order','700px'); ?> the -searche_file is the file within the class is called -searched_table is ... i don't remember... -$arr is the array containig the searched fields, primary key is required -url_for_selected_item is the file that will be called in the href of the results(that's why the pk) -order is the "order by field" like "field1 DESC" -and finally the width of the display table

  Files folder image Files  
File Role Description
Accessible without login Plain text file config.inc Conf. Configuration
Accessible without login Plain text file demo.php Example The demo file
Accessible without login Plain text file demodisplay.php Example disp.
Accessible without login Plain text file js.script.inc Data js
Accessible without login Plain text file readme.txt Doc. readme
Plain text file recherche.class.inc Class class

 Version Control Unique User Downloads Download Rankings  
 0%
Total:8,726
This week:0
All time:186
This week:555Down
User Ratings User Comments (3)
 All time
Utility:86%StarStarStarStarStar
Consistency:85%StarStarStarStarStar
Documentation:73%StarStarStarStar
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:67%StarStarStarStar
Rank:463
 
quick and nice
7 years ago (muabshir)
80%StarStarStarStarStar
a good class
13 years ago (alex nuncio)
77%StarStarStarStar
Thank for this very usefull class.
14 years ago (ladder)
77%StarStarStarStar