-
Notifications
You must be signed in to change notification settings - Fork 10
/
login.php
137 lines (122 loc) · 4.16 KB
/
login.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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<?php
include("sqlcon.php");
if(isset($_POST[login]))
{
if($_POST['utype'] == "1")
{
$rs = mysqli_query($con,"select * from tbluser where emailid=".$_POST[username]." and upass=".$_POST[password]."");
if(mysqli_num_rows($rs) > 0)
{
$result = mysqli_fetch_array($rs);
$ts1 = strtotime(date("Y-m-d"));
$ts2 = strtotime($result[reg_date]);
$d1 = new DateTime(date("Y-m-d"));
$d2 = new DateTime($result[reg_date]);
$diff = $d2->diff($d1);
$age = $diff->d;
$seconds_diff = $ts1 - $ts2;
//echo "<script>alert(".$age.");</script>";
if($result[status] == "Inactive")
{
echo "<script>alert(Account Yet to be Verified!!!);</script>";
}
else if($result[status] == "Disapproved")
{
echo "<script>alert(Account disapproved by Admin!!!);</script>";
}
else if($result[membershiptype] == "Standard" && $age > 365)
{
echo "<script>alert(Membership Expired..Please Renew the memership!!!);window.location=renew.php?id=$result[0];</script>";
}
else
{
$_SESSION[uid] = $result[0];
$_SESSION[student_id] = $result[0];
$_SESSION[name] = $result[2];
$_SESSION[type] = "alumni";
$_SESSION[place] = $result[location];
echo "<script>window.location=index.php;</script>";
}
}
else
{
echo "<script>alert(Invalid credential!!!!!);</script>";
}
}
else if($_POST['utype'] == "2")
{
$rs = mysqli_query($con,"select * from tblstaff where emailid=".$_POST[username]." and staff_pass=".$_POST[password]." ");
if(mysqli_num_rows($rs) > 0)
{
$result = mysqli_fetch_array($rs);
if($result[status] == "Inactive")
{
echo "<script>alert(Account Yet to be Verified!!!);</script>";
}
else if($result[status] == "Disapproved")
{
echo "<script>alert(Account disapproved by Admin!!!);</script>";
}
else
{
$_SESSION[uid] = $result[0];
$_SESSION[name] = $result[1];
$_SESSION[type] = "staff";
echo "<script>window.location=index.php;</script>";
}
}
else
{
echo "<script>alert(Invalid credential!!!!!);</script>";
}
}
}
/* ### */ ?>
<?php
include("header.php")
/* ### */ ?>
<div class="container">
<div class="page">
<h3 align="center" >Login</h3>
<div class="bs-example" data-example-id="simple-horizontal-form">
<form action="" method="post" class="form-horizontal">
<div class="form-group">
<label for="inputEmail3" class="col-sm-4 control-label" style="text-align:right;">User type</label>
<div class="col-sm-4">
<select name="utype" id="utype" class="form-control">
<option value="1">Alumni</option>
<option value="2">Staff</option>
</select>
</div>
</div>
<div class="form-group">
<label for="inputEmail3" class="col-sm-4 control-label" style="text-align:right;">User Name</label>
<div class="col-sm-4">
<input type="text" class="form-control" id="username" name="username" placeholder="Username" required>
</div>
</div>
<div class="form-group">
<label for="inputEmail3" class="col-sm-4 control-label" style="text-align:right;">Password</label>
<div class="col-sm-4">
<input type="password" class="form-control" id="password" name="password" placeholder="Password" required>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-8" style="text-align:center;">
<label for="inputEmail3" class="col-sm-5 control-label" style="text-align:right;"><a href="reg.php">New Alumni?</a> or <a href="staffreg.php">New staff?</a></label>
<label for="inputEmail3" class="col-sm-3 control-label" style="text-align:right;"><a href="forgotpass.php">Forgot Password</a></label>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-8" style="text-align:center;">
<input type="submit" name="login" value="LOGIN" class="btn btn-default"/>
<input type="reset" name="cancel" value="CANCEL" class="btn btn-default"/>
</div>
</div>
</form>
</div>
</div>
</div>
<?php
include("footer.php")
/* ### */ ?>