PMG4/timetable.php at master · DiscountJoe/PMG4 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<!doctype html>
<html>
<head>
  <title>Pamplin Advising Tool</title>
  <link rel="stylesheet" type="text/css" href="mystyle.css">
</head>

<body>
  <nav>

    <img src="vt.svg" height="15%" width="15%">
    <a href="landing.php">Home</a> |
    <a href="timetable.php">Course Catalog</a> |
    <a href="record.php">Registration Record</a> |
    <a href="advising.php">Registration</a>
</nav>
</br>
</br>

</body>

</html>

<?php
require_once("db.php");
session_start();

//$clientName=$_SESSION['clientName'];
//$clientID=$_SESSION['clientID'];
echo "Here are the required classes for ".$_SESSION["major_Name"].".</br></br>";

$sql = "select * from classes order by class_Number asc";
$result = $mydb->query($sql);

echo
"<table  align = 'center' style= 'background-color:papayawhip;'>
    <tr style= 'background-color:#cc6600; color:white;'>
      <th>  CRN </th>
      <th>  Class Number  </th>
      <th>  Name </th>
      <th>  Professor </th>
      <th>  Time Start  </th>
      <th>  Time End  </th>
      <th>  Days </th>
      <th>  Major ID </th>
    </tr>";

  while($row = mysqli_fetch_array($result)) {
    echo
    "<tr>
        <td>".$row['CRN']."</td>
        <td>".$row['class_Number']."</td>
        <td>".$row['name']."</td>
        <td>".$row['professor']."</td>
        <td>".$row['time_start']."</td>
        <td>".$row['time_End']."</td>
        <td>".$row['days']."</td>
        <td>".$row['major_ID']."</td>

      </tr>";
  }
  echo "</table>"


?>