Water - Prices
= $min_length){ // if query length is more or equal minimum length then $query = htmlspecialchars($query); // changes characters used in html to their equivalents, for example: < to > $query = mysql_real_escape_string($query); // makes sure nobody uses SQL injection $raw_results = mysql_query("SELECT * FROM florinvtable WHERE (`Category` LIKE '%".$query."%') ORDER BY Category, Brand, Description, Price") or die(mysql_error()); // * means that it selects all fields, you can also write: `id`, `title`, `text` // articles is the name of our table // '%$query%' is what we're looking for, % means anything, for example if $query is Hello // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query' // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query' if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following while($results = mysql_fetch_array($raw_results)){ // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop echo "
".$results['Category']."
".$results['Brand']."
".$results['Description']."
".$results['Size']." $".$results['Price']."
#".$results['Barcode']."
"; // posts results gotten from database(title and text) you can also show id ($results['id']) } } else{ // if there is no matching rows do following echo "Sorry, no results. Try altering your search term."; } } else{ // if query length is less than minimum echo "Minimum number of characters to perform a search is ".$min_length; } ?>
display_cart();?>
You can adjust quantities at checkout.
Item Added