joshgarrod Posted June 26, 2007 Share Posted June 26, 2007 Hi guys, Thanks to TreeNode i now have my search script working great, however it returns the results really boringly. Can anyone post me and edit of the script here jazzed up a bit, would be great. Thanks, much appreciated. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search for spares</title> <style type="text/css"> <!-- .style1 {font-family: Arial, Helvetica, sans-serif} --> </style> </head> <body> <h2 class="style1">Search</h2> <form action="<?=$PHP_SELF?>" method="post" name="search" class="style1"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="ID">Stock ID</option> <Option VALUE="StockNumber">Stock number</option> <Option VALUE="StockDescription">Stock description</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <p class="style1"> <? //This is only displayed if they have submitted the form if ($searching =="yes") { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == "") { echo "<p>You forgot to enter a search term"; exit; } // Otherwise we connect to our Database mysql_connect("localhost", "sto21", "ixhp388") or die(mysql_error()); mysql_select_db("sto21") or die(mysql_error()); // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); //Now we search for our search term, in the field the user specified $find_array = explode(" ", $find); $find_sql = ""; // init foreach ($find_array as $temp) $find_sql .= "LIKE '%$temp%' OR "; $find_sql = substr($find_sql, 0, -3); // throw away last OR statement $data = mysql_query("SELECT * FROM stock WHERE upper($field) $find_sql"); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['ID']; echo " "; echo "<br>"; echo $result['StockNumber']; echo "<br>"; echo $result['StockDescription']; echo "<br>"; echo $result['ItemPrice']; echo "<br>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?> </p> </body> </html> Josh Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/ Share on other sites More sharing options...
Dragen Posted June 26, 2007 Share Posted June 26, 2007 hehe.. jazzed up a bit?? what do you mean?! seriously, look at the code, find the part that outputs the information and edit it. I presume you know html, which is all that's really needed to change how it's displayed. No-one will help you just 'jazz it up', especially without any other information as to what you want. Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/#findComment-283064 Share on other sites More sharing options...
joshgarrod Posted June 26, 2007 Author Share Posted June 26, 2007 ok, its just i wanted to know what sort of options i have, i am not too hot with html Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/#findComment-283069 Share on other sites More sharing options...
Dragen Posted June 26, 2007 Share Posted June 26, 2007 if you look at this bit: //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['ID']; echo " "; echo "<br>"; echo $result['StockNumber']; echo "<br>"; echo $result['StockDescription']; echo "<br>"; echo $result['ItemPrice']; echo "<br>"; } that determines how the results are displayed. At the moment they're seperated by a new line: <br /> Just muck about with it. You can do anything you like html wise with php. Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/#findComment-283073 Share on other sites More sharing options...
joshgarrod Posted June 26, 2007 Author Share Posted June 26, 2007 so i replace echo "<br>"; with some html? Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/#findComment-283075 Share on other sites More sharing options...
Dragen Posted June 26, 2007 Share Posted June 26, 2007 yes Link to comment https://forums.phpfreaks.com/topic/57266-solved-displaying-things-nicely/#findComment-283088 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.