How to save info to database? (7)
I used to collect my opt-in form info using Aweber.
But now I want to save them to my database (MySQL?).
Are there any tutorials that teach this specifically?
I want it to save all the info collected on the form then redirect to the thank you page.
Why not just save it to a csv?
Do you need to re-access the data? If not I would just save it to a csv file....it makes it easier if your using your own mailer...
Is it easier to save to csv?
Either way, I don't know how to do it.
DB stuff turns me off.
Not really looking to do mailing, but to verify data and check patterns.
Anyone knows how to do this?
Originally Posted by shanktank
send data from the form via GET...to data.php save the code below...as "data.php" and change the variables as needed
[PHP]
<?php
$fname = $_GET["fname"];
$lname = $_GET["lname"];
$email = $_GET["email"];
$phone = $_GET["phone"];
$zip = $_GET["zip"];
// format the data
$data = $fname . "\t" . $lname. "\t" . $email . "\t" . $zip . "\t" . $phone;
// write the data to the file
file_put_contents('/path/to/your/file.txt', $data, FILE_APPEND);
// send the user to the new page
header("Location: http://path/to/your/thankyou/page.html");
exit();
?>
[/PHP]
@Polar - might be a dumb question, but would you need to set permissions on that file.txt to avoid others from reading it?
Can't find the example I was using myself a while ago, but if you google "php mysql database tutorial/example" and similar terms, there are tons of walk-throughs online that will get you going...
Home > Technical & Creative Skills > Programming, Servers & Scripts