Email Submit/Mysql Question - WickedFire - Affiliate Marketing Forum

Tensegrity · 01-23-2008, 06:06 AM

I'm designing LPs and I got my first real client last week. In the design I made a "Name" field, and an "Email" field. My client wanted the info from those 2 fields to be sent to a database that he would have access to, and then could use that database to send out mass mailings to. Is this a mysql type of situation? Would I need some PHP script to do this? Or is this something the client should handle on his side with his Control Panel? I eventually want to get to the point where I can do all of this so I can tier my prices according to what needs to be done. Thanx for the help in advance.

babyboy808 · 01-23-2008, 06:50 AM

you took the job and don't know what to do???

Create the LP with the details he wants, checkout pear for php, it will be more secure and safe because you obviously don't know what your doing to send the details to the database and I would create a separate part of the site specifically for your client with a login and from here he can view all of the signups and I would include the functionality to save the details in a csv file.

kyleirwin · 01-23-2008, 06:51 AM

PHP Code:


			
<?php

    if(isset($_POST['email'])&&isset($_POST['name'])) {

        $email = preg_replace('/[^a-z0-9@\-_\.]/i','',$_POST['email']);

        $name = preg_replace('/[^a-z ]/i','',$_POST['name']);

        mysql_connect('localhost','dbuser','dbpw');

        mysql_query("INSERT INTO database.emails (name,email) VALUES ('$name','$email')");

        mysql_close();

        echo 'entered into database';

    }else {

        echo '<form method="post">Name: <input name="name" /><br />Email: <input name="email" /><br /><input type="submit"></form>';

    }

?>

thats the basics of what you want. you'll need to create a database, a table, and get the right db user info. there is no error handling in that script, but its somewhat secure. just go through it and google anything that you don't understand.

Choller · 01-23-2008, 07:03 AM

Quote:

Originally Posted by Tensegrity

Is this a mysql type of situation? Would I need some PHP script to do this?

If you only agreed on doing a design then i think the client should handle this, especially if you have no experience in programming (based on what i quoted above i assume that you have no or not much experience with php coding).

Or you could still tackle it and go search for some easy php+mysql tutorials. It's a perfect test if you are starting out with php+mysql programming.

Tensegrity · 01-23-2008, 03:43 PM

Quote:

Originally Posted by babyboy808

you took the job and don't know what to do???

Create the LP with the details he wants, checkout pear for php, it will be more secure and safe because you obviously don't know what your doing to send the details to the database and I would create a separate part of the site specifically for your client with a login and from here he can view all of the signups and I would include the functionality to save the details in a csv file.

You might have misunderstood me. I DESIGN landing pages...I know nothing of PHP scripting. I figured he had some programmer up his sleeve for the scripting part. I took the job for the graphic design aspect, and he later asked me if I knew how to set up the whole mysql thing. Thanx for the tips and thanx a lot Kyle for that script...I will def put it to use! Muchos Gracias for your help guys!

01-23-2008, 06:06 AM	#1 (permalink)
Tensegrity Senior Member Join Date: Dec 2007 Posts: 295 iTrader: 36 / 97%	Email Submit/Mysql Question I'm designing LPs and I got my first real client last week. In the design I made a "Name" field, and an "Email" field. My client wanted the info from those 2 fields to be sent to a database that he would have access to, and then could use that database to send out mass mailings to. Is this a mysql type of situation? Would I need some PHP script to do this? Or is this something the client should handle on his side with his Control Panel? I eventually want to get to the point where I can do all of this so I can tier my prices according to what needs to be done. Thanx for the help in advance. Share Share this post on Digg Del.icio.us Technorati Twitter

01-23-2008, 06:50 AM	#2 (permalink)
babyboy808 Content king Join Date: Sep 2006 Location: Here, there, you know Posts: 164 iTrader: 3 / 100%	you took the job and don't know what to do??? Create the LP with the details he wants, checkout pear for php, it will be more secure and safe because you obviously don't know what your doing to send the details to the database and I would create a separate part of the site specifically for your client with a login and from here he can view all of the signups and I would include the functionality to save the details in a csv file. Share Share this post on Digg Del.icio.us Technorati Twitter

01-23-2008, 06:51 AM	#3 (permalink)
kyleirwin Senior Member Join Date: Jun 2006 Location: Carlsbad Posts: 1,819 iTrader: 1 / 100%	PHP Code: <?php if(isset($_POST['email'])&&isset($_POST['name'])) { $email = preg_replace('/[^a-z0-9@\-_\.]/i','',$_POST['email']); $name = preg_replace('/[^a-z ]/i','',$_POST['name']); mysql_connect('localhost','dbuser','dbpw'); mysql_query("INSERT INTO database.emails (name,email) VALUES ('$name','$email')"); mysql_close(); echo 'entered into database'; }else { echo '<form method="post">Name: <input name="name" /><br />Email: <input name="email" /><br /><input type="submit"></form>'; } ?> thats the basics of what you want. you'll need to create a database, a table, and get the right db user info. there is no error handling in that script, but its somewhat secure. just go through it and google anything that you don't understand. Share Share this post on Digg Del.icio.us Technorati Twitter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
* ASW - Postwhore Contest #3!! *	Jon	Shooting The Shit	6680	02-18-2007 05:13 PM
Azoogle Email	sknydave	Affiliate Marketing	1	07-21-2006 05:35 PM
Email Data Source Secures Funding from New York Angels	apoorvapatel	Industry News	1	07-06-2006 09:58 AM
Bluestreak Launches BlueVision™ Email Optimization Program	apoorvapatel	Industry News	0	07-06-2006 08:50 AM
Datran Media Proving That Well-Executed Email Marketing Drives Business	apoorvapatel	Industry News	0	07-05-2006 08:34 AM