Skip Submit button in array_keys

Question

I've got a PHP routine that processes a form and outputs the values to a CSV file. I'm using array_keys() to create the header row (skipped if there is one). Everything works perfectly except the final header term is "submit" because, of course, my form includes a Submit button. So the data ends up looking like this:

name,email,cell,dob,study,submit
"Temp One",fred@gmail.com,646-325-1111,1995-03-31,8,Submit
"Temp Two",tom@gmail.com,646-325-2222,1995-03-31,4,Submit

How do I omit the submit button both from the header and the data?

Here's my code:

if(isset($_POST['submit'])) {
    $data = array_values($_POST); // get only values
    $headers = array_keys($_POST); // keys are headers 
    if( $fp = fopen('data.csv','a+')) {
        $line = fgets($fp);
        if(!$line == $headers) {
                fputcsv($fp, $headers);
                fputcsv($fp, $data);
        }
        else
        {
            fputcsv($fp, $data);
        }
        fclose($fp);
        header('Location: thanks.php'); 
    }
}

There is some use in reading through the topics of the PHP manual when you plan to use the language a bit more. For example the section about variables and array: http://php.net/variables http://php.net/arrays — hakre, Jul 12 '13 at 23:04

score 12 · Accepted Answer · answered Jul 08 '13 at 20:37

12

Remove it from the array...

$post = $_POST;
unset($post['submit']);
$data = array_values($post); // get only values
$headers = array_keys($post); // keys are headers

answered Jul 08 '13 at 20:37

Matt S

13,731
4
45
70

1

nice one! therefor +1 – michi Jul 08 '13 at 20:40
Works perfectly - thanks so much! – Joe Lowery Jul 09 '13 at 01:04

score 1 · Answer 2 · answered Jul 08 '13 at 20:38

1

Drop the name from the Submit button in your html

and instead of

if(isset($_POST['submit']))

use

if($_SERVER["REQUEST_METHOD"] == "POST")

answered Jul 08 '13 at 20:38

Orangepill

23,853
3
38
62

score 0 · Answer 3 · answered Jul 08 '13 at 20:39

0

array_pop() will remove the last element of an array:

$data = array_pop(array_values($_POST)); // get only values
$headers = array_pop(array_keys($_POST)); // keys are headers

answered Jul 08 '13 at 20:39

michi

6,486
4
31
52

Skip Submit button in array_keys

3 Answers3