search function help

gumszy · October 20, 2011

I would just like someone to explain to me how I will go about changing this code so that when I click on the search button it goes to a new page where the products will be displayed in a table I made a new topic yesterday but I don't think people understood it, any help on how I can do this would be very much appreciated.

<?php

/*****************************

* Simple SQL Search Tutorial by Frost

* of Slunked.com

******************************/

$dbHost = 'localhost'; // localhost will be used in most cases

// set these to your mysql database username and password.

$dbUser = 'searchuser';

$dbPass = 'searchpass';

$dbDatabase = 'searchdb'; // the database you put the table into.

$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

// Set up our error check and result check array

$error = array();

$results = array();

// First check if a form was submitted.

// Since this is a search we will use $_GET

if (isset($_GET['search'])) {

$searchTerms = trim($_GET['search']);

$searchTerms = strip_tags($searchTerms); // remove any html/javascript.

if (strlen($searchTerms) < 3) {

$error[] = "Search terms must be longer than 3 characters.";

}else {

$searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.

}

// If there are no errors, lets get the search going.

if (count($error) < 1) {

$searchSQL = "SELECT sid, sbody, stitle, sdescription FROM simple_search WHERE ";

// grab the search types.

$types = array();

$types[] = isset($_GET['body'])?"`sbody` LIKE '%{$searchTermDB}%'":'';

$types[] = isset($_GET['title'])?"`stitle` LIKE '%{$searchTermDB}%'":'';

$types[] = isset($_GET['desc'])?"`sdescription` LIKE '%{$searchTermDB}%'":'';

$types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)

if (count($types) < 1)

$types[] = "`sbody` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked

$andOr = isset($_GET['matchall'])?'AND':'OR';

$searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `stitle`"; // order by title.

$searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");

if (mysql_num_rows($searchResult) < 1) {

$error[] = "The search term provided {$searchTerms} yielded no results.";

}else {

$results = array(); // the result array

$i = 1;

while ($row = mysql_fetch_assoc($searchResult)) {

$results[] = "{$i}: {$row['stitle']}<br />{$row['sdescription']}<br />{$row['sbody']}<br /><br />";

$i++;

}

function removeEmpty($var) {

return (!empty($var));

}

?>

<html>

<title>My Simple Search Form</title>

#error {

color: red;

}

</style>

<body>

<?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>

<form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">

Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />

Search In:<br />

Body: <input type="checkbox" name="body" value="on" <?php echo isset($_GET['body'])?"checked":''; ?> /> |

Title: <input type="checkbox" name="title" value="on" <?php echo isset($_GET['title'])?"checked":''; ?> /> |

Description: <input type="checkbox" name="desc" value="on" <?php echo isset($_GET['desc'])?"checked":''; ?> /><br />

Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />

</form>

<?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>

</body>

</html>

Sign In

search function help

Recommended Posts

gumszy

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information