.
--------------------------------------------------------
Product Name QueryCatcher
Product URL http://www.jasonclark.info/files.php
Product Description A PHP/MySQL search term recorder module - collect queries logged into system, presents terms as browseable links
Latest Version 1.0
Release Date 2008/06/16
Author's Name Jason Clark
Author's Email jaclark@montana.edu
Author's URL http://jasonclark.info
License GNU's Public License (GPL)
--------------------------------------------------------
The code from this application is also available in the Code4Lib Journal (http://journal.code4lib.org).
The article that explains the "QueryCatcher" application is titled: "Making Patron Data Work Harder: User Search Terms as Access Points?"
It can be retrieved at http://journal.code4lib.org/articles/78.
*/
//purpose: This code searches a database for the user specified search terms and logs the search terms to a database table. Then the results are displayed in groups of 15 to the user.
//note: you will need to create your own database, user login, and password to have data to query - see the querycatcher.sql file in package for an example
//pass db name, login data and connection directions
mysql_pconnect("YOUR-DB-HOST","YOUR-DB-USER","YOUR-DB-PASSWORD") or die ("Error: Unable to connect to the database.");
mysql_select_db("YOUR-DB-NAME");
?>
"SearchCloud" View: QueryCatcher
View searches as a list | Return to Search Form
query_id;
$search = rtrim(stripslashes($row->query_data));
$searchCount = $row->query_count;
$searchWeight = $searchCount;
if ($searchWeight > 9) { $searchWeight = '9'; }
if($search != "") {
echo ''.$search.''."\n";
}
}
?>