kabucek Posted November 17, 2008 Share Posted November 17, 2008 Hello All,I want to create php system that will validate when usersregister for the event today (for example), it will check in mysql database ifthey did not registered for this event before.Any suggestions welcome.Thanks !! Link to comment Share on other sites More sharing options...
kabucek Posted November 18, 2008 Author Share Posted November 18, 2008 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 More sharing options...
ripken204 Posted November 25, 2008 Share Posted November 25, 2008 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now