Won't display session information
| From: | jeremy spielmann | Date: | Thu, 28 Feb 2002 18:28:10 +0000 |
| Subject: | Won't display session information | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86639@lists.php.net to get a copy of this message | ||
I'm working on a simple session management program for logging in and I can't seem to get
the information to properly display. I would really appreciate a second look from someone.
Code is below
<?
//main line
session_start()
session_register("FirstName");
session_register("Email");
ConnectDB();
global $objConn;
if ($_SESSION["FirstName"] == null && $_REQUEST["Email"])
{
Login_Form();
}
else
{
if ($_REQUEST["Email"] != null)
{
$strSQL = "SELECT * FROM users WHERE Email = '"
.$_REQUEST["Email"]."' AND FirstName =
'".$_REQUEST["FirstName"]."'";
$rs = $objConn->Execute($strSQL);
if ($rs->EOF)
{
Access_Denied();
}
else
{
$_SESSION["FirstName"] = $rs->fields["FirstName"];
$_SESSION["Email"] = $rs->fields["Email"];
//redirect at this point
}
}
}
//---------------------------------------------------------------------------------------------
function ConnectDB()
{
global $objConn;
$db_type = "mysql";
$db_location = "localhost";
$db_uid = "xxx";
$db_pwd = "xxx";
$db_name = "login";
include("wrapper/adodb.inc.php");
$objConn = NewADOConnection($db_type);
$objConn->Connect($db_location, $db_uid, $db_pwd, $db_name);
$objConn->debug = false;
}
I'm kind of lost here.... I'm new to PHP, but have developed in both Perl and TCL before
so the syntax is familiar.
Thanks for the help in advance,
Jeremy