Fetching PHP Data with Javascript and assign it to an array

Question

I've got a php script with collects data from a server and displays it in an array and after that as a json with the function.

echo json_encode($result);

Now I want to access that array with my javascript and display it. It should be saved in a var as an array so it should look like:

 data = [ "xxxx" , "ssss",];

But I guess I can simply put in my function which gets the array data instead so it'd be:

data = myfunction ;

What I've tried so far:

 function reqListener () {
     console.log(this.responseText);
         }

        var oReq = new XMLHttpRequest(); //New request object
      oReq.onload = function() {


       };
        oReq.open("get", "http://myserver.com/myscript.php", true);

oReq.send();

and

function getdata(url) {
jQuery.ajax(
        {
            type: "GET",
            url: "http://myserver.com/myscript.php/",
            dataType: "text",
            success: function (response) {
                var JSONArray = jQuery.parseJSON(response);
                connsole.log(JSONArray);
                }
        });
    }

But none seems to work and I get displayed 'undefined' instead of my arrays. Would be really great if somebody has some ideas on that and can help me out.

Edit: Since we are getting nowhere here's my php code:

<?php 
 error_reporting(0);
 $html = file_get_contents("url here");

$dom = new DOMDocument();
$dom->loadHTML($html);

 $tbodyRows = $dom->getElementsByTagName( 'tbody' )
             ->item( 0 ) // grab first tbody
             ->getElementsByTagName( 'tr' );

$result = array();
foreach( $tbodyRows as $tbodyRow )
{
  $result[] = $tbodyRow->getElementsByTagName( 'td' )
                     ->item( 2 ) // grab 3rd column
                     ->nodeValue;
 }


echo json_encode($result);
 ?>

If you open http://myserver.com/myscript.php in the browser, what's the output? — Piyin
– Piyin, Commented Jun 27, 2017 at 1:59
It's an array and after that the json encode. First in my php I have $result = array(); and at the end of my script I have var_dump( $result ); echo json_encode($result); — digitalsuite.net
– digitalsuite.net, Commented Jun 27, 2017 at 2:09
I asked you about the output because it should be a valid JSON, so if you go to http://myserver.com/myscript.php you should see something like: {"key":"value"}. If you have a var_dump, then that's probably what's causing the problem since you're printing something like: array(1) { ["key"]=> string(5) "value" }{"key":"value"} which isn't valid JSON — Piyin
– Piyin, Commented Jun 27, 2017 at 2:13
yep I'm printing what you've stated. { ["key"]=> string(5) "value" } But with the echo json_encode I'm printing a correct array format [ "value", "value2"] — digitalsuite.net
– digitalsuite.net, Commented Jun 27, 2017 at 2:15

Piyin · Accepted Answer · 2017-06-27 04:42:12Z

1

Try this code:

function getdata(url) {
  console.log('Started');
  jQuery.ajax({
    type: "GET",
    url: "http://myserver.com/myscript.php",
    dataType: "text",
    error: function (xhr) {
      console.log('Error',xhr.status);
    },
    success: function (response) {
      console.log('Success',response);
    }
  });
}

Open the browser's console, and let me know about its contents. If you don't see Error or Success, your code isn't actually executing

edited Jun 27, 2017 at 4:42

answered Jun 27, 2017 at 3:37

Piyin

1,8341 gold badge18 silver badges24 bronze badges

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

10 Comments

digitalsuite.net Over a year ago

Ok there's nothing in the console and my code is not executing. But the animation which I want to display from the Js Code works. It's only the values not coming up and instead I get 'undefined' . What should I do ?

Piyin Over a year ago

It seems like you're not calling the getdata function. Try putting getdata(); right after the function definition to call it immediately

digitalsuite.net Over a year ago

I think the problem is more about storing the result from the getdata function into a variable. What would be the correct syntax for that if the variable is "chinese" . Would it be ' var chinese = getdata(); ' ?

Piyin Over a year ago

No, the function getdata, as defined, doesn't return anything. If makes an asynchronous call to http://myserver.com/myscript.php, registers the actions for error and success and then returns. Whenever the server responds, one of those actions will be triggered so one of the console.log statements should be executed. You can call the function from anywhere in your script, or even from the console, just by typing getdata(). I updated the code so there's a third console.log so we can tell if the function has started

digitalsuite.net Over a year ago

I used your code but there were problems with my javascript. Because ajax is asynchronus and I wanted them to load synchronus

|

Kasun Dinesh Madusanke · Accepted Answer · 2017-06-27 03:16:20Z

1

I have done a similar thing earlier. I will describe it and I wish it will help you.

In the following code (get_categories.php), I am retrieving data from the database and add them to an array. Then return it by encoding as a JSON.

$sql = "SELECT category_name FROM category;";
$dataArray = [];
$result = $connection->query($sql);
if ($result) {
    while ($row = $result->fetch_assoc()) {
        $dataArray[] = $row;
    }
    echo json_encode($dataArray);
}

Then in my Javascript code, I can get the data as follows.

$.ajax({
    url: "/get_categories.php",
    type: "GET",
    dataType: "json",
    success: function (categories) {
        for (var i = 0; i < categories.length; i++) {
            console.log(categories[i]);
        }                
    },
    error: function (jqXHR, textStatus, errorThrown) {
        // Error handling code
    }
});

edited Jun 27, 2017 at 3:16

answered Jun 27, 2017 at 2:22

Kasun Dinesh Madusanke

965 bronze badges

4 Comments

Kasun Dinesh Madusanke Over a year ago

I have tested it again by initializing the array like $dataArray = ["A","B"];. Then accessed like this. dataType: "json", success: function (categories) { for (var i = 0; i < categories.length; i++) { console.log(categories[i]); } Please note that there is a small mistake in previous code. categories[i].category_name should be categories[i].

Kasun Dinesh Madusanke Over a year ago

Please note that I have corrected the mistake in the code.

digitalsuite.net Over a year ago

I didnt know what to do with that. I've tried changing my code with yours but I keep getting the same 'undefined' as before. Maybe the problem is not the array itself but declaring it ? I currently have it like this : printing = getdata ;

Kasun Dinesh Madusanke Over a year ago

Can you post the updated function which is handling the response?

Collectives™ on Stack Overflow

Fetching PHP Data with Javascript and assign it to an array

2 Answers 2

10 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related