-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstudentToTest.php
49 lines (45 loc) · 1.28 KB
/
studentToTest.php
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
<?php
// Include Database Class
include('db.php');
include('db_credentials.php');
// include('Student.php');
// Write SQL Statement
$sql = "
SELECT * FROM studentTbl WHERE exitDate IS NULL;
";
// Execute SQL Statement
$results = db::execute($sql);
echo "<table>"
. "<tr>"
. "<td>First Name</td>"
. "<td>Last Name</td>"
. "<td>Begin Date</td>"
. "<td>Expected Test Date</td>"
. "<td>Tested Date</td>";
while ($row = $results->fetch_assoc()) {
// $aStudent = new Student($row);
// echo $aStudent;
$studentID = $row['studentID'];
$firstName = $row['firstName'];
$lastName = $row['lastName'];
// $beginDate = new date(Y-m-j);
$beginDate = $row['beginDate'];
// $expectedTestDate = $beginDate + 10;
$testedDate = $row['testedDate'];
$expectedScreenDate = 10;
$screenedDate = $row['screenedDate'];
$reportCardDate = $row['reportCardDate'];
echo "<tr>"
. "<td>"
. $firstName
. "</td><td>"
. $lastName
. "</td><td>"
. $beginDate
. "</td><td>"
. $expectedTestDate
. "</td><td>"
. $testedDate
. "</td>";
}
echo "</table>";