

<?
$name = $_POST['name'];
$age = $_POST['age'];
$agecondition = $_POST['agecondition'];
$namecondition = $_POST['namecondition'];

if($namecondition == "="){
$namesearch = "name LIKE '$name'";
}

if($namecondition == "contains"){
$namesearch = "name LIKE '%$name%'";
}

if($namecondition == "starts with"){
$namesearch = "name LIKE '$name%'";
}

if($namecondition == "ends with"){
$namesearch = "name LIKE '%$name'";
}

if(!empty($name)){
if(empty($search)){
$search = "$namesearch";
} else {
$search = $search." AND $namesearch";
}
}

if(!empty($age)){
if(empty($search)){
$search = "age $agecondition '$age'";
} else {
$search = $search." AND age $agecondition '$age'";
}
}

if(empty($search)){
$search = "ID < 0";
}

$query = "SELECT * FROM students WHERE $search";
?>
<?
// script to display all the records in a table

// connection information 
$hostName = "";
$userName = "";
$password = "";
$dbName = "";

// make connection to database 
mysql_connect($hostName, $userName, $password) or die( "Unable to connect to host $hostName");

mysql_select_db($dbName) or die("Unable to select database $dbName");
?>
<!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>Untitled Document</title>
</head>

<body>
<form action="" method="post" name="form1" target="_self">
  <p>name:
    <select name="namecondition" id="namecondition">
      <option><?=$namecondition?></option>
      <option>=</option>
      <option>contains</option>
      <option>starts with</option>
      <option>ends with</option>
    </select>
    <input name="name" type="text" id="name" value="<?=$name?>"> 
    age
    <select name="agecondition" id="agecondition">
      <option><?=$agecondition?></option>
      <option>=</option>
      <option>&lt;</option>
      <option>&gt;</option>
    </select>
    <input name="age" type="text" id="age" value="<?=$age?>">
</p>
  <p>
    <input type="submit" name="Submit" value="Submit">
</p>
</form>
<?=$query?>
<?
$result = mysql_query($query);

// Determine the number of employees 
$number = mysql_num_rows($result);

// Print the employee names 
echo("<br>There are $number records:<p>");
?>
<table width="728" border="1" cellspacing="0" bordercolor="#003333">
<tr>
  <td bgcolor="#003333"><span class="style1">Name</span></td>
  <td bgcolor="#003333"><span class="style1">Age</span></td>
  <td bgcolor="#003333"><span class="style1">Assignment</span></td>
  <td bgcolor="#003333"><span class="style1">Score</span></td>
</tr>
<?
$i = 0;
While ($i<$number)
{
$ID = mysql_result($result,$i, "students.ID");
$name = mysql_result($result,$i, "students.name");
$age = mysql_result($result,$i, "students.age");
?>

<tr>
  <td><?=$name?></td>
  <td><?=$age?></td>
  <td><?=$assignment?></td>
<td><?=$grade?></td>
</tr>
<?
$i = $i + 1;
}

// Close the database connection 
mysql_close();
?>
</table>
</body>
</html>