PHP Classes

Basic MySQL Search Engine Class: Search for text in a MySQL database table

Recommend this page to a friend!
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 67%Total: 10,114 All time: 130 This week: 488Down
Version License Categories
searchengine 1.0.0BSD LicenseDatabases, Searching
Description 

Author

This class can be used to search for data in MySQL database table text fields.

It executes one or more SQL SELECT queries to search for given keywords in different text fields of the same MySQL database table.

The class returns an array with the values of primary keys of the table records returned by the queries. Duplicate record entries are eliminated.

Picture of padik
Name: padik <contact>
Classes: 1 package by
Country: Philippines Philippines
Age: 41
All time rank: 2406 in Philippines Philippines
Week rank: 214 Up2 in Philippines Philippines Up

Details

This is a basic MySQL search engine class you can use immediately to your site. All you have to do is fill up basic database configurations. Steps: 1. Specify your host, username, password in array form 2. Specify the tablename you want to use 3. Specify primary key field of the table 4. Specify the fieldnames of the table you want to look up Example: /* <?php require_once 'class.search.php'; $config = array('localhost','root','','database'); // basic db configurations $table = 'bizmain'; // tablename you want to search $key = 'biz_id'; // primary key field of the table $fields = array('biz_name','biz_address','biz_cat'); // fieldnames of the table // you want to look up for keyword occurence $keyword = $_POST['keyword']; $found = new search_engine($config); $found->set_table($table); $found->set_primarykey($key); $found->set_keyword($keyword); $found->set_fields($fields); $result = $found->set_result(); print_r($result); ?> */

Screenshots (1)  
  • output.jpg
  Files folder image Files (6)  
File Role Description
Plain text file class.search.php Class Search Engine Class
Plain text file form.php Aux. Form File
Plain text file process.php Example Process File
Plain text file README.txt Doc. README
Plain text file sql.txt Data MySQL table

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:10,114
This week:0
All time:130
This week:488Down
User Ratings User Comments (3)
 All time
Utility:87%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:70%StarStarStarStar
Examples:79%StarStarStarStar
Tests:-
Videos:-
Overall:67%StarStarStarStar
Rank:448
 
very simple with awesome documentation
10 years ago (farrukh amin)
77%StarStarStarStar
very good script.
14 years ago (pk1774)
77%StarStarStarStar
Excellent
15 years ago (kishore kumar)
80%StarStarStarStarStar