-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
121 lines (110 loc) · 3.81 KB
/
index.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
<?php
# ========================== CREDENTIALS OF DATABASE ===========================
$host = "localhost";
$user = "sibylsystem";
$password = "sibylsystem";
$dbName = "ouran_portal";
$tableName = "users";
echo '<div class="loading-container">';
# =========================== INITIAL CONNECTION ==============================
$conn = mysqli_connect($host, $user, $password);
if ($conn->connect_error) {
die("Connection failed : " . $conn->connect_error);
}
# ========================== NEW CONNECTIOJN ===================================
$conn = mysqli_connect($host, $user, $password, $dbName);
if ($conn->connect_error) {
die("Connection had a problem : " . $conn->connect_error);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="styles.css">
<link rel="shortcut icon" type="image/x-icon" href="images/ouran-logo.png" />
<title>LOADING...</title>
</head>
<body>
<div class="createObjects">
<div>
<?php
# ========================= CREATION OF DATABASE ==============================
$sql = "CREATE DATABASE IF NOT EXISTS " . $dbName;
$retval = mysqli_query($conn, $sql);
if (!$retval) {
die('DATABASE CREATION FAILED ' . mysqli_error($this->db_link));
} else {
echo '<p>DATABASE <b>' . $dbName . '</b> CREATION <span style="color:green;"> SUCCESS </span></p>';
}
?>
</div>
<br><br>
<div>
<?php
# =========================== CREATION OF TABLE ===============================
$sql = "CREATE TABLE IF NOT EXISTS " . $tableName . "(" . "stud_id int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY," .
"username varchar(40) NOT NULL," .
"password varchar(30) NOT NULL," .
"name varchar(100) NOT NULL," .
"department varchar(100) NOT NULL," .
"level varchar(30) NOT NULL," .
"course varchar(100) NOT NULL," .
"gender char(1) NOT NULL," .
"contact_num varchar(20) NOT NULL," .
"religion varchar(100) NOT NULL," .
"mariStat varchar(50) NOT NULL," .
"homeAddress varchar(200) NOT NULL," .
"emailAddress varchar(200) NOT NULL," .
"mothers_name varchar(100) NOT NULL," .
"fathers_name varchar(100) NOT NULL," .
"picture varchar(255) NOT NULL," .
"birthday date NOT NULL," .
"origProvince varchar(100) NOT NULL," .
"nationality varchar(50) NOT NULL," .
"studbatch year(4) NOT NULL," .
"birthPlace varchar(100) NOT NULL," .
"contactPerson varchar(100) NOT NULL," .
"contactPersonRs varchar(50) NOT NULL," .
"contactPersonNum varchar(20) NOT NULL); ";
$retval = mysqli_query($conn, $sql);
if (!$retval) {
die('TABLE CREATION FAILED ' . mysqli_error($this->db_link));
} else {
echo '<p>TABLE <b>' . $tableName . '</b> CREATION <span style="color:green;"> SUCCESS </span> </p>';
}
?>
</div>
<br><br>
<div>
<?php
# ============================== ADMIN CONNECTION ============================
$sql = "SELECT * FROM " . $tableName . " WHERE username ='admin'";
$retval = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($retval);
if (is_array($row)) {
echo '<p style="color: Green"><b>ADMIN CONNECTED!</b></p>';
} else {
echo '<p style="color: Red"><b>ADMIN FAILED TO CONNECT!</b></p>';
}
?>
</div>
<br><br>
<div>
<p style="text-align: center">Redirecting to school portal....</p>
</div>
<br><br>
<div>
<a href="login.php"><p style="text-align: center" class="redirecting"><b>Click to head to the page if it doesnt return at 5 seconds.</b></p></a>
</div>
</div>
</div>
<script>
setTimeout(function(){
window.location.href='login.php';
}, 5000);
</script>
</body>
</html>