validation
I have a form with a very simple check, where a user enters their email address for validation, (no password).
If the address is on the database, the user is redirected to another page, where their memberid should be appended as a get parameter.
When I set up the form with the user authentication wizard, I set emailaddress as the only column to be validated.
Can I get the memberid from my table at the same time the user authentication behaviour checks the emailaddress, (without the need to compare it), or do I need to add a lookup query to the page using the post email address as a parameter ?
<?php
if(isset($_POST["Check"]) || isset($_POST["Check_x"])){
$WA_Auth_Parameter = array(
"connection" => $PowerCMSConnection,
"database" => $database_PowerCMSConnection,
"tableName" => "tblmemberscontact",
"columns" => explode($WA_Auth_Separator,"MemberEmailAddress"),
"columnValues" => explode($WA_Auth_Separator,"".((isset($_POST["emailaddress"]))?$_POST["emailaddress"]:"") .""),
"columnTypes" => explode($WA_Auth_Separator,"text"),
"sessionColumns" => explode($WA_Auth_Separator,"MemberContactID".$WA_Auth_Separator."MemberID"),
"sessionNames" => explode($WA_Auth_Separator,"MemberContactID".$WA_Auth_Separator."MemberID"),
"successRedirect" => "../events/booktickets.php?EventID=".$_GET['EventID']."&MemberID=".$_SESSION['MemberID'],
"failRedirect" => "../events/booktickets_check.php?failed=true",
"gotoPreviousURL" => FALSE,
"keepQueryString" => FALSE
);
WA_AuthenticateUser($WA_Auth_Parameter);
}
?>
I tried adding MemberID as a session variable, but the redirect seems to append the session value of the previous memberid to the url. I don't really need the session, i just wanted to use the memberid of the validated email address