-
Notifications
You must be signed in to change notification settings - Fork 10
/
logincheck.php
55 lines (41 loc) · 1.66 KB
/
logincheck.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
<?php
require_once 'login.php';
$conn=new mysqli ($db_hostname,$db_username, $db_password, $db_database);
if ($conn->connect_error){
echo "Failed to connect: " . $conn->connect_error;
}
$loginname=$_GET['loginname'];
$loginpin=$_GET['loginpass'];
$query="SELECT * FROM userlist WHERE email = '$loginname' AND `password` = '$loginpin'";
echo "<script>console.log('".$query."')</script>";
$result=$conn->query($query);
if($name=$_GET['username']){
if ($result->num_rows>0) {
echo "<script type='text/javascript'>alert('User email has been registered. Please try another one.'); window.location.href='index.html';</script>";
}else{
$rtmp = $conn->query("SELECT MAX(id) FROM userlist;");
$userid=1;
if($rtmp->num_rows!=0){
$r=$rtmp->fetch_assoc();
$userid=$r['MAX(id)'];
$userid++;
}
$query="INSERT INTO userlist (id,name,email, password) VALUES ('$userid','$name','$loginname', '$loginpin')";
$conn->query($query);
echo "<script type='text/javascript'>alert('Thank you for registering. Please login to view the website.'); window.location.href='index.html';</script>";
}
}else{
if ($result->num_rows ==0) {
echo "<script type='text/javascript'>alert('Username and Password do not match our records.'); window.location.href='index.html';</script>";
} else {
$r=$result->fetch_assoc();
$userid=$r['id'];
echo "<script type='text/javascript'>alert('You are logged in.')</script>";
session_start();
$_SESSION['userid']=$userid;
// include 'Homepage.php';
echo "<script>window.location.href='Homepage.php';</script>";
}
}
$conn->close();
?>