<?php session_start();

//Connor Mock
//search4.php

	$pass = $_SESSION['psw'];


	if($pass != "password")	print "Go away, you aren't family.";
	else
	{
?>
<CENTER>
<H2>
<Font color=red >
Phonebook Search Results
</H2>
<HR>
<?php
	$FNAME = $_POST['firstn'];

	$host = 'localhost';
	$user = 'cjmock';
	$passwd = 'cs389';
	$database = 'cjmock';

	$connect = mysqli_connect($host, $user, $passwd);
	$query = "select FIRST, LAST, PHONE_NUMBER from PHONE where FIRST='$FNAME' ";


	mysqli_select_db($connect, $database);
	$result_id = mysqli_query($connect, $query);

	if($result_id)
	{
		print '<table border=1>';
		print '<TH> FIRST <TH> LAST <TH> PHONE_NUMBER ';
		while($row = mysqli_fetch_row($result_id))
		{	print '<TR>';
			foreach ($row as $field)
				print "<TD> $field </TD> ";
			print '</TR>';
		}
	}
	else
		print "Fail.<p>";
	mysqli_close($connect);
}
?>
</CENTER>