Problem in Session
Posted: Fri Jun 09, 2006 5:47 am
Hi,
I am trying to register a variable in session but when i try to retrieve the session value on next page. It gives me empty string. The code worked once but now it is not working. Can any one tell me where i am worng.
<?php
error_reporting(0);
session_start();
$server = "localhost";
$dbuser = "root";
$dbpass = "abcd";
$dbname = "abcd";
$pass = $_REQUEST['txtPwd'];
$login = $_REQUEST['txtEmail'];
if($login != "" and $pass != "")
{
$pass = md5($pass);
mysql_connect($server,$dbuser,$dbpass) or die ("Could not establish connection");
mysql_select_db($dbname);
$query_rsLogin = "SELECT email, pwd, fname, lname FROM customer WHERE pwd='".$pass."' AND email='".$login."'";
$rsLogin = mysql_query($query_rsLogin) or die(mysql_error());
if(mysql_num_rows($rsLogin))
{
while($r=mysql_fetch_array($rsLogin))
$username = $r[fname]." ".$r[lname];
session_register("username");
header('Location: search.php');
}
}
Regards,
Ghazala
I am trying to register a variable in session but when i try to retrieve the session value on next page. It gives me empty string. The code worked once but now it is not working. Can any one tell me where i am worng.
<?php
error_reporting(0);
session_start();
$server = "localhost";
$dbuser = "root";
$dbpass = "abcd";
$dbname = "abcd";
$pass = $_REQUEST['txtPwd'];
$login = $_REQUEST['txtEmail'];
if($login != "" and $pass != "")
{
$pass = md5($pass);
mysql_connect($server,$dbuser,$dbpass) or die ("Could not establish connection");
mysql_select_db($dbname);
$query_rsLogin = "SELECT email, pwd, fname, lname FROM customer WHERE pwd='".$pass."' AND email='".$login."'";
$rsLogin = mysql_query($query_rsLogin) or die(mysql_error());
if(mysql_num_rows($rsLogin))
{
while($r=mysql_fetch_array($rsLogin))
$username = $r[fname]." ".$r[lname];
session_register("username");
header('Location: search.php');
}
}
Regards,
Ghazala