Manually build JSON encodable array in PHP

Question

This is kind of a strange one. I have a CSV that I'm uploading and passing to a PHP script that parses it into arrays, encodes it into a JSON string and sends it back to be further processed by my Javascript. However, I am having difficulty getting the response in a format that is easily parsed. Maybe it can be parsed, I'm just not sure how to access the data within.

PHP script for handling and parsing the CSV:

<?php
 $file = $_FILES['file'];
 $tmp = $file['tmp_name'];
 $row = 1;
 $json = array();
 if(($handle = fopen($tmp, 'r')) !== false){
  while(($data = fgetcsv($handle, 10000, '\n')) !== false){
   $num = count($data);
   $row++;

   for($i = 0; $i < $num; $i++){
    $values = split(',', $data[$i]);

    $value = array(
     sName => $values[0],
     sNick => $values[1],
     sEmail => $values[2],
     sSSOID => $values[3],
     sPwd => $values[4],
     sConfPwd => $values[5],
     sDescr => $values[6]
    );

    array_push($json, $value);
   }
   print_r(json_encode($json));
  }
  fclose($handle);
 }
?>

The output ends up being an iterative response where the first array contains the first row of the CSV and the second array contains the first and second rows (the third array contains the first, second, and third, etc. etc.). The very last array is the response that I want. It is a well-formed JSON string; I am just unsure of how to get only that response.

Sample response:

  [{"sName":"John Doe","sNick":"John","sEmail":"[email protected]","sSSOID":"jdoe","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes cats"}][{"sName":"John Doe","sNick":"John","sEmail":"[email protected]","sSSOID":"jdoe","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes cats"},{"sName":"Bill Frank","sNick":"Bill","sEmail":"[email protected]","sSSOID":"bfrank","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes dogs"}][{"sName":"John Doe","sNick":"John","sEmail":"[email protected]","sSSOID":"jdoe","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes cats"},{"sName":"Bill Frank","sNick":"Bill","sEmail":"[email protected]","sSSOID":"bfrank","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes dogs"},{"sName":"Sam Smith","sNick":"Sam","sEmail":"[email protected]","sSSOID":"ssmith","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes music"}]

The only response I need is the final array:

[{"sName":"John Doe","sNick":"John","sEmail":"[email protected]","sSSOID":"jdoe","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes cats"},{"sName":"Bill Frank","sNick":"Bill","sEmail":"[email protected]","sSSOID":"bfrank","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes dogs"},{"sName":"Sam Smith","sNick":"Sam","sEmail":"[email protected]","sSSOID":"ssmith","sPwd":"Admin1234","sConfPwd":"Admin1234","sDescr":"Likes music"}]

scy won't contribute anymore · Accepted Answer · 2010-08-11 15:48:05Z

3

You might want to use

$json[] = $value;

instead of array_push and

echo json_encode($json);

instead of print_r. Also, move the print_r/echo call out of the while loop.

answered Aug 11, 2010 at 15:48

scy won't contribute anymore

7,3192 gold badges30 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matt Williamson Over a year ago

+1 don't know why people are saying print_r when he wants valid json

Joseph · Accepted Answer · 2010-08-11 15:45:12Z

1

Move this line to after the fclose:

print_r(json_encode($json));

answered Aug 11, 2010 at 15:45

Joseph

1,96314 silver badges22 bronze badges

2 Comments

Joe Over a year ago

Perfect! And I would access the data as 'data[i].sName;' correct?

Joseph Over a year ago

Depends on how the javascript is set up, but that should work.

Jacob Relkin · Accepted Answer · 2010-08-11 16:16:52Z

1

Try this:

$index = count($json) - 1;
echo json_encode($json[$index]);

edited Aug 11, 2010 at 16:16

answered Aug 11, 2010 at 15:41

Jacob Relkin

164k34 gold badges352 silver badges321 bronze badges

3 Comments

Joe Over a year ago

That worked out pretty well :). So, how exactly would I access the 'sName' value of the first user? I tried 'alert(data[0].sName);' but that is a 'no go'.

Ryan Kinal Over a year ago

Finding the format of the data is sometimes a pain. Try to figure out what data actually is - whether it's an array of objects, or an object itself.

Joe Over a year ago

It appears to be an array of objects: [{'a':'1', 'b':'2', 'c':'3'},{'d':'4', 'e':'5', 'f':'6'},{'g':'7', 'h':'8', 'i':'9'}]

Marc B · Accepted Answer · 2010-08-11 15:45:44Z

-1

Decode the JSON in your Javascript app, which will produce an array, then use .pop() to get the last value:

var json = json_decode('[{"sName" ......... ');
var lastelement = json.pop();

answered Aug 11, 2010 at 15:45

Marc B

362k44 gold badges433 silver badges508 bronze badges

2 Comments

scy won't contribute anymore Over a year ago

This is a terrible waste of bandwidth and resources. Remove unnecessary parts on the server side instead of encoding, transmitting and decoding them just to throw them away instantly.

Marc B Over a year ago

OP didn't say if he wanted to do the processing serverside or client-side, so I provided the client-side solution.

Collectives™ on Stack Overflow

Manually build JSON encodable array in PHP

4 Answers 4

1 Comment

2 Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related