view user/uk/checkLogin.php @ 43:dbc006408d2b

ASSUMES we have SetEnv PHP_VALUE "include_path =.:/var/test/private:/var/test/ywww:/usr/share/php" in apache2/.../test.conf use dl(...) for debug logging, defined in dlog.php use doAmazonRequest in amazonBookSearch use ../private/web.php (q.v., not in mercurial) for Aserver and Aassociates Started by updating from 40:c24ae74bf6d5, i.e. just before the bug on the main line
author Charlie Root
date Sat, 05 Jan 2019 18:00:10 -0500
parents 077b0a0a3e6d
children 385ddd7c4b55 a67bf725e87b
line wrap: on
line source

<?php
require "PasswordHash.php";

include "../../private/db.php";  

// emailname and password sent from form
$email=$_GET['email'];
$mypassword=$_GET['pwd'];

// To protect MySQL injection 
$email = stripslashes($email);
$mypassword = stripslashes($mypassword);
$email = mysqli_real_escape_string($link,$email);
$mypassword = mysqli_real_escape_string($link,$mypassword);

$t_hasher = new PasswordHash(8, FALSE);


$query1 = 'select Password, FirstName, Surname, UserID from user where Email = \'' .$email .'\'';
//echo $query1 . "\n";
$data1 = mysqli_query($link, $query1);

while($line = mysqli_fetch_assoc($data1))
{
	$passHash = $line['Password'];
	$displayName=$line['FirstName'];
	$surname=$line['Surname'];
	$id=$line['UserID'];
}

$check = $t_hasher->CheckPassword($mypassword, $passHash);
if ($check) 
{

	$query2 = "select ReceiveEmail, GoodreadsState from userpref where UserID = $id";
	//echo $query1 . "\n";
	$data2 = mysqli_query($link, $query2);

	while($line = mysqli_fetch_assoc($data2))
	{
		$receiveEmail = trim($line['ReceiveEmail']);
		$GRState=trim($line['GoodreadsState']);
	}

	if($displayName == "")
		$displayName=$email;
	
	session_start();
	$_SESSION['displayName']=$displayName;
	$_SESSION['email']=$email;
	$_SESSION['surname']=$surname;
	$_SESSION['UserID']=$id;
	$_SESSION['receiveEmail']=$receiveEmail;
	$_SESSION['GRState']=$GRState;
	echo session_id();
	echo ":::" . $displayName . ":::" . $surname . ":::" . $receiveEmail . ":::" . $GRState . ":::" . $id;
}
else
{
	echo "Incorrect UserName or Password";
}
?>