将HTML表单字段创建为数组

16-Jun-16

Hi, I have an HTML form with text, radio buttons, check boxes, and text area fields. I want to write all the fields into a CSV file. It is writing to the CSV file, but unfortunately if there is a comma in any of the fields, it moves the text after the comma to the next field.

I did some research and found I should use 'fputcsv'. All the examples that I found were getting their data from a database, and creating an array. I would like to know how to create an array from the data in my form so I can use it with 'fputcsv'. Below is a sample of my code.

// Create file. If file has been created, open file.
$myfile = fopen("ZZZmycsv.csv", "a") or die("Unable to open file!");

// Write to file.
// Column headers
$msg = "First Name, Last Name, Organization, Email, City, State, Comment 1, Comment 2 
";

// Form variables
$msg .= "$firstName, $lastName, $organization, $email, $city, $state, $comment1, $comment2 
";

Please be as detailed as possible with your answers.

Thanks in advance for your time and consideration.

If you use fputcsv, there is already a default escape character ("\") so all you have to do is make an array from the form inputs and write them into the file.

// Create file. If file has been created, open file.
$myfile = fopen("ZZZmycsv.csv", "a") or die("Unable to open file!");

// Write to file.
// Column headers
$headers = array('First Name', 'Last Name', 'Organization', 'Email', 'City', 'State', 'Comment 1', 'Comment 2');
fputcsv($myfile, $headers);

// Form variables
$formArray = array($firstName, $lastName, $organization, $email, $city, $state, $comment1, $comment2);
fputcsv($myfile, $formArray);

In this example i wrote the headers into the file too, but if you're using fopen(..., "a"); this will possibly make no sense so you may want to use "w" as parameter (not if you want to store more than 1 line in the file. then dont write headers before each line)

hope this helped, cheers

PHP: There's a function for that

http://php.net/manual/en/function.fputcsv.php

Edit: To duplicate the PHP documentation:

<?php

$list = array (
    array('aaa', 'bbb', 'ccc', 'dddd'),
    array('123', '456', '789'),
    array('"aaa"', '"bbb"')
);

$fp = fopen('file.csv', 'w');

foreach ($list as $fields) {
    fputcsv($fp, $fields);
}

fclose($fp);
?>

The above example will write the following to file.csv:

aaa,bbb,ccc,dddd
123,456,789
"""aaa""","""bbb"""