result_processing_system/edit.php at master · sifat009/result_processing_system · 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
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
<?php
	include('include/db.php');
	$reg_no = $_REQUEST['reg_no'];
	$query = "SELECT * FROM students JOIN results USING (reg_no, semester) WHERE reg_no = $reg_no";
	$statement = $db->prepare($query);
	$statement->execute() or die("Couldn't Connect");
	$results = $statement->fetchAll(PDO::FETCH_ASSOC);

	if(isset($_REQUEST['submit'])) {
		$reg = $_REQUEST['reg'];
		$dept = $_REQUEST['dept'];
		$semester = $_REQUEST['semester'];
		$gpa = $_REQUEST['gpa'];
		$cgpa = $_REQUEST['cgpa'];

		$query1 = "UPDATE students SET reg_no = $reg , semester = '$semester', dept_name = '$dept' WHERE reg_no = $reg_no";
		$query2 = "UPDATE results SET reg_no = $reg , cgpa = '$cgpa', gpa = $gpa, semester = '$semester' WHERE reg_no = $reg_no";

		$statement1 = $db->prepare($query1);
		$statement1->execute() or die("COULDN'T CONNECT");

		$statement2 = $db->prepare($query2);
		$statement2->execute() or die("Connection Error");
		header("location: viewall.php");
	}

?>
		<?php
			include('common/header.php');

		?>
		<!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens -->
		<?php
			include('common/sidebar.php');
		?>

        <div id="page-wrapper">

            <div class="container-fluid">

                <!-- Page Heading -->
                <?php
					include('common/page_heading.php');
				?>
                <!-- /.row -->

                <div class="col-lg-12">
                <form action="" method="post" >
                	<table class="table table-striped">
					  <thead>
						<tr>
						  <th>Reg No.</th>
						  <th>Department</th>
						  <th>Semester</th>
						  <th>GPA</th>
						  <th>CGPA</th>
						</tr>
					  </thead>
					  <tbody>
						<tr>
						  <td>
						  	<input class="form-control" type="text" value="<?= $results[0]['reg_no'] ?>" name="reg" >
						  </td>
						  <td>
						  	<div class="form-group row " >
								<select class="form-control" name="dept" id="dept">
									  <option value="cse" >CSE</option>
									  <option value="ece" >ECE</option>
									  <option value="bba" >BBA</option>
								</select>
							</div>
						  </td>
						  <td>
						  	<div class="form-group row " >
								<select class="form-control" name="semester" id="semester">
								      <option value="1st" >1st</option>
									  <option value="2nd" >2nd</option>
									  <option value="3rd" >3rd</option>
									  <option value="4th" >4th</option>
									  <option value="5th" >5th</option>
									  <option value="6th" >6th</option>
									  <option value="7th" >7th</option>
									  <option value="8th" >8th</option>
								</select>
							</div>
						  </td>
						  <td>
						  	<input class="form-control" type="text" id="gpa" name="gpa" value="<?= $results[0]['gpa'] ?>" >
						  </td>
						  <td>
							  <input class="form-control" type="text" id="cgpa" name="cgpa" value="<?= $results[0]['cgpa'] ?>" >
						  </td>
						</tr>
					  </tbody>
					</table>
               		<input class="btn btn-lg btn-primary pull-right " type="submit" value="update" name="submit">
                </form>

                </div>


                <div id="page-wrapper"></div>
                <div id="page-wrapper"></div>
                <div id="page-wrapper"></div>
                <div id="page-wrapper"></div>

                <!-- /.row -->

            </div>
            <!-- /.container-fluid -->

        </div>
        <!-- /#page-wrapper -->

		<!-- footer	-->

		<?php
			include('common/footer.php');
		?>