This repository was archived by the owner on Jun 3, 2025. It is now read-only.
forked from lordBuddhika/sis
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathStudentManager.php
More file actions
66 lines (56 loc) · 1.89 KB
/
Copy pathStudentManager.php
File metadata and controls
66 lines (56 loc) · 1.89 KB
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
66
<?php
/**
* Created by PhpStorm.
* User: Akhila Hashan
* Date: 10/5/2018
* Time: 9:03 PM
*/
require('ClassStaff.php');
require('common_functions.php');
class StudentManager extends Database{
function retrieveStudentData(){
$studentDataQuery = "SELECT * FROM students";
$studentDataQueryResult = Database::$DB_CONN->query($studentDataQuery);
if ($studentDataQueryResult->num_rows > 0) {
$students = [];
while($row = $studentDataQueryResult->fetch_assoc()) {
array_push($students, array(
'sid' => $row['sid'],
'fname' => $row['fname'],
'lname' => $row['lname'],
'email' => $row['email'],
'grade' => $row['grade'],
'mobile_no' => $row['mobile_no'],
'dob' => $row['dob'],
'gender' => $row['gender'],
));
}
}else{
return null;
}
return $students;
}
function retrieveStudentGrade($grade){
$studentDataQuery = "SELECT * FROM students WHERE grade =".$grade;
$studentDataQueryResult = Database::$DB_CONN->query($studentDataQuery);
if ($studentDataQueryResult->num_rows > 0) {
$students = [];
while($row = $studentDataQueryResult->fetch_assoc()) {
array_push($students, array(
'sid' => $row['sid'],
'fname' => $row['fname'],
'lname' => $row['lname'],
'email' => $row['email'],
'grade' => $row['grade'],
'mobile_no' => $row['mobile_no'],
'dob' => $row['dob'],
'gender' => $row['gender'],
));
}
}else{
return null;
}
return $students;
}
}
?>