dombrorj

Is there a way to avoid having multiple identical entries in a MySQL database. Visitors to my site have the option to opt-in to a newsletter by submitting their email and name to a form. This data is sent to my database, and I want to avoid people entering their info 2 or more times. Thanks for the help.

I have a form and a database put together. The form is an opt-in list to join my newsletter. The form calls a php file, which sends the visitor who submits his/her name and email a welcome message. What I need to do is make the php file also insert the submitted information to my database. So when the visitor types their name and email in the form, and clicks "submit," it sends the info to my database. How would I go about doing this? Thanks in advance!

I have a similar question. I created a table, and I want to some information from a form to be added to the db on submitt. What would I have to have in my php file to do this. Can someone spell out for me how to insert to mysql db via a php file. The info that will be inserted is simply a visitors name and email that they insert and submit in my form. Thanks!

great, thanks for the help. This will be an opt-in only mailing list, so I don't think there'll be any misconduct here. A couple things though -- is the DB secure, in that I am the only person who can access it (I've never created one before), and also, when writing a php script using notepad, do I just save it as file.php, because when I go to load it, the file is then called file.php.txt Thanks for the help. This is all self taught for me, so its hard to grasp at first.

I have a form to subscribe to my newsletter. I need to write a script that the contents of a form to me so I can add that person to my email list. Also, I need the script to send a message back to the person who filled out the form -- like a welcome message. The problem is that FormMail won't support this, but I can write a php file that can. How can upload a php file, and whereto -- does this hosting provider support this option. Also if you know a better way, that's great too. Basically I want people who fill out my form to join the newsletter to be automatically subscribed to the service, and then a message to be immediately sent to their inbox when they join -- to welcome them. It is important that I get their "real name" too. Thanks for the help!

I've spent hours and hours trying to get a form to work for me -- and I'm totally frusterated. I have a simple form that requests visitors to enter their name and e-mail address to opt-in to my newsletter. All I want it to do is send the visitor a welcome / thankyou message to their inbox when they submit the form. Also, send the info to me so I can add them to my email list. Preferably though, I would like them to be automatically added to my email list. There's got to be an easy way to do this. I've got a grasp on how to write the form and script, but it just won't work. Please help! Thanks.

To anyone familiar with the mailing list feature. Is it possible to set up the mailing list so when I post a message it will be personalized to the reciever. For example, I would like the body of the text to say: Dear $name, Where '$name' is the reciever's name that they subscribed with. Which leads to my next question. Is it possible to subscribe via e-mail, and how can I get their name. I have a form on my website for the person to register for my newsletter by giving their name and email. I want the form to be sent to the list registration. If this isn't possible here, do you know of a free mailing list platform that will allow me to do this? Thanks.

I want to put some confidential files of mine in a subdirectory, so I can access them at any time. How can I set up a password protected page for the subdirectory? Thanks in advance.

I have this form, but I need it to function correctly. View it at www.internetendeavors.net/ebook_popup.htm Here's what I need it to do: 1) Collect the data and send an autoresponder to the email collected -- also, it would be helpful to have the autoresponder send a personalized email based on the name the form collected 2) If some or all the fields were missing, then goto a failed page, if it everything was submitted, the goto success page 3) I need the collected data stored so I can add it to a mailing list. Preferably I would like the collected data to be automatically subscribed/added to my mailing list. 4) I need to set up the mailing list that will send out a message, but is personalized. In other words, set it up so it will include their name in the subject line or in the text of the body. Thanks for all the help in advance. This is complicated for me.

Howdie, I'm trying to design a popup window that the visitor can simply input their name in one field and their e-mail in another to recieve an ebook that will be sent via email. How do I do this. I created the form with Microsoft Front Page, but I'm having difficulty. Preferably I would like this form to: Collect the data and save it for me send an autorespond email that is personalized with the person's info that they entered in the form Any help is greatly appreciated