Re: json_encode confusion

On Thu, Nov 10, 2011 at 11:24 AM, Matijn Woudt <tijnema@gmail.com> wrote: > On Thu, Nov 10, 2011 at 5:42 PM, Jim Lucas <lists@cmsws.com> wrote: >> On 11/10/2011 6:45 AM, Bastien Koert wrote: >>> Morning all, >>> >>> I've been having some fun with converting a text data file import into >>> a json object for storage. >>> >>> I have a text file that is pipe delimited coming in via an upload. The >>> first row is the headers and the second row is the data. >>> >>> Using this code: >>> >>> $data = file("inline_Nov_8_2011.txt"); >>> >>> if(count($data)==2){ >>> >>>       $keys   = explode("|", $data[0]); >>>       $fields = explode("|", $data[1]); >>> >>>       $combine = array_combine($keys, $fields); >>> >>>       $json = json_encode($combine); >>> } >>> >>> After the combine, I get an array that looks like this >>> >>> Array >>> ( >>>     ['Legal Last Name '] => Andros >>>     ['Legal Middle Initial '] => >>>     ['Legal First Name '] => Marisa >>>     ['Maiden/Other Name '] => >>>     ['Social Insurance No. '] => 123456789 >>>     ['Date of Birth '] => 2/1/1988 >>>     ['Gender '] => Female >>> ) >>> >>> But the json encoded value looks like this (there are way more >>> elements but this should be enough to represent what I need to do). >>> >>> >>> {null:"Andros",null:"",null:"Marisa",null:"",null:"123456789",null:"2\/1\/1988",null:"Female"} >>> >>> I have been googling for info about allowed values for the json keys, >>> but can't seem to find a clear doc on what is allowed and what isn't. >>> I have tried unquoted keys, replaced the spaced with underscores but >>> nothing I do seems to help. >>> >>> When I echo out the json encoded data, the keys are all nulls. >>> >>> Can someone point me in the correct direction? It may be that I need >>> to manually create the key names as an array first, which I was hoping >>> to avoid since the file format coming from the client is still in some >>> flux. >>> >> >> Looking at your input array example, I see that you have trailing spaces in your >> keys.  Looking at the working example of DiRaven, the only difference that I see >> with his example is that the input key values do not have a trailing spaces. >> json is probably having an issue with that trailing spaces. >> > > That might be a possibility, but I suspect that the single quotes > around the keys might be a problem. I haven't tried it though. > > Matijn > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Maybe use preg_split instead of explode? '/\s*|\s*/' -- assuming the spaces between fields aren't important...