HTML Help

Re: Saving form data to a csv file

marynorn — Thu Sep 21, 2006 2:48 pm

Author: marynorn

Posted: Thu Sep 21, 2006 2:48 pm

Nifty! Thanks

Re: Saving form data to a csv file

degsy — Thu Sep 21, 2006 6:21 am

Author: degsy

Posted: Thu Sep 21, 2006 6:21 am

basic example from here
http://uk2.php.net/manual/en/function.fwrite.php

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
if(isset($_POST['Submit'])){
$name = $_POST['name'];
$email = $_POST['email'];
$comment = $_POST['comment'];
$err = '';

if(trim($name)==''){
   $err .= '-Please enter a name<br>';
}
if(empty($email)){
   $err .= '-Please enter an email address';
}
if(strlen($comment)==0){
   $err .= '-Please enter a comment<br>';
}

if($err!=''){
   echo $err;
}
else{
   $filename = 'file.txt';
   $somecontent = $name . ',' . $email . ',' . $comment . "\n";

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

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

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

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

      fclose($handle);

   } else {
      echo "The file $filename is not writable";
   }
}
}
?>
<form name="form1" method="post" action="">
<p>Name:
<input name="name" type="text" id="name" value="Joe">
<br>
Email:
<input name="email" type="text" id="email" value="joe@email.com">
<br>
Comment:</p>
<p>
<textarea name="comment">This is my comment</textarea>
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
</html>

Re: Saving form data to a csv file

marynorn — Mon Sep 18, 2006 4:32 pm

Author: marynorn

Posted: Mon Sep 18, 2006 4:32 pm

Thanks for the links, I get the feeling that should be a very simple thing to do, if only I knew the right questions to ask. That's the problem with being self-taught: you never know where the gaps in your knowledge are.

Re: Saving form data to a csv file

degsy — Mon Sep 18, 2006 5:33 am

Author: degsy

Posted: Mon Sep 18, 2006 5:33 am

Stick with PHP then. PHp can grab form data and write it to a text file.

http://www.w3schools.com/php/php_post.asp
http://www.w3schools.com/php/php_file.asp
http://uk.php.net/manual/en/function.fwrite.php

Saving form data to a csv file

marynorn — Fri Sep 15, 2006 11:05 am

Author: marynorn

Posted: Fri Sep 15, 2006 11:05 am

I've been using formmail for a while to gather data on-line. However, I'm now receiving so much data that yanking it out of e-mails and putting it into Excel manually is a time consuming pain in the butt. I know it's possible to set up a cgi script that sends form data to a csv file that could be downloaded at the end of every week, but I have no idea how.

Any help on this subject would be appreciated.

(I have experience with HTML and CSS, have a vague idea what mySQL and PHP are, and am completely clueless about CGI and Perl)