Help - Search - Members - Calendar
Full Version: validation for users when sign up for event
MSFN Forums > Coding, Scripting and Servers > Web Development (HTML, Java, PHP, ASP, XML, etc.)

   


Google Internet Forums Unattended CD/DVD Guide
kabucek
Hello All,

I want to create php system that will validate when users
register for the event today (for example), it will check in mysql database if
they did not registered for this event before.
Any suggestions welcome.
Thanks !!
kabucek
Hi @ll,


I have the following function to check when users register to our system.
It validates f.name, l.name and email address.




QUOTE
if (implode($errorArray)=='')

{

$checkMemberArray=$memberLink->getRecordMatch('userID', $memberDataArray['emailAdr']);



if ($checkMemberArray)

{

$cFirst=strtolower($checkMemberArray['first']);

$cLast=strtolower($checkMemberArray['last']);

$mFirst=strtolower($memberDataArray['first']);

$mLast=strtolower($memberDataArray['last']);

if ($cFirst!=$mFirst or $cLast!=$mLast)

{

$command="sendAccountMail"; $destPage=$PHP_SELF; $label="here";

$quote="\"";

$clickString="onClick=".$quote."document.$formName1.operation.value='$command'; document.$formName1.action='$destPage'".$quote;

$hrefString="href='java script:submitRoutine($quote$command$quote, $quote$formName1$quote)'";

if (!$label) { $label=$command;}

$$command="<A $hrefString $clickString>$label</A>";

$errorArray['emailAdr']="Mismatch email and name";

$processMsg.="

<DIV class=processMsgError>

The email address you entered today has been used in our system with a first and last name that are different than the ones you entered. <P>





</DIV>

";

}

else

{

$memberDataArray['first']=$checkMemberArray['first'];

$memberDataArray['last']=$checkMemberArray['last'];

}

}

}



How to update this code, so when users try to register even with the good credentials it will give the message:

" You are already registered for this event, if you continue you might be charged again".

If possible use query to connect with database?





?>
ripken204
you must query the DB for this case.
i sure hope as hell that you give each user a unique id and that you store the registrations in a separate table which links the registrations to the unique user ids.
if you are, then it is as simple as, "SELECT * FROM registrations WHERE uid=$user[id] AND eventid=$event[id]"
if it returns at least 1 row then that means that the user is already registered for the specific event




Google Internet Forums Unattended CD/DVD Guide

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.