Mysql to Json

[crocodilu2008]

Hi

 

I found this fragment SQL herehttp://www.navioo.com/javascript/MySQL_to_JSON_1361.html and i need help whith the php code (example please) for sending out in a javascript file the output.

 

Thanks

 

 

[fenway]

There are also mysql UDFs for JSON.

[Mchl]

Why not use php json_encode() ?

[crocodilu2008]

There are also mysql UDFs for JSON.

 

Do you now mysql UDFs for JSON  is faster than :

SELECT

    CONCAT("[",

          GROUP_CONCAT(

              CONCAT("{username:'",username,"'"),

              CONCAT(",email:'",email),"'}")

          )

    ,"]")

AS json FROM users;

 

?

[fenway]

They should be much faster, since they're pre-compiled, but I haven't benchmarked this.