Easiest Way To Opt-In Subscribers

[squarkman]

This question is a combo question related both to PHP and MYSQL but there's no forums that I know of that do both.

I need the easiest way to opt-in subscribers using PHP and MYSQL.

ie Someone would go to my site and register to opt-in. They get an email to confirm then the info is added to the database. That's it really.

Is there an 'easiest way' to do this since I have the very basics of PHP and MYSQL but am not proficient at, and don't want to spend three days doing it.

Any thoughts would be greatly appreciated.
VeganPower!

 

[ingresman]

You want to send an email when some one has registerd ?
PHP has a mail() and there a few packages around you can use.
How much knowledge do you have? as I would think if you can put together a system of any size you will be able to do an email.
Have I misunderstood your question ?

 

[squarkman]

I think you may have misunderstood the question. I shall restate it.

What is the SIMPLEST way to design a PHP MYSQL opt-in opt-out system whereby the user may enter their name and email address. After clicking SUBMIT, the user will get an email to confirm their email address. Then, after confirming, the name and email address are entered into the database. Finally the owner of the site should easily be able to send out a mass email to all those who have opted in.
All done without seconod party software but barebones, no fluff just the basics.
Thanks for considering this question.
Rocky

 

[hvass]

Not really a MySQL question could try the PHP forum but you would be better off searching the code snippets/libraries & tutorials for your scripting language using google et. al....
If you are using PHP find any open source PHP application where you like the look of their sign up email validation process and have a look at their code....

 

[squarkman]

Ok,
I believe this to be an SQL question
I downloaded this easy to install opt-in opt-out processor. It seems to work with the exception that I (the owner of the site) never get notified in any way when a subscriber add his/her info and confirms. Am I missing the point to this, and my question is...do I need a MySQL database to collect the data or is it suppose to come directly to my email address.
Any help would be greatly appreciated.
See the page below for reference.

http://www.sendblaster.com/free-bulk-emailer-download/captcha-form-mail-double-optin/

 

[hvass]

NL-confirm.php in its documentation states

// This script will send to your list each confirmed email address

Line 64 does this...

mail($emailmanager,'Subscribe',$msg,$headers);

If you do not get an email then you need to try and work out why the PHP script does not work for you. So still nothing to do with MySQL, if you read Instructions.txt it explains what the script does and it does not require or use a MySQL database.

If you wanted the script to write a record into a database you could obviously achieve this by modifying the NL-confirm.php and replacing line 64 with something that connects to your database and writes a record into some table you design.