Guriddo » Topic: Not populating JSON data

Not populating JSON data

Guriddo
Not populating JSON data

This topic has 7 replies, 3 voices, and was last updated 15 years, 9 months ago by Wakie.

Creator

Topic
July 7, 2010 at 6:21 pm #76636

Wakie
Participant

Hi all,

I've been trying to debug this for ages with no success, hopefully someone can point me in the right direction.

I'm trying to replicate one of the examples in the documentation but can't get it to work. Here's my client-code:

http://www.w3.org/TR/xhtml1/DT…..tional.dtd“>
http://www.w3.org/1999/xhtml“>
Creator

Topic

Viewing 7 replies - 1 through 7 (of 7 total)

Author

Replies
July 7, 2010 at 6:33 pm #95124

churd
Participant

I had a super hard time getting JSON data to populate… it ended up being the way that it was connecting to the database.

Assuming that your files are setup properly on the server (I made sure mine were by manually populating the data without any JSON or XML calls)… what I did was replace the “dbconfig.php” call with my own connection document, and then replace the “$db = ” in my server.php file with my own connection item.

Any chance you could paste your entire server.php file? (excluding your login info, of course).

July 7, 2010 at 7:08 pm #95126

Wakie
Participant

Hi churd,

It's essentially a hacked up version of the demo PHP script, but here it is anyway:

<?php $page = 1;//$_GET['page']; // get the requested page $limit = $_GET['rows']; // get how many rows we want to have into the grid $sidx = $_GET['sidx']; // get index row - i.e. user click to sort $sord = $_GET['sord']; // get the direction if(!$sidx) $sidx =1; // connect to the database $db = mysql_connect('localhost', 'root', '') or die("Connection Error: " . mysql_error());
mysql_select_db('fone_site') or die("Error conecting to db."); $result = mysql_query("SELECT COUNT(*) AS count FROM invheader a, clients b WHERE a.client_id=b.client_id"); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count'];
if( $count >0 ) {

July 7, 2010 at 7:24 pm #95127

churd
Participant

Not sure I'll be able to help you, but my issue was in the $db portion…

Are you sure that the following allows you proper access to your database?

$db = mysql_connect('localhost', 'root', '')

July 7, 2010 at 7:26 pm #95128

churd
Participant

Is it pulling up a blank table, or no table at all?

July 7, 2010 at 7:51 pm #95129

Wakie
Participant

Database connectivity is fine, it returns the JSON output in my first post. I'm pretty concerned that even the provided examples don't work…

July 7, 2010 at 8:13 pm #95130

Reg
Participant

Hello,

This may be a red herring, but I got burned on something similar to this today, until I found the following note in the jQuery site:

July 8, 2010 at 5:25 am #95133

Wakie
Participant

Hi Reg, thanks for your reply.

Unfortunately your tip made no difference – my JSON now looks like this:

{"page":"1","total":"100","records":"1","rows":[{"id":"200","cell":["200","111","test","664.3","144","900","yay"]}]}

Regards

Wakie
Author

Replies