$page_title = "Search DT-Photo.com";
$meta_keywords = "searches, find, seek, what, when, who, where, why, how, look, about";
$meta_description = "Search dt-photo.com - David Thomas Photography";
include("../functions.php"); top(); title("Search dt-photo.com");
$i = "1";
$correct = "1";
if (empty($keyword)) { $keyword=$QUERY_STRING; }
if (empty($keyword)) { $correct = "0"; $error .= "
Keyword"; }
if ($correct == "0") { ?>
Loading
bottom();
exit;
}
$keyword = strtolower(trim($keyword));
mysql_connect ('localhost', 'dt-photo', 'yx4eca');
mysql_select_db('david');
$keyword = str_replace(".jpg","",str_replace(".php","",str_replace("_"," ",$keyword)));
$sqltext = "select * from help where content like '%$keyword%'";// order by num DESC
$query = mysql_query($sqltext);
$my_count = mysql_num_rows($query);
$user_ip = $REMOTE_ADDR." @ ".@gethostbyaddr($REMOTE_ADDR);
$search_page = $HTTP_REFERER;
if (empty($search_page)) { $search_page = $PHP_SELF; }
mysql_query("insert into search (keyword,user_ip,search_page,results) values ('$keyword','$user_ip','$search_page','$my_count')");
?>
DT-Photo.com Search Results:
Your search for " echo strtoupper($keyword) ?>" resulted in echo $my_count ?> if ($my_count == '1' ) { echo "match."; } else { echo "matches."; } ?>
|
$per_page = 10;
if (!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
$query = mysql_query($sqltext);
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$num_rows = mysql_num_rows($query);
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}
$sqltext = $sqltext . " LIMIT $page_start, $per_page";
$query = mysql_query($sqltext);
@mysql_close();
$c = ($per_page * $page)-5 + 1;
//echo "sql text: $sqltext
";
while ($row = mysql_fetch_row($query)) {
$num = $row[0];
$page_title = $row[1];
$page_url = $row[2];
$content = $row[3];
$start_pos = strpos(strtolower($content),$keyword);
if ($start_pos >= 20) { $start_pos = $start_pos-20; }
$content = substr($content,$start_pos,100);
$content = str_replace($keyword,"$keyword",$content);
?>
unset($start_pos);
unset($content);
$c++; } ?>
if ($my_count == "") { ?>
Sorry, " echo ucfirst($keyword) ?>" - did not match any documents in this database.
- Make sure all words are spelled correctly.
- Try using fewer words.
- Try using more general keywords.
- Try different keywords.
}
if ($num_pages >= "2") {
$PHP_SELF = "search.php";
if ($prev_page) {
echo "[ previous | ";
}
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo "$i | ";
} else {
if (!$prev_page) { echo " [ $i | "; }
else if ($page == $num_pages) { echo " $i ]"; }
else { echo " $i | "; }
}
}
if ($page != $num_pages) {
echo "next ] ";
}
}
?>
bottom(); ?>