-
Notifications
You must be signed in to change notification settings - Fork 0
/
dsubmit.php
59 lines (56 loc) · 1.86 KB
/
dsubmit.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
<html>
<head><title>Home Page</title></head>
<body>
<?php include "header.php"; ?>
<marquee>Form for year 2016-17.</marquee><br>
<link rel='stylesheet' href='style.css'>
<center><p>
<?php
session_start();
$uname=$_POST['uname'];
$pass=$_POST['pass'];
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error());
mysql_select_db("developer") or die(mysql_error());
$result=mysql_query("SELECT * FROM user WHERE username='$uname' AND password='$pass'");
$row = mysql_fetch_array($result) or die(mysql_error());
$result1=mysql_query("SELECT * FROM local");
$row1 = mysql_fetch_array($result1);
if(($row['username'] AND $row['password']) OR ($row1['username'] AND $row1['password']))
{
if($row1['username'] AND $row1['password'])
{
$result=mysql_query("SELECT * FROM user WHERE username=(select username from local) AND password=(select password from local)") or die(mysql_error());
$row = mysql_fetch_array($result);
}
else
{
mysql_query("CREATE TABLE local(username varchar(20),password varchar(20))");
mysql_query("DELETE FROM local");
mysql_query("INSERT INTO local(username,password) VALUES ('$uname','$pass')");
}
$name=$row['first_name']." ".$row['middle_name']." ".$row['last_name'];
echo "Welcome " .$name.".<br>";
echo "<p> ";
echo "<br/><form action='dedit.php'>
<input type='submit' value='Click here to edit data' class='button1'>
</form>";
echo "<br/><form action='dshow.php'>
<input type='submit' value='Click here to see data' class='button1'>
</form>";
echo "<br/><form action='home.html'>
<input type='submit' value='Logout' class='button1'>
</form>";
echo "</p>";
}
else
{
echo 'Password or Username is invalid<br>Please try again or signup<br><form action="home.html"><input type="submit" value="Click here to go to Home page" class="button1"></form>';
}
?>
</p>
</center>
</body>
</html>