 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<? ////////////////////////////////////////////////////////////////////////////// // Make sure the file is not already included ////////////////////////////////////////////////////////////////////////////// if (!isset( $_SEARCHENG_INC_ )) { $_SEARCHENG_INC_=1; ////////////////////////////////////////////////////////////////////////////// require("QueryGenerator.class.inc"); /************************************************************************** **** Class SearchEngine v.1.1 *************************************************************************** **** Purpose: To generate query strings for database searchs and return resulting data. Usage: query1 = new Query("AND", array("rabbit", "horse", "cow")); query2 = new Query("OR", array("dogs", "cats", "kangaroos")); query3 = new Query("NOT", array("sheep")); search = new SearchEngine(dblinkid, array(query1, query2, query3)); ids = search->DataMine("animal_table", "mamals_field", "ID_field"); echo "found ".count(ids)." matches"; echo "got ID ids[0]<br>"; echo "got ID ids[1]<br>"; *************************************************************************** **/ class SearchEngine extends QueryGenerator { var $m_dblinkid; var $m_lastcount; //PUBLIC: // dblinkid : link to database (make sure database selected before!) // querys : array of Query objects // wordmatch: only match whole words function SearchEngine($dblinkid, $Querys, $fullwords=false, $casematch=false) { // chain constructor $this->QueryGenerator($Querys, $fullwords, $casematch); $this->m_dblinkid = $dblinkid; $this->m_lastcount= 0; } // table : the table which you are going to search in // searchfields : the fields to search in separated by commas eg."field1,field2" // resultfields : the fields to be retrivied upon successful matches separated by commas. function DataMine($table, $searchfields, $resultfields) { $query_string = $this->GetQueryString($table, $searchfields, $resultfields); return ($this->m_error ? 0 : $this->FetchData($query_string)); } // table : the table which you are going to search in // searchfields : the fields to search in separated by commas eg."field1,field2" // RETURN : returns the total number of matches found by search function ResultCount($table, $searchfields) { if ($this->m_error) return 0; $query_string = $this->GetCountQueryString($table, $searchfields); $res = mysql_query($query_string, $this->m_dblinkid); $res = mysql_fetch_row($res); $this->m_lastcount = $res[0]; return $res[0]; } // same as above can be used for speed increase function LastResultCount() { return $this->m_lastcount; } //PRIVATE: // query_string : SQL Query string to be exec // RETURN: rows of data from query // (maybe should be a user defined function !) function FetchData($query_string) { $rows = array(); $this->m_resultid = mysql_query( $query_string, $this->m_dblinkid); while($data = mysql_fetch_array($this->m_resultid)) $rows[] = $data; return $rows; } }; ////////////////////////////////////////////////////////////////////////////// } // end if !included ////////////////////////////////////////////////////////////////////////////// ?> | |||||
| Related Code Examples | |||||
