dan182skater Posted October 25, 2006 Share Posted October 25, 2006 Hello everyone, how do I add into my SQL database an "@" symbol after someone types in the first part of their email address? What I mean is I have a blank text box followed by "@berkeley.edu and I want people to only type in the first part of their Berkeley email address. Basically, only people that have a Berkeley email addresses can sign up on my site. So there are two basic functions I need:1. Verify that the guest who is signing up ONLY typed in letters, numbers, etc (ONLY things that would be in the first part of an email, before the "@")2. Automatically insert into the form/database/whatever the @berkeley.edu for every email.Any help is greatly appreciated. THANKS! Quote Link to comment Share on other sites More sharing options...
marcus Posted October 26, 2006 Share Posted October 26, 2006 just do[code]$sql = "INSERT INTO dbtable (`email`) VALUES ('$email@berkeley.edu');";$result = mysql_query($sql);[/code] Quote Link to comment Share on other sites More sharing options...
jwk811 Posted October 26, 2006 Share Posted October 26, 2006 you can change it into a variable in the script by doing this:[code]<?$first_part = $_POST['first_part'];$domain = "@berkeley.edu";$email = $first_part . $domain;?><?echo "$email";?>[/code]the email variable would then be the first part of what they entered and the domain would be at the end coming out into the full email like that.. Quote Link to comment Share on other sites More sharing options...
dan182skater Posted October 26, 2006 Author Share Posted October 26, 2006 Thanks for your replies!!!! But where do I type in the code? I uploaded join.php to my site here:http://www.blissfulhost.com/banners/join.zipIf anyone could download that file (which is a zip with one file, join.php) and tell me where (line number, etc) to put in the code, I will repay you someway, somehow. THANKS!Also, it is a zip file just to make sure it doesn't load in the browser and so that you can download it to youre computer to open it with your php editor of choice.THANKS!-Daniel Quote Link to comment Share on other sites More sharing options...
jwk811 Posted October 26, 2006 Share Posted October 26, 2006 once someone goes to log in.. the form action should lead to a script that sends the email or whatever you're trying to do with it.. Quote Link to comment 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.