[SOLVED] Displaying search results on a different page

This is a discussion on "[SOLVED] Displaying search results on a different page" within the PHP Forum section. This forum, and the thread "[SOLVED] Displaying search results on a different page are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > PHP Forum
Reload this Page [SOLVED] Displaying search results on a different page

Notices
Please Register!
Webforumz.com is an education based community supporting web designers, developers and those who are new and learning. If you are a designer, developer, learning web design or are thinking about a career in web design then you have come to the right place. Register for free now to access more information and to participate in discussion and debate.




Reply
 
LinkBack Thread Tools
  #1  
Old Nov 17th, 2007, 18:43
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 29
Posts: 228
Thanks: 0
Thanked 0 Times in 0 Posts
[SOLVED] Displaying search results on a different page
Hellow i have a working search engine script and would like to no how i could get the search results to display on a sepearate page of my choice, also the search results that are returned are displayed using gloomy looking text that only a borg would enjoy

So my questions are:

1) Using the script below how would i get the search results to display on a different page?

2) How do i change the text that the resulst are displayed in?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Nov 17th, 2007, 18:45
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 29
Posts: 228
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Displaying search results on a different page
Soz forgt to post me code, thats what happens when your girl freind is nagging the backside of me

PHP: Select all

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>search</title>
</head>
<body>
<?php 
$link = mysql_connect("localhost","root","longstand1"); 
mysql_select_db("dbsignup", $link) or die("Unable to select database"); 
# 
$selectSql1 = "SELECT * FROM customer WHERE gender = '".mysql_real_escape_string($_POST['gender'])."' 
AND area = '".mysql_real_escape_string($_POST['area'])."'"; 
$result = mysql_query($selectSql1, $link) or die(mysql_error()); 
while($row = mysql_fetch_assoc($result)) { ?>
<?php 
echo '<pre>'; 
print_r($row); 
echo '</pre>'; 
} 
mysql_close($link); 
?> 
<form action="Search_engine.php" method="post">
  <table width="323" height="250" border="5" cellpadding="0" cellspacing="0">
    <tr>
      <td width="155"><div align="right">Gender:</div></td>
      <td width="154"><label>
        <select name="gender" id="gender">
        <option>Male</option>
        <option>Female</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Age:</div></td>
      <td><label>
        <select name="age" id="age">
         <option>18</option>
                              <option>19</option>
                              <option>20</option>
                              <option>21</option>
                              <option>22</option>
                              <option>23</option>
                              <option>24</option>
                              <option>25</option>
                              <option>26</option>
                              <option>27</option>
                              <option>28</option>
                              <option>29</option>
                              <option>30</option>
                              <option>31</option>
                              <option>32</option>
                              <option>33</option>
                              <option>34</option>
                              <option>35</option>
                              <option>36</option>
                              <option>37</option>
                              <option>38</option>
                              <option>39</option>
                              <option>40</option>
                              <option>41</option>
                              <option>42</option>
                              <option>43</option>
                              <option>44</option>
                              <option>45</option>
                              <option>46</option>
                              <option>47</option>
                              <option>48</option>
                              <option>49</option>
                              <option>50</option>
                              <option>51</option>
                              <option>52</option>
                              <option>53</option>
                              <option>54</option>
                              <option>55</option>
                              <option>56</option>
                              <option>57</option>
                              <option>58</option>
                              <option>59</option>
                              <option>60</option>
                              <option>61</option>
                              <option>62</option>
                              <option>63</option>
                              <option>64</option>
                              <option>65</option>
                              <option>66</option>
                              <option>67</option>
                              <option>68</option>
                              <option>69</option>
                              <option>70</option>
                              <option>71</option>
                              <option>72</option>
                              <option>73</option>
                              <option>74</option>
                              <option>75</option>
                              <option>76</option>
                              <option>77</option>
                              <option>78</option>
                              <option>79</option>
                              <option>80</option>
                              <option>81</option>
                              <option>82</option>
                              <option>83</option>
                              <option>84</option>
                              <option>85</option>
                              <option>86</option>
                              <option>87</option>
                              <option>88</option>
                              <option>89</option>
                              <option>90</option>
                              <option>91</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Height</div></td>
      <td><label>
        <select name="height_one" id="height_one">
        <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
        </select>
      To
      <select name="height_two" id="height_two">
      <option>1</option>
                              <option>2</option>
                              <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
                              <option>9</option>
                              <option>10</option>
                              <option>11</option>
      </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Hair Colour:</div></td>
      <td><label>
        <select name="hair_colour" id="hair_colour">
        <option>Black</option>
                              <option>Brown</option>
                              <option>Blonde</option>
                              <option>Red</option>
                              <option>Auburn</option>
                              <option>Other</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Area:</div></td>
      <td><label>
        <select name="area" id="area">
        <option>England-Bath Avon</option>
                          <option>England-Bedforshire</option>
                          <option>England-Berkshire</option>
                          <option>England-Brighton</option>
                          <option>England-Bristol</option>
                          <option>England-Buckinghamshire</option>
                          <option>England-Cambridgeshire</option>
                          <option>England-Channel Isles</option>
                          <option>England-Cheshire</option>
                          <option>England-Cornwall</option>
                          <option>England-County Durham</option>
                          <option>England-Cumbria</option>
                          <option>England-Derbyshire</option>
                          <option>England-Devon</option>
                          <option>England-Dorset</option>
                          <option>England-Essex</option>
                          <option>England-Gloucestershire</option>
                          <option>England-Hampshire</option>
                          <option>England-Herefordshire</option>
                          <option>England-Huntingdonshire</option>
                          <option>England-Isle Of White</option>
                          <option>England-Isle Of Sily</option>
                          <option>England-Kent</option>
                          <option>England-Lancashire</option>
                          <option>England-Leicestershire</option>
                          <option>England-Lincolnshire</option>
                          <option>England-London</option>
                          <option>England-Manchester</option>
                          <option>England-Merseyside</option>
                          <option>England-Middlesex</option>
                          <option>England-Norfolk</option>
                          <option>England-Northamptonshire</option>
                          <option>England-Northumberland</option>
                          <option>England-Nottinghamshire</option>
                          <option>England-Oxfordshire</option>
                          <option>England-Rutland</option>
                          <option>England-Shropshire</option>
                          <option>England-Somerset</option>
                          <option>England-Staffordshire</option>
                          <option>England-Suffolk</option>
                          <option>England-Surrey</option>
                          <option>England-Sussex</option>
                          <option>England-Tyne &amp; Wear</option>
                          <option>England-Warwickshire</option>
                          <option>England-West midlands</option>
                          <option>England-Westmorland</option>
                          <option>England-Wiltshire</option>
                          <option>England-Worcestershire</option>
                          <option>England-Yorkshire</option>
                          <option>Isle Of Man</option>
                          <option>N Ireland-Artrim</option>
                          <option>N Ireland-Amagh</option>
                          <option>N Ireland-Bellfast</option>
                          <option>N Ireland-Down</option>
                          <option>N-Ireland-Femanagh</option>
                          <option>N-Ireland-Londondery</option>
                          <option>N-Ireland-Tyrone</option>
                          <option>Scotland-Aberdeenshire</option>
                          <option>Scotland-Angus</option>
                          <option>Scotland-Argylshire</option>
                          <option>Scotland-Ayrshire</option>
                          <option>Scotland-Banffshire</option>
                          <option>Scotland-Berwicshire</option>
                          <option>Scotland-Buteshire</option>
                          <option>Scotland-Caithness</option>
                          <option>Scotland-Clackmannanshire</option>
                          <option>Scotland-Dumfriesshire</option>
                          <option>Scotland-Dundee city</option>
                          <option>Scotland-Edinburgh</option>
                          <option>Scotland-Falkirk</option>
                          <option>Scotland-Fife</option>
                          <option>Scotland-Highland</option>
                          <option>Scotland-Inverness-shire</option>
                          <option>Scotland-Isle of Islay</option>
                          <option>Scotland-Isle of Lewis</option>
                          <option>Scotland-Isle of Skye</option>
                          <option>Scotland-Kincarineshire</option>
                          <option>Scotland-Kinross-shire</option>
                          <option>Scotland-Kirkcudbrightshire</option>
                          <option>Scotland-Lanarkshire</option>
                          <option>Scotland-Midlothian</option>
                          <option>Scotland-Morayshire</option>
                          <option>Scotland-Naimshire</option>
                          <option>Scotland-Orkney</option>
                          <option>Scotland-Peeblesshire</option>
                          <option>Scotland-Perthshire</option>
                          <option>Scotland-Renfrewshire</option>
                          <option>Scotland-Ross-shire</option>
                          <option>Scotland-Roxburghshire</option>
                          <option>Scotland-Selkirkshire</option>
                          <option>Scotland-Shetland</option>
                          <option>Scotland-Sterlingshire</option>
                          <option>Scotland-Sutherland</option>
                          <option>Scotland-West Lothiann</option>
                          <option>Scotland-Western Isles</option>
                          <option>Scotland-Wigtownshire</option>
                          <option>Wales-Anglesey</option>
                          <option>Wales-Brecknockshire</option>
                          <option>Wales-Caemarfonshire</option>
                          <option>Wales-Cardiff</option>
                          <option>Wales-Cardiganshire</option>
                          <option>Wales-Carmarthenshire</option>
                          <option>Wales-Ceredigion</option>
                          <option>Wales-Denbighshire</option>
                          <option>Wales-Flintshire</option>
                          <option>Wales-Glamorgan</option>
                          <option>Wales-Gwynedd</option>
                          <option>Wales-Merioneth</option>
                          <option>Wales-Monmouthshire</option>
                          <option>Wales-Montgomeryshire</option>
                          <option>Wales-Newport</option>
                          <option>Wales-Pembrokeshire</option>
                          <option>Wales-Radnorshire</option>
                          <option>Wales-Swansea</option>
                          
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Work Interested:</div></td>
      <td><label>
        <select name="desired_work" id="desired_work">
        <option>Look-A-Likes</option>
                              <option>Models &amp; Glamour</option>
                              <option>Actors &amp; TV Extras</option>
                              <option>Singers &amp; Vocalists</option>
                              <option>Theatre &amp; Musicals</option>
                              <option>Producers&amp;Aegents</option>
        </select>
      </label></td>
    </tr>
  </table> 
