current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
    
I highly doubt that you need JSON containing a JSON string. You probably need JSON containing an array containing your row objects. –  ThiefMaster♦ Nov 13 '12 at 7:52

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
Thank you very much !!! –  Phantom001 Nov 13 '12 at 9:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.