-
Notifications
You must be signed in to change notification settings - Fork 0
/
searchPRIMARY.php
71 lines (65 loc) · 1.92 KB
/
searchPRIMARY.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
<?php
$dsn = "mysql:host=localhost;dbname=studentsystem";
$host = "localhost";
$user = "root";
$password = "";
$id = "";
$name = "";
$class = "";
$math = "";
$english = "";
$science = "";
$computer = "";
$religion = "";
$total = "";
$percentage = "";
$grade = "";
function getposts1() {
$posts = array();
$posts[0] = $_POST['id'];
$posts[1] = $_POST['name'];
$posts[2] = $_POST['class'];
$posts[3] = $_POST['math'];
$posts[4] = $_POST['english'];
$posts[5] = $_POST['science'];
$posts[5] = $_POST['computer'];
$posts[5] = $_POST['religion'];
$posts[6] = $_POST['total'];
$posts[7] = $_POST['percentage'];
$posts[8] = $_POST['grade'];
return $posts;
}
//Create Connection
try {
$connect = new PDO($dsn, $user, $password);
$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (Exception $ex) {
echo 'Connection Failed' . $ex->getMessage();
}
//Selecting Data
if (isset($_POST['submit'])) {
$data = getposts1();
if (empty($data[0])) {
echo 'Enter Your ID!';
} else {
$searchstmt = $connect->prepare("SELECT * FROM `resultsprimary` WHERE id = :id");
$searchstmt->execute(array(
':id' => $data[0],
));
if ($searchstmt) {
$resultskg = $searchstmt->fetch();
$id = $resultskg[0];
$name = $resultskg[1];
$class = $resultskg[2];
$math = $resultskg[3];
$english = $resultskg[4];
$science = $resultskg[5];
$computer = $resultskg[6];
$religion = $resultskg[7];
$total = $resultskg[8];
$percentage = $resultskg[9];
$grade = $resultskg[10];
}
}
}
?>