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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to