Flipshot Posted April 22, 2009 Share Posted April 22, 2009 Hello everyone, is there a way to have an e-mail compared to one in a database during a members application? Our Lodge has a website with a secured page. Can the e-mail used to apply in the php forum be compared to our database( we used password robot for our members section) to verify that they are a member? The reason I ask is to maintain anonymity on our forum so that no one sees the actual e-mail. Thanks for any help. ??? Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/ Share on other sites More sharing options...
Mchl Posted April 22, 2009 Share Posted April 22, 2009 Probably yes. Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816858 Share on other sites More sharing options...
gnawz Posted April 22, 2009 Share Posted April 22, 2009 YES. As some one registers, the first script should be an SQL comparing the registration email against the existing email fields in the database. Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816866 Share on other sites More sharing options...
Flipshot Posted April 22, 2009 Author Share Posted April 22, 2009 Is it possible for someone to post or PM me with the necessary code? Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816870 Share on other sites More sharing options...
Mchl Posted April 22, 2009 Share Posted April 22, 2009 No it is not. How are we supposed to help you without seeing your code first? I could send you the code I use, and you would just reply 'I doesn't work', becasue it wouldn't fit your application at all! Please read: http://www.phpfreaks.com/page/forum-rules Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816875 Share on other sites More sharing options...
gnawz Posted April 22, 2009 Share Posted April 22, 2009 sth like $sql = SELECT * FROM table W emailfield = registrationemail eg $sql = SELECT * FROM table WHERE emailaddress = $_POST['regemail']; If ($sql) { echo "Email already in system. Welcome member"; } else { SQL TO REGISTER USER } Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816878 Share on other sites More sharing options...
Flipshot Posted April 22, 2009 Author Share Posted April 22, 2009 My Bad. :-X Will ask in the Free Lance Forum. Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816880 Share on other sites More sharing options...
gnawz Posted April 22, 2009 Share Posted April 22, 2009 Always make sure you have some code so we help edit it or search in code databases Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816882 Share on other sites More sharing options...
Flipshot Posted April 22, 2009 Author Share Posted April 22, 2009 Thanks Wish me LUCK!!! Quote Link to comment https://forums.phpfreaks.com/topic/155260-solved-database-verification-comparison/#findComment-816899 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.