PHP Search DB Table
Oliver Kennedy <[email protected]>
| Newsgroups | gmane.comp.php.windows,gmane.comp.php.database |
|---|---|
| Message-ID | <[email protected]> |
Hello Everyone
Apologies if I have not done this in the correct way, this is the first time I have turned to your for help so I am unaware if I have to submit this according to a certain protocol, if that is the case then please let me know and I will go through the proper channels. My problem is this.
I have a very simple database consisting of 1 table, I want users here to be able to use a search function to query the database in order to return the information on a client by a specific ID number if it is in the database. My search form is this
<body>
<div id="container" >
<form action='datasearch.php' method='POST'>
<div id ="options">
<p><label>Search by Client ID<br /><input type="text" name="searchx" /></label></p>
<p><input type="submit" value="Search" /></p>
</div>
</div>
</form>
</body>
</html>
and my process form is this
<?php
$term = $_REQUEST['searchx'];
mysql_connect("localhost", "root", "*********") or die (mysql_error());
mysql_select_db("moneyl") or die(mysql_error());
$result = mysql_query("SELECT * FROM clients WHERE clientid = '$term'")
or die(mysql_error());
echo"<table border='1'>";
echo "<tr><th>Client ID</th> <th>Feeearner</th> <th>First Name</th>
<th>Middle Name</th>
<th>Last Name</th>
<th>House/Flat Number</th>
<th>Address</th>
<th>Postcode</th>
<th>Gender</th>
<th>Date of Birth</th>
<th>Landline</th>";
while($row = mysql_fetch_array( $result ))
{
echo "<tr><td>";
echo$row['clientid'];
echo"</td><td>";
echo$row['feeearner'];
echo"</td><td>";
echo$row['firstname'];
echo"</td><td>";
echo$row['middlename'];
echo"</td><td>";
echo$row['lastname'];
echo"</td><td>";
echo$row['hfnumber'];
echo"</td><td>";
echo$row['address'];
echo"</td><td>";
echo$row['postcode'];
echo"</td><td>";
echo$row['gender'];
echo"</td><td>";
echo$row['dob'];
echo"</td><td>";
echo$row['landline'];
echo"</td></tr>";
}
echo"</table>";
?>
I know the form is connecting an retrieving okay because if I change the WHERE client id = '' to a specific number of a client ID in the database then it comes back with that information, so essentially it is not pulling through the numbers entered into the search box the value for which I have used REQUEST for and specified it with the value $term.
I am a beginner at this and am trying to do something to impress the powers-that-be at work, this is now the last stumbling block. Any help would be appreciated.
Regards
Oliver