prepare($sql);
foreach ($pdo->query($sql) as $row)
{
$_SESSION['firmname']=$row['firmname'];
}
if(isset($_POST['signin']))
{
$uname=($_POST['username']);
$password=($_POST['password']);
$sql ="SELECT username,password,email,rndid,comdivid,repid FROM tblemp WHERE username=:uname and password=:password and rhold=0";
$query= $pdo -> prepare($sql);
$query-> bindParam(':uname', $uname, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR);
$query-> execute();
$data = $query->fetch(PDO::FETCH_ASSOC);
//if($query->rowCount() > 0)
if(($uname==$data['username']) and ($password==$data['password']))
{
$_SESSION['username']=$data['username'];
$_SESSION['userid']=$data['rndid'];
$_SESSION['comdivid']=$data['comdivid'];
$_SESSION['repid']=$data['repid'];
$_SESSION['start'] = time();
$_SESSION['expire'] = $_SESSION['start'] + (10 * 60) ;
if ($data['rndid']==1) {
echo "";
}else {
echo "";
}
}
else{
echo "";
}
}
?>
Home Page