NYCPHP Meetup

NYPHP.org

[nycphp-talk] Returning DB results as XML or JSON?

Jake McGraw jmcgraw1 at gmail.com
Thu Dec 3 14:29:48 EST 2009


On Thu, Dec 3, 2009 at 2:19 PM, Gary Mort <garyamort at gmail.com> wrote:
>
>
> On Thu, Dec 3, 2009 at 2:11 PM, Anthony Papillion <papillion at gmail.com>
> wrote:
>>
>> While this seems (and indeed is) a rather simple task, it's also fairly
>> tedious. Is there anything out there that can help me auto-format them in
>> one of those formats? Something that takes a standard results set then
>> transforms it into either XML or JSON?

Here is how I would do it (using json_encode or simplexml):

http://snipt.net/jakemcgraw/mysql-to-json-or-xml

- jake

>>
>
> json_encode
>
> http://www.php.net/manual/en/function.json-encode.php
>
> --
> ----
> Hudson Valley Sudbury School
> What GPL is for application users
> Our school is for students
> Help your children grow, change, and learn
> Let your child direct, control, amend
> Check out http://www.sudburyschool.org
>
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation
>



More information about the talk mailing list