Data collection

[numerouno]

Hey guys,

I'm working on a new lead gen offer and I'm trying to find a good way for collecting/saving the data to use it or sell it later on.

Any good tools out there or I have to do this in house?

Thanks!

 

[-joe-]

<form action="myform.php" method="post">

Set up a MySQL database.
Make myform.php:
<?php
mysql_connect (localhost, databasename, password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db (databasename, $con);
$sql="INSERT INTO tablename (gender, firstname, email)
VALUES
('$_POST[gender]','$_POST[firstname]','$_POST')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
?>
<script>
javascript redirect to your page
</script>

 

[invisible777]

^ this.

 

[numerouno]

All right, I was kind of expecting this but it would have been pretty awesome to be able to save the data in some kind of system that would allow me to sell it easily to lead buyers / call centers.

 

[-joe-]

All right, I was kind of expecting this but it would have been pretty awesome to be able to save the data in some kind of system that would allow me to sell it easily to lead buyers / call centers.

Surely this does? export to excel, highlight or something as you sell them, and just copy and paste?

 

[crackp0t]

Log the errors to a text file or something. Don't display them on the page like that.

 

[stmadeveloper]

Log the errors to a text file or something. Don't display them on the page like that.

Displaying them on the page will stop the redirect so you've got two problems. Errors and they don't end up where you want them.

 

[-joe-]

Fair point. Change

{
die('Could not connect: ' . mysql_error());
}

to

{
header .......
}

 

[HockeyFan]

might want to protect against sql injection?