/
connectivity.php
71 lines (59 loc) · 1.99 KB
/
connectivity.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
define('DB_HOST', 'localhost');
define('DB_NAME', 'attportal');
define('DB_USER','root');
define('DB_PASSWORD','');
$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
$pass = $_POST['pass'];
$email = $_POST['user'];
function SignIn() {
session_start(); //starting the session for user profile page
if(!empty($_POST['user'])) //checking the 'user' name which is from Sign-In.html, is it empty or have some text
{ $query = mysql_query("SELECT * FROM user where email = '$_POST[user]' AND password = '$_POST[pass]'") or die(mysql_error());
$row = mysql_fetch_array($query) or die(mysql_error());
if(!empty($row['email']) AND !empty($row['password']))
{
echo "SUCCESSFULLY LOGIN TO USER PROFILE PAGE...";
if($row['role']=="student"){
$sql = "SELECT * FROM user where email = '".$row['email']."'";
$dbname = 'attportal';
$conn = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,$dbname);
$result = mysqli_query($conn, $sql );
if(! $result )
{
die('Could not get data: ' . mysqli_error($conn));
}
$row = mysqli_fetch_array($result);
$userid = $row['id'];
$sql = "SELECT * FROM user natural join attendance where id='".$userid."'";
$result = mysqli_query($conn, $sql );
while($row = mysqli_fetch_array($result))
{
echo "<h3>{$row['email']}</h3>: "."<p> {$row['isPresent']}</p> <br> ".
"<p> {$row['comments']}</p> <br> ".
"<hr><br>";
}
mysqli_close($conn);
}
else if($row['role']=="teacher"){
redirect("teacher.php?email=$email");
}
else{
redirect("login.php");
}
}
else
{
echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY...";
}
}
}
if(isset($_POST['submit'])) { SignIn(); }
function redirect($url) {
ob_start();
header('Location: '.$url);
ob_end_flush();
die();
}
?>