<!-- projectCharacterSearchAct.php - Kristin Tillotson -->

<?php   session_start();
        $char = $_SESSION['char'];
        if($char == "")
                print "<A HREF=projectCharacterSelect.php>Log In</A>";
        else
                print "<A HREF=projectCharacterModify.php> $char </A> |
        <A HREF=projectLogout.php> Logout</A>";
?>

<CENTER> <A HREF=project.php> Homepage</A> |
<A HREF=projectAreas.php> Areas</A> |
<A HREF=projectCharacterDisplay.php> Characters</A><HR>
<H2><Font color=green> Souvenirs: A Fantasy Exploration Game </font></H2><HR>

<?php
	$type= $_POST['type'];
	$find= $_POST['find'];

        $host = 'localhost';
        $user = 'kvtillotson';
        $passwd = 'cs389';
        $database = 'kvtillotson';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from Characters where $type='$find'";
//        print "The query is <i> $query </i> ";	//debug
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> Name <TH> Race <TH> Item 1 <TH> Item 2 <TH> Item 3';
                while($row = mysqli_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
        }
        else
                print "Fail.<p>";

        mysqli_close($connect);
?>

<HR>
<A HREF=projectCharacterSelect.php> Select Character</A> |
<A HREF=projectCharacterCreation.php> Create Character</A> |
<A HREF=projectCharacterModify.php> Modify Character</A> |
<A HREF=projectCharacterSearch.php> Search Again</A>