<!-- fitdisplay.php
Goal: display Tables based on what their goal was
 -->
<?php
        session_start();
         $pass = $_SESSION['psw'];
        if($pass != "password") print "Go away.";
        else
        {
?>
<H2>Fitness Program(Flip flop week 1-2 if you wish to continue the program and increase wieght)</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'bddownum';
        $passwd = 'CS389';
        $database = 'bddownum';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from Fitness";
     /*  print "The query is <i> $query </i> "; */
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';     
                print '<TH> Day  <TH> Target <TH> Warm_Up
                        <TH> Lift_1 <TH> Lift_2 <TH> Lift_3 <TH> Lift_4
			<TH> Post_Workout';
                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=CS489Home.php> Go Back</A>               
</FORM>     

</CENTER>