-
Notifications
You must be signed in to change notification settings - Fork 1
/
logintest.php
49 lines (39 loc) · 1.23 KB
/
logintest.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
<?php
include("connect_sql.php");
$u = $_POST['login'];
//$e = $_POST['email'];
$p = $_POST['password'];
//$sql = "INSERT INTO \"Users\" (\"LoginID\", \"Password\", \"EmailID\",\"FirstName\",\"LastName\") VALUES('$u','$p','$e','Anmol', 'Garg')";
//$sql = "INSERT INTO \"Users\" (\"UserID\",\"LoginID\", \"Password\", \"FirstName\",\"LastName\", \"EmailID\") VALUES ('1','$u','$p', '$fn','$ln', '$e')";
//$user_info = “INSERT INTO table_name (username, email) VALUES ('$_POST[username]', '$_POST[email]')”;
//if (!mysql_query($user_info, $connect)) { die('Error: ' . mysql_error()); }
$sql = "SELECT * from \"Users\" where \"LoginID\" = '$u' and \"Password\" = '$p'";
//echo $sql;
$query = pg_query($db, $sql);
$num = pg_num_rows($query);
//echo $num;
if (!$query) {
//echo "An error occurred.\n";
exit;
}
while ($row = pg_fetch_row($query)) {
//echo "Author: $row[0] E-mail: $row[1]";
$lu=$row[0];
echo "<br />\n";
}
if ($num == "1") {
$expire=time()+60*60*24;
setcookie("userID", $lu, $expire);
session_start();
$_SESSION['userID']=$lu;
session_write_close();
header("Location: cons.php");
die();
}
else {
header("Location: index.php");
die();
}
//echo “Your information was added to the database.”;
//pg_close();
?>