-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathuser_data.php
51 lines (43 loc) · 1.4 KB
/
user_data.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
<!DOCTYPE html>
<?php
$user_nisn = 0;
$user_ttl_dd = 0;
$user_ttl_mm = 0;
$user_ttl_yy = 0;
if(isset($_POST['submit'])){
$user_nisn = $_POST['user_no'];
$user_ttl_dd = $_POST['user_ttl_dd'];
$user_ttl_mm = $_POST['user_ttl_mm'];
$user_ttl_yy = $_POST['user_ttl_yy'];
}
$servername = "localhost";
$username = "";
$password = "";
$databasename = "test";
$conn = new mysqli($servername, $username, $password, $databasename);
if($conn->connect_error){
die("Connection Failed".$conn->connect_error);
}
// echo "Connection Succeed";
if($user_ttl_mm < 10) $user_ttl_mm = '0'.$user_ttl_mm;
if($user_ttl_dd < 10) $user_ttl_dd = '0'.$user_ttl_dd;
$sql = "SELECT * FROM Daftar_Siswa_Lolos WHERE NISN={$user_nisn} AND TTL='{$user_ttl_yy}-{$user_ttl_mm}-{$user_ttl_dd}'";
$result = $conn->query($sql);
// debug function
function debug_to($output){
echo "<script>console.log('Debug Objects: " . $output . "' );</script>";
}
if($result->num_rows > 0){
$row = $result->fetch_assoc();
if($row['Status'] == 1){
include 'user_dashboard.php';
// echo $row['Status'];
// debug_to($row['Status']);
} else{
include 'user_dashboard_fail.php';
}
} else {
include 'user_not_found.php';
}
$conn->close();
?>