How can i parse json into a html table using PHP? -
How can i parse json into a html table using PHP? -
i have table in website. , have info table "http://west.basketball.nl/db/json/stand.pl?szn_naam=2014-2015&cmp_id=373" i've tried lot of thing nil works....
<!doctype html> <html> <head> <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> </head> <body> <?php $json=file_get_contents("http://west.basketball.nl/db/json /stand.pl?szn_naam=2014-2015&cmp_id=373"); $data = json_decode($json); if (count($data)) { // open table echo "<table>"; // cycle through array foreach ($data $stand) { // output row echo "<tr>"; echo "<td>$afko</td>"; echo "<td>$positie</td>"; echo "</tr>"; } // close table echo "</table>"; } ?> </body> </html>
ok first thing when getting info external source understand beingness returned.
so do
<?php $json=file_get_contents("http://west.basketball.nl/db/json/stand.pl?szn_naam=2014-2015&cmp_id=373"); $data = json_decode($json); print_r($data); result:
stdclass object ( [stand] => array ( [0] => stdclass object ( [afko] => risne stars hs 1 [id] => 2091 [status] => actief [gespeeld] => 3 [percentage] => 100.0 [punten] => 6 [tegenscore] => 149 [eigenscore] => 191 [datum] => 2014-10-05 [saldo] => 42 [team] => risne stars heren 1 [positie] => 1 ) [1] => stdclass object ( [afko] => d.b.v. arriba hs 2 [id] => 1813 [status] => actief [gespeeld] => 2 [percentage] => 0.0 [punten] => 0 [tegenscore] => 116 [eigenscore] => 102 [datum] => 2014-10-05 [saldo] => -14 [team] => d.b.v. arriba heren 2 [positie] => 10 ) [2] => stdclass object ( [afko] => valley bucketeers hs 2 [id] => 2430 [status] => actief [gespeeld] => 2 [percentage] => 0.0 [punten] => 0 [tegenscore] => 177 [eigenscore] => 70 [datum] => 2014-10-05 [saldo] => -107 [team] => valley bucketeers heren 2 [positie] => 11 ) [3] => stdclass object ( [afko] => uitsmijters hs 2 [id] => 2143 [status] => actief [gespeeld] => 2 [percentage] => 100.0 [punten] => 4 [tegenscore] => 79 [eigenscore] => 161 [datum] => 2014-10-05 [saldo] => 82 [team] => uitsmijters heren 2 [positie] => 2 ) [4] => stdclass object ( [afko] => picker reds hs 1 [id] => 2056 [status] => actief [gespeeld] => 3 [percentage] => 66.7 [punten] => 4 [tegenscore] => 193 [eigenscore] => 184 [datum] => 2014-10-05 [saldo] => -9 [team] => picker reds heren 1 [positie] => 3 ) [5] => stdclass object ( [afko] => peatminers hs 2 [id] => 6247 [status] => actief [gespeeld] => 1 [percentage] => 100.0 [punten] => 2 [tegenscore] => 36 [eigenscore] => 64 [datum] => 2014-10-05 [saldo] => 28 [team] => peatminers heren 2 [positie] => 4 ) [6] => stdclass object ( [afko] => jolly jumpers hs 1 [id] => 1994 [status] => actief [gespeeld] => 2 [percentage] => 50.0 [punten] => 2 [tegenscore] => 103 [eigenscore] => 119 [datum] => 2014-10-05 [saldo] => 16 [team] => jolly jumpers heren 1 [positie] => 5 ) [7] => stdclass object ( [afko] => tonego '65 hs 2 [id] => 2120 [status] => actief [gespeeld] => 2 [percentage] => 50.0 [punten] => 2 [tegenscore] => 107 [eigenscore] => 122 [datum] => 2014-10-05 [saldo] => 15 [team] => tonego '65 heren 2 [positie] => 6 ) [8] => stdclass object ( [afko] => amical hs 2 [id] => 1791 [status] => actief [gespeeld] => 3 [percentage] => 33.3 [punten] => 2 [tegenscore] => 180 [eigenscore] => 195 [datum] => 2014-10-05 [saldo] => 15 [team] => amical heren 2 [positie] => 7 ) [9] => stdclass object ( [afko] => s.v.z.w. hs 2 [id] => 5526 [status] => actief [gespeeld] => 3 [percentage] => 33.3 [punten] => 2 [tegenscore] => 174 [eigenscore] => 151 [datum] => 2014-10-05 [saldo] => -23 [team] => s.v.z.w. heren 2 [positie] => 8 ) [10] => stdclass object ( [afko] => twente buzzards hs 3 [id] => 2294 [status] => actief [gespeeld] => 3 [percentage] => 33.3 [punten] => 2 [tegenscore] => 196 [eigenscore] => 151 [datum] => 2014-10-05 [saldo] => -45 [team] => twente buzzards heren 3 [positie] => 9 ) ) [nummer] => ohs2c [version] => 1.0 [aantal_teams] => 11 [id] => 373 [seizoen] => 2014-2015 [naam] => oost afdeling heren senioren 2e klasse c [gewijzigd] => 2014-10-05 18:34:25 ) so know dealing object , not scalar values or array.
so seek code:-
<?php $json=file_get_contents("http://west.basketball.nl/db/json/stand.pl?szn_naam=2014-2015&cmp_id=373"); $data = json_decode($json); if (count($data->stand)) { // open table echo "<table>"; // cycle through array foreach ($data->stand $idx => $stand) { // output row echo "<tr>"; echo "<td>$stand->afko</td>"; echo "<td>$stand->positie</td>"; echo "</tr>"; } // close table echo "</table>"; } ?> php html json table
Comments
Post a Comment