WickedFire - Affiliate Marketing Forum - Internet Marketing Webmaster SEO Forum

Go Back   WickedFire - Affiliate Marketing Forum - Internet Marketing Webmaster SEO Forum > Free Section > Newbie Questions

Newbie Questions New to the whole making money online and developing your own sites thing? Post your questions here so that seasoned members can answer your questions. Please keep your questions out of the other categories. We know you're a newbie, but there's no reason to be annoying.


Welcome to the WickedFire - Affiliate Marketing Forum - Internet Marketing Webmaster SEO Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Closed Thread
 
LinkBack Thread Tools Display Modes
Old 01-23-2008, 06:06 AM   #1 (permalink)
Senior Member
 
Tensegrity's Avatar
 
Join Date: Dec 2007
Location: Brooklyn
Posts: 495
iTrader: 45 / 98%
Tensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond repute
Question 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.
Tensegrity is offline  
Sponsored Links
Old 01-23-2008, 06:50 AM   #2 (permalink)
Content king
 
babyboy808's Avatar
 
Join Date: Sep 2006
Location: Here, there, you know
Posts: 164
iTrader: 3 / 100%
babyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond reputebabyboy808 has a reputation beyond repute
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.
babyboy808 is offline  
Old 01-23-2008, 06:51 AM   #3 (permalink)
Senior Member
 
kyleirwin's Avatar
 
Join Date: Jun 2006
Location: Carlsbad
Posts: 1,820
iTrader: 1 / 100%
kyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond reputekyleirwin has a reputation beyond repute
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.
kyleirwin is offline  
Old 01-23-2008, 07:03 AM   #4 (permalink)
Senior Member
 
Choller's Avatar
 
Join Date: May 2007
Posts: 674
iTrader: 25 / 100%
Choller has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond reputeCholler has a reputation beyond repute
Quote:
Originally Posted by Tensegrity View Post
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.
Choller is offline  
Old 01-23-2008, 03:43 PM   #5 (permalink)
Senior Member
 
Tensegrity's Avatar
 
Join Date: Dec 2007
Location: Brooklyn
Posts: 495
iTrader: 45 / 98%
Tensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond reputeTensegrity has a reputation beyond repute
Quote:
Originally Posted by babyboy808 View Post
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!
Tensegrity is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -4. The time now is 06:54 PM.


WickedFire.com Copyright © 2014 - WickedFire is an international registered Trademark of Coastal Synergy LLC. You may not use any of our trademarks, copyrights, content, or images without a written approval by members of Coastal Synergy LLC.