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

the authentiocate user behaivor is set to store the member ID as a session variable:

"sessionColumns" => explode($WA_Auth_Separator,"MemberContactID".$WA_Auth_Separator."MemberID"),
"sessionNames" => explode($WA_Auth_Separator,"MemberContactID".$WA_Auth_Separator."MemberID"),


but think about order of operations. this code block is setting a list of perameters that are going to be sent into the WA_AuthenticateUser function

you cant at the same time tell the function to lookup the session variable, and tell it to use the session in the success redirect:
"successRedirect" => "../events/booktickets.php?EventID=".$_GET['EventID']."&MemberID=".$_SESSION['MemberID'],


the session hasn't been looked up yet.

leave the success redirect blank, and add header function after the WA_AuthenticateUser function


<?php header("Location: ../events/booktickets.php?EventID=".$_GET['EventID']."&MemberID=".$_SESSION['MemberID']); ?>

I get what you are saying.

I tried as you suggested,, but now the authentication fails

at what point do i add the redirect ?

immediately after the WA_AuthenticateUser function, after the last curly bracket or in a separate block ?

do i need a block of code to confirm the user has been authenticated brfore the redirect is carried out ?

the header should be in a seperarte code block after WA_AuthenticateUser function

Thanks Jason

I put the header in a

if(isset($_POST["Check"]) || isset($_POST["Check_x"])){

block,

using the logic that a fail redirect will reload the page before this line is reached.

seems to work ;-)

glad to hear it is working.

oops, spoke too soon.

Bizarrely, it seemed to work at first, but now, it doesn't.

I know the email address I key in is correct, and if i put the redirect path after "successRedirect", it works.

If I change it to the code below, I get the failed message

<?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" => "",
	"failRedirect" => "/events/booktickets_check.php?EventID=".$_GET['EventID']."&failed=true",
	"gotoPreviousURL" => FALSE,
	"keepQueryString" => FALSE
	);
	
	WA_AuthenticateUser($WA_Auth_Parameter);
	
}
?>
<?php 
if(isset($_POST["Check"]) || isset($_POST["Check_x"])){
	header("Location: /events/booktickets.php?EventID=".$_GET['EventID']."&MemberID=".$_SESSION['MemberID']); 
}?>

I'll need to troubleshoot directly, see the private message section.

PM

see PM