php - How can I send valid JSON back to iOS application? -


i have problem. i'm trying weeks fetch data database, encode json , send ios application. problem every time json not valid says http://jsonviewer.stack.hu/ here code have now:

//connection database  $dbhandle = mysql_connect($hostname, $username, $password)   or die("unable connect mysql");  //echo "connected mysql<br>";   //select database work $selected = mysql_select_db("test",$dbhandle)  or die("could not select examples");  $result = mysql_query("select * test.debiteur sort_naam '%eri%'");    while($row = mysql_fetch_array($result, mysql_assoc)) {  $deb_nr['deb_nr'] = $row['deb_nr']; $deb_naam['name'] = $row['deb_naam']; $deb_adres['adrs'] = $row['deb_adres'];   $testje = array_merge($deb_nr, $deb_naam, $deb_adres);  $testjevervolg = array('klanten' => array($testje));   sendresponse(200, json_encode($testjevervolg));  }  } 

this returns:

{ "klanten": [ {   "deb_nr": "10010",   "name": "erika handelsonderneming",   "adrs": "aan de heibloem 17" } ] }{ "klanten": [ {   "deb_nr": "25071",   "name": "afdeling heffing & invordering",   "adrs": "postbus 1275" } ] }{ "klanten": [ {   "deb_nr": "25247",   "name": "v.d. heerik b.v.",   "adrs": "flemingstraat 3-5" } ] }{ "klanten": [ {   "deb_nr": "25454",   "name": "toering automatisering",   "adrs": "appelhof 17a" } ] }{ "klanten": [ {   "deb_nr": "25601",   "name": "ratering bouw & industrie",   "adrs": "de hogenkamp 1" } ] } 

that get. problem is, there should array of 'klanten' , there should every deb_nr, name , adrs be. every thing gets own 'klanten' how can solve this?

thanks.

created haven't tested, used textwrangler maybe can move forward.

can try this:

$completejson = array();   while($row = mysql_fetch_array($result, mysql_assoc)) {  $deb_nr['deb_nr'] = $row['deb_nr']; $deb_nr['name'] = $row['deb_naam']; $deb_nr['adrs'] = $row['deb_adres'];    array_push($completejson,$deb_nr);    }  $testjevervolg = array('klanten' => $completejson);  sendresponse(200, json_encode($testjevervolg)); 

Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -