PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!

  Author Author  
Name: padik <contact>
Classes: 1 package by
Country: Philippines Philippines
Age: 34
All time rank: 2356 in Philippines Philippines
Week rank: 548 Down10 in Philippines Philippines Down


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

Details
{startverticalbanner}
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);

?>
*/

  Classes of padik  >  Basic MySQL Search Engine Class  >  Download Download .zip .tar.gz  >  Support forum Support forum (5)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Basic MySQL Search Engine Class
Base name: searchengine
Description: Search for text in a MySQL database table
Version: 1.0.0
PHP version: -
License: BSD License
All time users: 9957 users
All time rank: 130
Week users: 1 user
Week rank: 689 Down
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Searching Search engines, crawling and indexing View top rated classes

  Files folder image Screenshots  
output.jpg
File Role Description
Accessible without login Image file output.jpg Screen Output


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (95%) Good (95%) Sufficient (75%) Good (85%) - - Sufficient (73%) 199
Month: Not yet rated by the users

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.

  Files folder image Files  
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

Install with Composer Install with Composer - Download Download all files: searchengine.tar.gz searchengine.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.