CODEWITHSUNDEEP
javascriptphpjqueryajaxcsv
Chris
Chris

Reputation: 33

Saving multidimensional Javascript array to server-side CSV

I'm trying to save a multidimensional Javascript array as a CSV file on the server. So far, my code creates the CSV file, but the file doesn't contain my array, and I'm not sure why.

(where outputData is established)

function dataSave(){
outputStr = JSON.stringify(outputData);
$.ajax({
    type: "POST",
    url: "csvout.php",
    data: outputStr,
    dataType: 'html',
});}

csvout.php:

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">

<?php    
$array = json_decode($_POST['outputStr']);
$file = fopen("out/data.csv","w");
foreach ($array as $line){
    foreach ($line as $item){
        fputcsv($file,explode(',',$item));
        }
    }

fclose($file); 
?>

</head>
<body>
</body>
</html>

The data is an array of arrays like this one-- it's data obtained from the client, who is participating in a scientific experiment. Everything is a string.

0: "tuba.mp3"
1: "prac"
2: "1"
3: "0"
4: "type1"
5. "500"

0: "clap.mp3"
1: "main"
2: "0"
3: "0"
4: "type1"
5. "300"

[...]

Upvotes: 1

Views: 394

Answers (1)

apokryfos
apokryfos

Reputation: 40720

You are passing a raw JSON string as your query parameter but are attempting to access it as a named parameter. Updated code:

function dataSave(){
outputStr = JSON.stringify(outputData);
$.ajax({
    type: "POST",
    url: "csvout.php",
    data: { outputStr: outputStr },
    dataType: 'html',
});}


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">

<?php    
$array = json_decode($_POST['outputStr']);
adding var_dump($array); here produces NULL

$file = fopen("out/data.csv","w");
foreach ($array as $line){
    fputcsv($file,$item);
}

fclose($file); 
?>

</head>
<body>
</body>
</html>

Upvotes: 1

Related Questions