PHP build a specific JSON string from postgresql Database

Question

I want use zachhunters json to html tabel script with my postressql db so i need a specific JSON string format but i dont know how to build it ... (i am new in json)

Link to the Script

I get my data using

$result = pg_fetch_array($rs, NULL, PGSQL_ASSOC);

When i use json_encode($result) i get this:

{"id":"2","surname":"Max","name":"Muster"} etc.

For the Script i need somthing like:

{ "d": "[{\"id\":1,\"Username\":\"Sam Smith\"},{\"id\":2,\"UserName\":\"Fred Frankly\"}]" }

How can i handle this?

I highly doubt that you need JSON containing a JSON string. You probably need JSON containing an array containing your row objects. — ThiefMaster
– ThiefMaster, Commented Nov 13, 2012 at 7:52

ThiefMaster · Accepted Answer · 2012-11-13 07:50:51Z

2

In each loop where you fetch an element from your database store the $result in an array $rows.

After the loop simply use json_encode(array('d' => $rows)) to create JSON containing all your data.

answered Nov 13, 2012 at 7:50

ThiefMaster

320k85 gold badges607 silver badges648 bronze badges

Add a comment |

Collectives™ on Stack Overflow

PHP build a specific JSON string from postgresql Database

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related