current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite
1

So im trying to figure out the best way to get MySql table data into either a multidimensional PHP array or convert that multidimensional array into a json string.

Essentially what im trying to do is have a php include that returns the JSON string so i can iterate through it. I am needing a single key with multiple values, so im not 100% sure that im headed in the right direction.

I want to assign multiple values to the same key, for example:

[{"key1": "package1", "package2", "package3"}, {"key2": "package1", "package2", "package3", "package4"}]

I think that is not going to work right? Because i dont have any type of index's?

share|improve this question
3  
Have you tried json_encode? That should have handled everything for you. (It will output the json in the right format, not the one you specified, which is incorrect as json arrays should be represented differently.) –  Edison Nov 3 '12 at 4:17
    
possible duplicate of Parsing JSON file with PHP –  brenjt Nov 3 '12 at 4:35

2 Answers 2

up vote 4 down vote accepted

That is not valid JSON. The structure you are looking for would be something like:

[
 {"key1": ["package1", "package2", "package3"]},
 {"key2": ["package1", "package2", "package3", "package4"}]
          ^ An array as the value to the key "key1", "key2", etc..
]

At the PHP side, you would need something like:

  1. For every row fetched from MySQL
    • $arr[$key] = <new array>
    • for each package:
      • append package to $arr[$key]
  2. echo out json_encode($arr)
share|improve this answer
    
My ultimate goal is to have each item in the 'db' table as a key and then for each key have all the various 'values' that are in the database under that 'key/table' –  user616 Nov 3 '12 at 4:44
    
Trying to get the second array appended to the first..kicking my arse –  user616 Nov 3 '12 at 5:14
up vote 1 down vote

JS arrays have an implicit array keying, starting at index 0. What you've got is a perfectly valid JS array, the equivalent of having written:

var x = []; // create new empty array
x[0] = {"key1": .... }; // first object
x[1] = {"key2": ....} // second object

Note that the contents of your {} sub-objects is NOT valid.

You should never EVER built a JSON string by hand. It's too unreliable and easy to mess up. It's just easier to use a native data structure (php arrays/objects), then json_encode() them. Ditto on the other end of the process - don't decode the string manually. Convert to a native data structure (e.g. json_decode(), JSON.parse()) and then deal with the native structure directly.

essentially, JSON is a transmission format, not a manipulation format.

share|improve this answer
    
+1 to explain about the js's JSON format.. :) –  jogesh_pi Nov 3 '12 at 4:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.