Jump to content

validation for users when sign up for event


Recommended Posts

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 !!

Link to comment
Share on other sites


Hi @ll,

I have the following function to check when users register to our system.

It validates f.name, l.name and email address.

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?

?>

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...