[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