[Resolved] .csv and e-mail form results

mervyndk

Hi,

I am an absolute blockhead when it comes to programming. So please excuse me if this is a stupid question.

I have a site where users register for seminars. The php code that I had someone write for me submits their data to me by e-mail and takes them to a thankyou page where they can see the data. All of this works very well.

What I would like to do is to also have the data stored in a .csv file on my site so that I can import the data into Excel as a backup. I have no idea how to do this or even if it is possible.

Following is the part of the code I am using. I've left out the part where the variables are defined. If you can help me with this, I will also need to know where to put the new information in the existing code as I am clueless.

//List of Headers
$headers.="Content-type: text/html; charset=iso-8859-1\r\n";
$headers.="From: $email\r\nReply-To: $email";

//Declare the variables
// This line below is the E-mail address the form will be sent to.
$recipient = "myaddress@mydomain.com";
$subject = "$location Road to Financial Freedom seminar";
$message = "<html>$firstname $lastname just registered for a Road to Financial Freedom seminar. Here is the information they provided. 
Location: $location 
Date: $date 
Name: $firstname $lastname 
Second Participant: $secondname 
Address: ".urldecode($address)." 
City: ".urldecode($city)." 
Province/State: ".urldecode($state)." 
Postal Code/Zip Code: ".urldecode($zip)." 
E-mail Address: $email 
Phone Number: $phone 
Fax Number: $fax 
How did they hear about the seminar: $hear $othername 
</html>

//mail() function sends the mail
mail($recipient,$subject,$message,$headers)

Thanks for any help that you can give,

Mervyn

bastien

how are you planning to handle the file...do you want to have a bunch of people write to the file (lots of people register) and then download the whole file and erase it? or are you planning to dl a small file with just a few records everyday?

that part i will leave up to you, i will assume that the file is there and that you want to append to it (add records one below the other...)

//mail() function sends the mail 
mail($recipient,$subject,$message,$headers) 

//write to the file

//items to be written - you can add to the list simply by adding 
//the addtional variables
$logInfo = "$firstname, $lastname, $email, $city, $phone, $fax\n";



// Let's make sure the file exists and is writable first.
if (is_writable($filename)) {

// opening $filename in append mode.
// The file pointer is at the bottom of the file hence
// that's where $logInfo will go when we fwrite() it.
if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}

// Write $logInfo to our opened file.
if (!fwrite($handle, $logInfo)) {
echo "Cannot write to file ($filename)";
exit;
}

echo "Success, wrote ($logInfo) to file ($filename)";

fclose($handle);

} else {
echo "The file $filename is not writable";
}

?>

mervyndk

Bastien,

I will be downloading the results every day for 2 days before the seminar date and then downloading and saving the file permanently once the seminar is completed.

Question about the code you posted. Where it has $filename do I change that to an actual filename (for example, I will probably call the file "registrations.csv") or do I have to include one of these things
$filename = "registrations.csv"

Thanks again for your help,

Mervyn

mervyndk

When I put that code up on the website and submit a form I get a parse error for the line that starts

$logInfo = "$firstname, $lastname, $email, $city, $phone, $fax\n";

All I have done is add some more variables - all typed in correctly

Help!

bastien

can you post the complete code or email me at bastien@bastienkoert.com

thanx