<input type="submit" />
</form>
</body>
</html>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Nov 17th, 2007, 22:52
Highly Reputable Member
Join Date: Sep 2007
Age: 15
Posts: 717
Blog Entries: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Displaying search results on a different page
Just put the search form on another page. Like this:
HTML: Select all
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>search</title>
</head>

<body>
<form action="Search_engine.php" method="post">
  <table width="323" height="250" border="5" cellpadding="0" cellspacing="0">
    <tr>
      <td width="155"><div align="right">Gender:</div></td>
      <td width="154"><label>
        <select name="gender" id="gender">
        <option>Male</option>
        <option>Female</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Age:</div></td>
      <td><label>
        <select name="age" id="age">
         <option>18</option>
                              <option>19</option>
                              <option>20</option>
                              <option>21</option>
                              <option>22</option>
                              <option>23</option>
                              <option>24</option>
                              <option>25</option>
                              <option>26</option>
                              <option>27</option>
                              <option>28</option>
                              <option>29</option>
                              <option>30</option>
                              <option>31</option>
                              <option>32</option>
                              <option>33</option>
                              <option>34</option>
                              <option>35</option>
                              <option>36</option>
                              <option>37</option>
                              <option>38</option>
                              <option>39</option>
                              <option>40</option>
                              <option>41</option>
                              <option>42</option>
                              <option>43</option>
                              <option>44</option>
                              <option>45</option>
                              <option>46</option>
                              <option>47</option>
                              <option>48</option>
                              <option>49</option>
                              <option>50</option>
                              <option>51</option>
                              <option>52</option>
                              <option>53</option>
                              <option>54</option>
                              <option>55</option>
                              <option>56</option>
                              <option>57</option>
                              <option>58</option>
                              <option>59</option>
                              <option>60</option>
                              <option>61</option>
                              <option>62</option>
                              <option>63</option>
                              <option>64</option>
                              <option>65</option>
                              <option>66</option>
                              <option>67</option>
                              <option>68</option>
                              <option>69</option>
                              <option>70</option>
                              <option>71</option>
                              <option>72</option>
                              <option>73</option>
                              <option>74</option>
                              <option>75</option>
                              <option>76</option>
                              <option>77</option>
                              <option>78</option>
                              <option>79</option>
                              <option>80</option>
                              <option>81</option>
                              <option>82</option>
                              <option>83</option>
                              <option>84</option>
                              <option>85</option>
                              <option>86</option>
                              <option>87</option>
                              <option>88</option>
                              <option>89</option>
                              <option>90</option>
                              <option>91</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Height</div></td>
      <td><label>
        <select name="height_one" id="height_one">
        <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
        </select>
      To
      <select name="height_two" id="height_two">
      <option>1</option>
                              <option>2</option>
                              <option>3</option>
                              <option>4</option>
                              <option>5</option>
                              <option>6</option>
                              <option>7</option>
                              <option>8</option>
                              <option>9</option>
                              <option>10</option>
                              <option>11</option>
      </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Hair Colour:</div></td>
      <td><label>
        <select name="hair_colour" id="hair_colour">
        <option>Black</option>
                              <option>Brown</option>
                              <option>Blonde</option>
                              <option>Red</option>
                              <option>Auburn</option>
                              <option>Other</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Area:</div></td>
      <td><label>
        <select name="area" id="area">
        <option>England-Bath Avon</option>
                          <option>England-Bedforshire</option>
                          <option>England-Berkshire</option>
                          <option>England-Brighton</option>
                          <option>England-Bristol</option>
                          <option>England-Buckinghamshire</option>
                          <option>England-Cambridgeshire</option>
                          <option>England-Channel Isles</option>
                          <option>England-Cheshire</option>
                          <option>England-Cornwall</option>
                          <option>England-County Durham</option>
                          <option>England-Cumbria</option>
                          <option>England-Derbyshire</option>
                          <option>England-Devon</option>
                          <option>England-Dorset</option>
                          <option>England-Essex</option>
                          <option>England-Gloucestershire</option>
                          <option>England-Hampshire</option>
                          <option>England-Herefordshire</option>
                          <option>England-Huntingdonshire</option>
                          <option>England-Isle Of White</option>
                          <option>England-Isle Of Sily</option>
                          <option>England-Kent</option>
                          <option>England-Lancashire</option>
                          <option>England-Leicestershire</option>
                          <option>England-Lincolnshire</option>
                          <option>England-London</option>
                          <option>England-Manchester</option>
                          <option>England-Merseyside</option>
                          <option>England-Middlesex</option>
                          <option>England-Norfolk</option>
                          <option>England-Northamptonshire</option>
                          <option>England-Northumberland</option>
                          <option>England-Nottinghamshire</option>
                          <option>England-Oxfordshire</option>
                          <option>England-Rutland</option>
                          <option>England-Shropshire</option>
                          <option>England-Somerset</option>
                          <option>England-Staffordshire</option>
                          <option>England-Suffolk</option>
                          <option>England-Surrey</option>
                          <option>England-Sussex</option>
                          <option>England-Tyne &amp; Wear</option>
                          <option>England-Warwickshire</option>
                          <option>England-West midlands</option>
                          <option>England-Westmorland</option>
                          <option>England-Wiltshire</option>
                          <option>England-Worcestershire</option>
                          <option>England-Yorkshire</option>
                          <option>Isle Of Man</option>
                          <option>N Ireland-Artrim</option>
                          <option>N Ireland-Amagh</option>
                          <option>N Ireland-Bellfast</option>
                          <option>N Ireland-Down</option>
                          <option>N-Ireland-Femanagh</option>
                          <option>N-Ireland-Londondery</option>
                          <option>N-Ireland-Tyrone</option>
                          <option>Scotland-Aberdeenshire</option>
                          <option>Scotland-Angus</option>
                          <option>Scotland-Argylshire</option>
                          <option>Scotland-Ayrshire</option>
                          <option>Scotland-Banffshire</option>
                          <option>Scotland-Berwicshire</option>
                          <option>Scotland-Buteshire</option>
                          <option>Scotland-Caithness</option>
                          <option>Scotland-Clackmannanshire</option>
                          <option>Scotland-Dumfriesshire</option>
                          <option>Scotland-Dundee city</option>
                          <option>Scotland-Edinburgh</option>
                          <option>Scotland-Falkirk</option>
                          <option>Scotland-Fife</option>
                          <option>Scotland-Highland</option>
                          <option>Scotland-Inverness-shire</option>
                          <option>Scotland-Isle of Islay</option>
                          <option>Scotland-Isle of Lewis</option>
                          <option>Scotland-Isle of Skye</option>
                          <option>Scotland-Kincarineshire</option>
                          <option>Scotland-Kinross-shire</option>
                          <option>Scotland-Kirkcudbrightshire</option>
                          <option>Scotland-Lanarkshire</option>
                          <option>Scotland-Midlothian</option>
                          <option>Scotland-Morayshire</option>
                          <option>Scotland-Naimshire</option>
                          <option>Scotland-Orkney</option>
                          <option>Scotland-Peeblesshire</option>
                          <option>Scotland-Perthshire</option>
                          <option>Scotland-Renfrewshire</option>
                          <option>Scotland-Ross-shire</option>
                          <option>Scotland-Roxburghshire</option>
                          <option>Scotland-Selkirkshire</option>
                          <option>Scotland-Shetland</option>
                          <option>Scotland-Sterlingshire</option>
                          <option>Scotland-Sutherland</option>
                          <option>Scotland-West Lothiann</option>
                          <option>Scotland-Western Isles</option>
                          <option>Scotland-Wigtownshire</option>
                          <option>Wales-Anglesey</option>
                          <option>Wales-Brecknockshire</option>
                          <option>Wales-Caemarfonshire</option>
                          <option>Wales-Cardiff</option>
                          <option>Wales-Cardiganshire</option>
                          <option>Wales-Carmarthenshire</option>
                          <option>Wales-Ceredigion</option>
                          <option>Wales-Denbighshire</option>
                          <option>Wales-Flintshire</option>
                          <option>Wales-Glamorgan</option>
                          <option>Wales-Gwynedd</option>
                          <option>Wales-Merioneth</option>
                          <option>Wales-Monmouthshire</option>
                          <option>Wales-Montgomeryshire</option>
                          <option>Wales-Newport</option>
                          <option>Wales-Pembrokeshire</option>
                          <option>Wales-Radnorshire</option>
                          <option>Wales-Swansea</option>
                          
        </select>
      </label></td>
    </tr>
    <tr>
      <td><div align="right">Work Interested:</div></td>
      <td><label>
        <select name="desired_work" id="desired_work">
        <option>Look-A-Likes</option>
                              <option>Models &amp; Glamour</option>
                              <option>Actors &amp; TV Extras</option>
                              <option>Singers &amp; Vocalists</option>
                              <option>Theatre &amp; Musicals</option>
                              <option>Producers&amp;Aegents</option>
        </select>
      </label></td>
    </tr>
  </table> 
<input type="submit" />
</form>
</body>
</html>
And the new Search_engine.php would look like this:
PHP: Select all

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>search</title>
</head>

<body>
<?php 
$link = mysql_connect("localhost","root","longstand1"); 
mysql_select_db("dbsignup", $link) or die("Unable to select database"); 
# 
$selectSql1 = "SELECT * FROM customer WHERE gender = '".mysql_real_escape_string($_POST['gender'])."' 
AND area = '".mysql_real_escape_string($_POST['area'])."'"; 
$result = mysql_query($selectSql1, $link) or die(mysql_error()); 
while($row = mysql_fetch_assoc($result)) { ?>
<?php 
echo '<pre>'; 
print_r($row); 
echo '</pre>'; 
} 
mysql_close($link); 
?>
</body>
</html>
Hope that helps.

Cheers,
Stuart
Last Blog Entry: Windows Vista vs. Mac Leopard (Nov 4th, 2007)
Digg this Post!