queryTest.php

<HTML>
<HEAD>
<TITLE>Php Test Query</TITLE>
</HEAD>
<BODY>

<FORM ACTION="queryTest.php" method="POST">
Last Name: <INPUT type="text" size="100" name="lname">
<INPUT type="submit" value="Search">
</FORM>


<TABLE BORDER="1">
<?php

//Check if the value has been set
if(isset($_POST['lname'])){


$db_hostname='ada';
$db_database='cs450_cp';
$db_username='cs450_web';
$db_password='';

$db_server = new mysqli($db_hostname, $db_username, 
                $db_password);
//check for an error code
if($db_server->connect_errno){
   //the connection failed
   die("Unable to connect to database: " . 
        $db_server->error);
}
//echo "Success";
$db_server->select_db($db_database) or 
  die("Unable to select database.");

$lname = $_POST['lname'];
$query = "SELECT FNAME, LNAME FROM EMPLOYEE WHERE LNAME LIKE '%$lname%'";

$result = $db_server->query($query);

if(!$result){
   die("Query failed: " . $db_server->error);
}

$fields = $result->field_count;
echo '<TR>';

for($c = 0; $c < $fields; $c++){
   $field = $result->fetch_field();
   echo "<TH>$field->name</TH>";
}

echo '</TR>';

$rows = $result->num_rows;

for($r = 0; $r < $rows; $r++) {
  $row = $result->fetch_row();

  echo "<TR>";
//go through each column
  for($c = 0; $c < count($row); $c++){
    echo "<TD>$row[$c]</TD>";
  }

  echo "</TR>";
}

} //enf if(isset(....
?>
</TABLE>
</BODY>
</HTML>