valid json file from php/mysql

Question

i've spend so many time in the net for learning google api v3 from php /mysql but no way.so i begin again asking for validate all the process First my json file, looks like that

{"lat":"46.8529510","lng":"0.5433920","ec_nom":"ANTRAN","ec_type":"ECOLE ELEM","ec_adresse":"PLACE DE L EGLISE","ec_ville":"ANTRAN","ec_cp":"86100"}

all the json file, i've seen looks like

**name[**{"lat":"46.8529510","lng":"0.5433920","ec_nom":"ANTRAN","ec_type":"ECOLE ELEM","ec_adresse":"PLACE DE L EGLISE","ec_ville":"ANTRAN","ec_cp":"86100"}**]**

My code

 $cherch_coordon=mysql_query("SELECT lat, lng,      ec_nom,ec_type,ec_adresse,ec_ville,ec_cp from mouv_0910 WHERE type_nomin='TD' AND oui_mouvement>0  ORDER BY ec_ville ");
$combien=mysql_num_rows($cherch_coordon) ;

  while ($trouv=mysql_fetch_object($cherch_coordon))
        {

          $en_jason=json_encode($trouv) ;
       //$erreur_json=last_error($en_jason);
         echo"$en_jason" ;

So is my json file's valid?

Are the *s part of the JSON? You cannot bold/italicize text inside code blocks. — gen_Eric
– gen_Eric, Commented Apr 13, 2012 at 18:40

gen_Eric · Accepted Answer · 2012-04-13 18:46:21Z

1

json_encode always prints valid JSON.

{} is for an object, [] is for an array.

P.S.

name[{"lat":"46.8529510","lng":"0.5433920","ec_nom":"ANTRAN","ec_type":"ECOLE ELEM","ec_adresse":"PLACE DE L EGLISE","ec_ville":"ANTRAN","ec_cp":"86100"}]

Is not valid JSON, or vaid anything for that matter.

Did you mean this (note the () instead of [])?

name({"lat":"46.8529510","lng":"0.5433920","ec_nom":"ANTRAN","ec_type":"ECOLE ELEM","ec_adresse":"PLACE DE L EGLISE","ec_ville":"ANTRAN","ec_cp":"86100"})

This is JSONP, not JSON.

edited Apr 13, 2012 at 18:46

answered Apr 13, 2012 at 18:41

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Desbutes Over a year ago

is my file as it is, is valid on javascript request for google maps marker ou should it have this form name({"lat":"46.8529510","lng":"0.5433920",.....,})

Desbutes Over a year ago

THANKS FOR THE SPEED OF THE ANSWER

Collectives™ on Stack Overflow

valid json file from php/mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related