JSON Padding With PHP

Question

Please can anyone assist I'm trying to get my JSON data displayed on my html5 localhost page,

I'm still new to JSON

I get the following returned but no data is loading on the page.

http://www.hostname/getCheck.php?callback?&callback=jQuery110205560797746881064_1392215061343&_=1392215061344

Please if anyone can assist.

Below is my php script

`mysql_select_db($database_xxx, $xxx); $rsfet = "SELECT * FROM cs_tracking "; $fet = mysql_query($rsfet, $xxx) or die(mysql_error()); $json = array(); while($r=mysql_fetch_array($fet)){ $json[] = $r; }

header('Access-Control-Allow-Origin: *');
echo $callback ='('.json_encode($json).')';`

and my javascript to display the table data

` 
        $(document).ready(function(){
                $.ajax({
    url: 'http://xxxxxxxxxxx.com/getCheck.php?callback=?',
    type: 'GET',
    contentType: "application/json; charset=utf-8",
    dataType: "jsonp",
    jsonp: true,
    success: function(data){
               $.each(data,function(i,photo){
                 var tblRow =""
    +""+data.CS_Track_Child+""
    +""+data.CS_Track_Date+""
    +""+data.Tracking_Status+""
    +""+data.CS_Tracking_ID+""
    +"" ;
    $(tblRow).appendTo("#userdata tbody");
     });
     },    

     });
    });`

Ja͢ck · Accepted Answer · 2014-02-13 06:17:10Z

0

The $callback variable is not magically declared in your script (at least, it shouldn't be); you can access the value via $_GET['callback'] but make sure to sanitize its value:

if (isset($_GET['callback']) && preg_match('/[A-Z]\w*/i', $_GET['callback']) {
    header('Content-Type: application/javascript');
    header('Access-Control-Allow-Origin: *');
    printf('%s(%s);', $_GET['callback'], json_encode($json));
}

answered Feb 13, 2014 at 6:17

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user948354 Over a year ago

I tried the code and my php script is generating the JSON, my table displays undefined for each value.

Vin.AI · Accepted Answer · 2014-02-13 08:06:07Z

0

You have two GET parameter of callback one is valid but empty and second is invalid.

http://www.hostname/getCheck.php?callback?&callback=jQuery110205560797746881064_1392215061343&_=1392215061344

url: 'http://xxxxxxxxxxx.com/getCheck.php?callback=?',

So remove your parameter and try with this:

url: 'http://xxxxxxxxxxx.com/getCheck.php',

answered Feb 13, 2014 at 8:06

Vin.AI

2,4373 gold badges22 silver badges42 bronze badges

2 Comments

user948354 Over a year ago

i have found the problem;

user948354 Over a year ago

I didn't call the correct data inside the table. i used data.CS_Track_Child instead of item.CS_Track_Child, i also changed (i,photo) to (i,item) Thank You for all the help.

Collectives™ on Stack Overflow

JSON Padding With PHP

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related