I have a php search script with a blank field (to type the name of the company) and a drop down menu (list of the US states)
When I perform a query all the records of the table is displayed, just as shown below.
fld_companyName fld_warnState fld_numEmployees
Dell NJ 10
Apple NY 20
HP CT 35
etc.
The ideal output would be fld_companyName, fld_warnState and fld_numEmployees of the company (typed in the blank field) and the state (selected from the drop down menu) specified in the search page.
How can I achieve this?
This is the search script:
<?php
error_reporting(E_ALL);
if (!isset($_POST['Submit'])) {
?>
<form action="results.php" method="post" action="<?=$PHP_SELF?>">
Search for the company: <input type="text" name="search">
<select name="fld_warnState" id="fld_warnState">
<option value="-1">-- Choose state --</option>
<option value="fld_warnState"></option>
<option value="AK">AK</option>
<option value="AL">AL</option>
<option value="AR">AR</option>
<option value="AZ">AZ</option>
<option value="CA">CA</option>
<option value="CO">CO</option>
<option value="CT">CT</option>
<option value="DE">DE</option>
<option value="FL">FL</option>
<option value="GA">GA</option>
<option value="HI">HI</option>
<option value="IA">IA</option>
<option value="ID">ID</option>
<option value="IL">IL</option>
<option value="IN">IN</option>
<option value="KS">KS</option>
<option value="KY">KY</option>
<option value="LA">LA</option>
<option value="MA">MA</option>
<option value="MD">MD</option>
<option value="ME">ME</option>
<option value="MI">MI</option>
<option value="MN">MN</option>
<option value="MO">MO</option>
<option value="MS">MS</option>
<option value="MT">MT</option>
<option value="NC">NC</option>
<option value="ND">ND</option>
<option value="NE">NE</option>
<option value="NH">NH</option>
<option value="NJ">NJ</option>
<option value="NM">NM</option>
<option value="NV">NV</option>
<option value="NY">NY</option>
<option value="OH">OH</option>
<option value="OK">OK</option>
<option value="OR">OR</option>
<option value="PA">PA</option>
<option value="RI">RI</option>
<option value="SC">SC</option>
<option value="SD">SD</option>
<option value="TN">TN</option>
<option value="TX">TX</option>
<option value="UT">UT</option>
<option value="VA">VA</option>
<option value="VT">VT</option>
<option value="WA">WA</option>
<option value="WI">WI</option>
<option value="WV">WV</option>
<option value="WY">WY</option>
</select>
<input type="Submit" value="Submit" name="Submit">
</form>
<?php
}
else {
$hostname = "localhost";
$username = "dbuser";
$password = "password";
$dbName = "testdb";
$connect = mysql_connect($hostname, $username, $password) or die ("Unable to connect to host");
mysql_select_db($dbName) or die ("Unable to connect to database");
mysql_close($connect);
}
?>
This is the results script:
<?php
$hostname = "localhost";
$username = "dbuser";
$password = "password";
$usertable = "dbtable";
$dbName = "testdb";
if (!mysql_connect($hostname, $username, $password))
die("Can't connect to database");
if (!mysql_select_db($dbName))
die("Can't select database");
$result = mysql_query("SELECT fld_companyName, fld_warnState, fld_numEmployees FROM {$usertable} WHERE fld_warnState = 'NY' ");
if (!$result) {
die("Query to show fields from table failed");
}
$fields_num = mysql_num_fields($result);
echo "<h1>Table: {$usertable}</h1>";
echo "<table border='1'><tr>";
for($i=0; $i<$fields_num; $i++)
{
$field = mysql_fetch_field($result);
echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
while($row = mysql_fetch_row($result))
{
echo "<tr>";
foreach($row as $cell)
echo "<td>$cell</td>";
echo "</tr>\n";
}
mysql_free_result($result);
?>
Thanks
