This repository has been archived by the owner on Apr 9, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
mbview.php
126 lines (122 loc) · 4.45 KB
/
mbview.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<html>
<head>
<meta charset="UTF-8">
<link rel="stylesheet" type="text/css" href="theme.css">
<link rel="stylesheet" type="text/css" href="animate.css">
<link rel="stylesheet" type="text/css" href="font_data.css">
<script src="scripts/buttons.js" type="text/javascript"></script>
<title>Online Markbook</title>
</head>
<body>
<?php
$database = new mysqli("SERVER", "USER", "PASS", "ALIAS");
if(!$database){
echo "<script>console.log('Could not connect: $database->connect_error')</script>";
}
else{
echo "<script>console.log('Connected to database');</script>";
}
include_once("sqlquery.php");
//creates the floating form
if(isset($_POST["menu_edit"])){
echo "<div id='floatcontainer'>
<input type='button' id='action_CLOSE' value='X' onclick='StartRemove(this.id)'>
<br>
<form method='post'>
New Entry:
<table align='center'>
<tr><td class='subform'>First Name: <input class='float_form' type='text' name='f_name' required></td></tr>
<tr><td class='subform'>Last Name: <input class='float_form' type='text' name='l_name' required></td></tr>
<tr><td class='subform'>Student Number: <input class='float_form' type='number' name='s_num' required></td></tr>
<tr><td class='subform'><input class='float_form' type='submit' name='add' value='ADD STUDENT' id='action_EDIT'></td></tr>
</table>
</form>
<form method='post' style='margin-top: 3vw;'>
Delete Entry:
<table align='center'>
<tr><td class='subform'>Name/Student Number:<input class='float_form' type='text' name='entry' required></td></tr>
<tr><td class='subform'><input type='submit' id='action_DELETE' name='del' value='DELETE'></td></tr>
</table>
</form>
<form method='post' style='margin-top: 3vw;'>
Modify Entry:
<table align='center'>
<tr><td class='subform'>First Name:<input class='float_form' type='text' name='e_f_name'></td></tr>
<tr><td class='subform'>Last Name:<input class='float_form' type='text' name='e_l_name'></td></tr>
<tr><td class='subform'>Student Number:<input class='float_form' type='text' name='e_s_num'></td></tr>
<tr><td class='subform'>Subject:<input class='float_form' type='text' name='e_subj'></td></tr>
<tr><td class='subform'>Mark:<input class='float_form' type='text' name='e_mark'></td></tr>
<tr><td class='subform'><input type='submit' id='action_EDIT' name='edit' value='UPDATE'></td></tr>
</table>
</form>
</div>";
}
//process form information for adding new student
if(isset($_POST["add"])){
$fname = $_POST["f_name"];
$sname = $_POST["l_name"];
$num = $_POST["s_num"];
$sql = AddNewStudent($fname, $sname, $num);
QuerySQL($sql, $database);
}
//process form information for deleting a student
if(isset($_POST["del"])){
$info = $_POST["entry"];
if(is_numeric($info)){
$sql = DeleteStudent($info, 'StudentNum');
QuerySQL($sql, $database);
}
else{//check first name
$sql = DeleteStudent($info, 'FirstName');
$res = QuerySQL($sql, $database);
if($res == 1){//failed firstname,check last name
$sql = DeleteStudent($info, 'LastName');
QuerySQL($sql, $database);
}
}
}
//process form information for editing a student
if(isset($_POST["edit"])){
}
?>
<div class="menublock">
<div class="menutitlecontainer">
<div class="menutitle">PHP & MYSQL <sub>ONLINEMARKBOOK</sub></div>
</div>
<ul class="menucontainer">
<li><div class="menuitem">
<form method="post">
<input type="submit" name="menu_edit" value="EDIT" id="menu_button"></div>
</form></li>
<li><div class="menuitem"><a href="../index.html">↵</a></div></li>
</ul>
</div>
<div class="maincontainer">
<div class="subcontainer_phpmb">
<?php
$sql = SelectData('*','Markbook');
$tabledata = QuerySQL($sql, $database);
if($tabledata->num_rows > 0){
//table headings
echo "<table align='center'><tr class='first_col'>
<th>First Name</th>
<th>Last Name</th>
<th>Student Number</th>
</tr>";
//table content
while($field = mysqli_fetch_assoc($tabledata)){
echo "<tr class='highlightable_row'><td>".$field['FirstName']."</td>";
echo "<td>".$field['LastName']."</td>";
echo "<td>".$field['StudentNum']."</td></tr>";
}
//close the table
echo "</table>";
}
else{
echo "There are no markbook entries to view. Press EDIT to add an entry.";
}
?>
</div>
</div>
</body>
</html>