jirble2
-
Posts
17 -
Joined
-
Last visited
jirble2's Achievements
Newbie (1/5)
0
Reputation
-
Ok, I'll look into that, but what about the problem of the blank and spacebar search. I also discovered that you can only search one word or else the search won't return any results. Any ideas?
-
Oh and I should mention, even though it is probably pretty obvious, that where it says "Your search returned ?? results", I want the "??" to display the number of results returned.
-
That was search.php and there's also search.html: <!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"> <link rel="stylesheet" type="text/css" href="index.css"/> <title>Search</title> </head> <body> <div id="banner"> <h1>Search</h1> </div> <div id="main"> <h3>Search</h3> <form action="search.php" method="post"> <input type="text" name="term" /><br /> <input type="submit" name="submit" value="Search" /> </form> </div> </body> </html>
-
<html> <head> <title>Search results - ANZAC War Trophies</title> <link rel="stylesheet" type="text/css" href="index.css"/> </head> <body> <div id="nav"> <ul> <li><a href="index.html">Home</a></li> <li><a href="search.html">Search again</a></li> <li><a href="forum.html">Forum</a></li> <li><a href="contact.html">Contact us</a></li> <li><a href="login.html">Member login</a></li> </ul> </div><div id="main"> <h3>Your search returned ?? results</h3> </div><div id="results"> <table> <tr> <td>ID</td><td>Serial No.</td><td>Model</td><td>Caliber</td><td>Manufacturer</td><td>Date of Manufacture</td><td>Captor</td><td>Date of Capture</td><td>Place of Capture</td><td>Original Allocation - Town</td><td>Original Allocation - State</td><td>Current Location - Town</td><td>Current Location - State</td><td>Extant</td><td>Condition</td><td>Captured</td><td>Images</td> </tr> <?php mysql_connect ("localhost", "root","") or die (mysql_error()); mysql_select_db ("ANZAC War Trophies"); $term = $_POST['term']; $sql = mysql_query("select * from war_trophies where id like '%$term%' or serial_no like '%$term%' or model like '%$term%' or caliber like '%$term%' or manufacturer like '%$term%' or date_man like '%$term%' or captor like '%$term%' or date_cap like '%$term%' or place_cap like '%$term%' or orig_alloc_place like '%$term%' or orig_alloc_state like '%$term%' or current_loc_place like '%$term%' or current_loc_state like '%$term%' or extant like '%$term%' or captured like '%$term%' or cond like '%$term%' "); while ($row = mysql_fetch_array($sql)){ echo '<tr><td>'.$row['id']; echo '</td><td>'.$row['serial_no']; echo '</td><td>'.$row['model']; echo '</td><td>'.$row['caliber']; echo '</td><td>'.$row['manufacturer']; echo '</td><td>'.$row['date_man']; echo '</td><td>'.$row['captor']; echo '</td><td>'.$row['date_cap']; echo '</td><td>'.$row['place_cap']; echo '</td><td>'.$row['orig_alloc_place']; echo '</td><td>'.$row['orig_alloc_state']; echo '</td><td>'.$row['current_loc_place']; echo '</td><td>'.$row['current_loc_state']; echo '</td><td>'.$row['extant']; echo '</td><td>'.$row['cond']; echo '</td><td>'.$row['captured']; echo '</td><td>'.$row['images']; echo '</td>'; } ?> </div> </body> </html>
-
Well never mind about the table, I worked out how to do that. But this now leaves me with 2 more things that I want to do to my table. 1: A count of results, where if there are no results a message saying something like "Please go back and try again" will display. And 2: At the moment, when I try to search by pressing spacebar or not entering anything, then I'm shown every single result there is. I want it so that when you enter spacebar or nothing at all nothing will happen and the page will stay at the search page. Anyone know how to do this?
-
Lol I only just discovered AFTER doing that last reply that there is a table tool on this forum.
-
Well what I really want to do is to have the search results in a table, where each column has a different part of each result like: |ID|Serial No.|Model|Condition| |---|------------|-------|------------| |4 |1234567 |M | Good | |---|------------|-------|------------| |7 |234568 |G | Bad | |---|------------|-------|------------| At the moment the results look like ID: 4 Serial No.: 1234567 Model: M Condition: Good ID: 7 Serial No.: 2345678 Model: G Condition: Bad Is this just a matter of using CSS or does it involve even more PHP coding to do?
-
Well in the end I found yet another tutorial, and for once, I managed to get it to work . My next step now is to format the appearance of the results. Is it possible to use CSS to format php coding? If so, how do you reference to individual areas within the php (ie. what's the php alternative of <div id="example>)?
-
tried that, but still gives the same error message
-
Sorry, but this is where my "very little knowledge" off php coding comes in. Could you tell me which part I should be looking at, and what I should change it to? I don't have a clue what you mean by "escaped", but I'll read up a bit more and try to learn.
-
Well you've definitely helped, because now the page looks like it should, instead of just displaying an error. However, when I try to search now, i get the error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\search.php on line 32. Line 32: while($row=mysql_fetch_array($result)){
-
Well, now when I try to load the page I get "Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in C:\xampp\htdocs\search.php on line 51" Line 51: echo "<li>" . "<a href=\"search.php?id=$id\>" .$serial_no . " " . $model . "</a></li>\n"; And if it helps, here is my entire code so far: <!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"> <link rel="stylesheet" type="text/css" href="search.css"/> <title>ANZAC war Trophies - Search</title> </head> <body> <div id="banner"> <h1>ANZAC war Trophies</h1> </div> <h3>Search Contacts Details</h3> <p>You may search either by first or last name</p> <form method="post" action="search.php?go" id="searchform"> <input type="text" name="name"> <input type="submit" name="submit" value="Search"> </form> <?php if(isset($_POST['submit'])){ if(isset($_GET['go'])){ if(preg_match("/^[ a-zA-Z]+/", $_POST['name'])){ $name=$_POST['anzac war trophys']; //connect to the database $db=mysql_connect ("localhost", "root", "") or die ('I cannot connect to the database because: ' . mysql_error()); //-select the database to use $mydb=mysql_select_db("war_trophies"); //-query the database table $sql="SELECT id, serial_no, model, calibre, manufacturer, date_manufacture, captor, date_capture, place_capture, orig_alloc_place, orig_alloc_state, current_loc_place, current_loc_state, extant, condition FROM war_trophies WHERE serial_no LIKE '%" . $name . "%' OR model LIKE '%" . $name ."%'"; //-run the query against the mysql query function $result=mysql_query($sql); //-create while loop and loop through result set while($row=mysql_fetch_array($result)){ $id = $row["id"]; $serial_no = $row["serial_no"]; $model = $row["model"]; $calibre = $row["calibre"]; $manufacturer = $row["manufacturer"]; $date_manufacture = $row["date_manufacture"]; $captor = $row["captor"]; $date_capture = $row["date_capture"]; $place_capture = $row["place_capture"]; $orig_alloc_place = $row["orig_alloc_place"]; $orig_alloc_state = $row["orig_alloc_state"]; $current_loc_place = $row["current_loc_place"]; $current_loc_state = $row["current_loc_state"]; $extant = $row["extant"]; $condition = $row["condition"]; //-display the result of the array echo "<ul>\n"; echo "<li>" . "<a href=\"search.php?id=$id\>" .$serial_no . " " . $model . "</a></li>\n"; echo "</ul>"; } } else{ echo "<p>Please enter a search query</p>"; } } } ?> </body> </html>
-
Oh and also, in the tutorial, the msql query code looked like this (before I edited it obviously) $query = "select * from the_table where 1st_field like \"%$trimmed%\" order by 1st_field";
-
$query = "select * from anzac where Serial No. like \"%$trimmed%\" order by Serial No.";
-
Well I tried using the one on designplace, but when I try to do a search I get the message "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\search.php on line 45". The coding on line 45 is $numrows=mysql_num_rows($numresults); . What am I doing wrong? My guess is that I've probably missed out on some little thing that I forgot to edit.