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
Post a Comment