Jump to content

jackb89

New Members
 View Profile  See their activity

  • Posts

    7

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by jackb89

  1. jackb89
    Sure. Here's the basic script I used. Works perfectly in Chrome, not sure about IE or FF though : <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Vehicle Search</title> </head> <body> <tr> <table width="800" cellpadding="10" cellspacing="0" border="0"> <table style="margin: auto;"> <tr align="center" valign="center"> <td align="center" colspan="1" rowspan="1" bgcolor="ffffff"> <table width="450px"> </tr> <form name="search" method="post" action=""> Search for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="option1">option1</option> //change the name of the option in the "" brackets and the >< markers <Option VALUE="option2">option2</option> <Option VALUE="option3">option3</option> <Option VALUE="option4">option4</option> <Option VALUE="option5">option5</option> <Option VALUE="option6">option6</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <p></p> <table width="500" cellpadding="10" cellspacing="0" border="2"> <tr align="center" valign="center"> <td align="center" colspan="1" rowspan="1" bgcolor="ffffff"> <?php $searching = $_POST['searching']; $find = $_POST['find']; $field = $_POST['field']; //This is only displayed if they have submitted the form if ($searching == "yes") { //If they did not enter a search term we give them an error if ($find == "") { echo "You forgot to enter a search term"; DIE; } //Otherwise we connect to our Database mysql_connect("host", "username", "password") or die(mysql_error()); mysql_select_db("databasename") or die(mysql_error()); //We perform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim($find); $find = mysql_real_escape_string($find); $field = mysql_real_escape_string($field); //Now we search for our search term, in the field the user specified $result = mysql_query("SELECT * FROM tablename WHERE upper($field) LIKE '%$find%'") or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "There are $num_rows records.<br><br>"; //And we display the results print "<table width=600 border=1>"; //Change the field names in table to reflect print "<tr><th>ID</th><th>Field 1</th><th>Field 2</th><th>Field 3</th><th>Field 4</th><th>Field 5</th><th>Field 6</th></tr>"; while ($get_info = mysql_fetch_row($result)){ print "<tr>"; foreach ($get_info as $field) print "<td>$field</td>"; print "</tr>"; } print "</table>"; //This counts the number or results and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($result); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query"; } //And we remind them what they searched for echo "Searched For: ".$find; } ?> </div> </div> </body> </html>
  2. jackb89
    Thanks a bunch. The code works perfectly. I had to change some of the sql query as it was throwing up mysql_fetch_array () errors but at least i'm getting records now. Cheers mate
  3. jackb89
    Ok. Thankyou both. I will give it another go... Just to clarify: 1. $find = mysql_real_escape_string($find); needs to go at the beginning of the php code in the process page? 2. $searching = $_POST['searching']; if ($searching =="yes") { can be used instead of the isset() function? and 3. $find = $_POST['find']; - Where does this need to be in the exec file?
  4. jackb89
    Thanks for the reply . So you are saying to use an isset() function instead of the $searching variable? All it is doing is stopping the whole script from running until a value is entered and submitted, right?
  5. jackb89
    I've had another look and separated the search form and php functions into two different files as i read the <?=$PHP_SELF?> can cause problems. It still runs fine but the search box comes back empty and the blank search error message isn't showing up either. Any ideas what I'm missing? Here's my code as it is now: 17193_.php 17194_.php
  6. jackb89
    Ahh that seems to have been it... Ok. Well the script runs without error but now isn't bringing up any records - when i search nothing happens? I'm sure the connections to the host and database are correct as they work fine on my other scripts. Do I need to put the array results in a table or should it do that automatically?? Do I need to have separate search boxes for each field or can I just use the one? Sorry, I'm still relatively new to php (if you can't tell already )
  7. jackb89
    Hi guys. Hope you can help me with this. I have a MySQL database running and am able to connect to it and add/remove files. However, I am trying to add a search function into my site and it keeps throwing up the following error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/a3796103/public_html/cars_search_form.php on line 44 Now I know this is usually to do with missing syntax but I can't for the life of me find where it is. Here is my full code: <html><head><title>Cars Search Form</title> <style type="text/css"> td {font-family: tahoma, arial, verdana; font-size: 10pt } </style> </head> <body> <table width="300" cellpadding="10" cellspacing="0" border="2"> <tr align="center" valign="top"> <td align="left" colspan="1" rowspan="1" bgcolor="64b1ff"> <h3>Car Search</h3> <table width="450px"> </tr> <form name="search" method="post" action="<?=$PHP_SELF?>"> Search for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="make">Make/model</option> <Option VALUE="colour">Colour</option> <Option VALUE="year">Year</option> <Option VALUE="fuel">Fuel type</option> <Option VALUE="transmission">Transmission</option> <Option VALUE="ctype">Car type</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <table width="300" cellpadding="10" cellspacing="0" border="2"> <tr align="center" valign="top"> <td align="left" colspan="1" rowspan="1" bgcolor="64b1ff"> <?php //This is only displayed if they have submitted the form if ($searching =="yes") { echo "Results”; } //If they did not enter a search term we give them an error if ($find == “”) { echo “You forgot to enter a search term”; } //Otherwise we connect to our Database mysql_connect("localhost", "user", "password") or die(mysql_error()); mysql_select_db("test_dbase") or die(mysql_error()); //We perform 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 $data = mysql_query(”SELECT * FROM users WHERE upper($field) LIKE’%$find%’”); //And we display the results while($result = mysql_fetch_array($data)) { echo $result['make']; echo ” “; echo $result['colour']; echo “”; echo $result['year']; echo “”; echo $result['fuel']; echo “”; echo $result['transmission']; echo “”; echo $result['ctype']; echo “”; echo “”; } //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”; } //And we remind them what they searched for echo “Searched For: ”.$find; } ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.