getting JSON data from php page

Question

My PHP web page is returning a JSON string. I wrote following function to get those data and display them on jQuery mobile listview.

function LoadJsonDataFunction()
{  
  $.getJSON("my_web_page.php", function(obj) {
    $.each(obj, function(key, value){
      $("ul").append("<li>"+value.fname+"</li>");
    });
  });
}

Here is my listview code:

<ul data-role=listview> </ul>

I have called to the function in the body tag

<body onload="LoadJsonDataFunction()">

but when I executing the program it displays "undefine" and no data.

then I change $.getJSON() request like this.then its working perfectly.

$.getJSON("some_page_returning_same_json_string.json",function(obj) { .....

let me know how can i fix this.

PS. Here is my php page output..

{
  "employees":[
    {
      "fname": "sdsdsd",
      "lname": "sdsd",
      "phone": "sdsd",
      "gender": "female",
      "dob": "1990-03-11",
      "address": "03",
      "nic": "erer",
      "email": "erererer",
      "empid": "ererere",
      "designation": "sdsds",
      "qualifications": "dsds"
    }
  ]
}

Here is my php code

<?php
  header('Content-Type: application/json');
  /*
    Following code will list all the employees
  */

  // array for JSON response
  $response = array();

  // include db connect class
  require_once __DIR__ . '/db_connect.php';

  // connecting to db
  $db = new DB_CONNECT();

  // get all employees from employees table
  $result = mysql_query("SELECT * FROM emp_master") or die(mysql_error());

  // check for empty result
  if (mysql_num_rows($result) > 0) {
    // looping through all results
    // employees node
    $response["employees"] = array();

    while ($row = mysql_fetch_array($result)) {
      // temp user array
      $employee = array();
      $employee["fname"] = $row["fname"];
      $employee["lname"] = $row["lname"];
      $employee["phone"] = $row["phone"];
      $employee["gender"] = $row["gender"];
      $employee["dob"] = $row["dob"];
      $employee["address"] = $row["address"];
      $employee["nic"] = $row["nic"];
      $employee["email"] = $row["email"];
      $employee["empid"] = $row["empid"];
      $employee["designation"] = $row["designation"];
      $employee["qualifications"] = $row["qualifications"];

      //push single employee into final response array
      array_push($response["employees"], $employee);
    }
    // success
    // $response["success"] = 1;
    // echoing JSON response

    echo json_encode($response);
  } else {
    // no employees found
    $response["success"] = 0;
    $response["message"] = "No employees found";

    // echo no users JSON
    echo json_encode($response);
  }
?>

Are you returning json string with json_encode/json_decode from php? — Jai
– Jai, Commented Sep 25, 2013 at 9:57

BAD_SEED · Accepted Answer · 2013-09-25 09:56:37Z

3

Have you write correct header? If not write this as first line in your PHP:

header('Content-Type: application/json');

answered Sep 25, 2013 at 9:56

BAD_SEED

5,10611 gold badges62 silver badges116 bronze badges

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

1 Comment

san88 Over a year ago

yes..i have added header after your comment.but still displaying the previous "undefined" item on the list.

Arfeen · Accepted Answer · 2013-09-25 10:28:49Z

2

Change the line:

 $.each(obj, function(key, value){

with

 $.each(obj.employees, function(key, value){

The "employees" contains in "obj" and then it contains the array. "obj" does not contain the array you are looking.

answered Sep 25, 2013 at 10:28

Arfeen

2,6235 gold badges30 silver badges49 bronze badges

Comments

chakroun yesser · Accepted Answer · 2013-09-25 10:01:44Z

0

This is the best exemple i used to begin JQM , you can check the link or use the code below

$('#ListPage').bind('pageinit', function(event) {
    $.getJSON('some_php_or_json_file_link', function(data) {
        $('#listView li').remove();
        $.each(data.items, function(index, item) {
            $('#listView').append('<li><span>' + item.json_label1 + '</span></li>');
        });
        $('#listView').listview('refresh');
    });
});

answered Sep 25, 2013 at 10:01

chakroun yesser

1,4971 gold badge15 silver badges20 bronze badges

Collectives™ on Stack Overflow

getting JSON data from php page

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related