How I can pass array value of PHP into Ajax jQuery?

Question

I get statusText: OK value, but I cannot get PHP object or array values. https://paste.fedoraproject.org/paste/1-HWWEJKvSbCYKUkoGHytA

I have Fedora 30 with 2.4.39 HTTPd, PHP 7.6, MySQL: 10.3.12. I'm using latest jQuery. I set it into my PHP file:

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

$.ajax({
  url: 'get.php',
  type: 'post',
  })
  .done(function(a) {
    $("#workSpace").html(a); 
    alert(a)
    $.each(a, function( key, value ) {
      $("#workSpace").html(key + ": " + value);
    });
   })
   .fail(function(a) {
        $("#workSpace").html(a); 
   })
   .always(function(a) {
        var example = Object.keys(a)

        $.each(example, function( key, value ) {
       $("#workSpace").html(key + ": " + value);
    });
    });
});

I expected work with objects or array passed by PHP like this.

{id:1, name: hola, description: That's an example}
{id:2, name: hello, description: That's nice}
{id:3, name: welcome, description: That's so way}

However, I just only get statusText: OK

You need to show us how your php is sending the json to the client. — Taplar, Jun 26 '19 at 20:34
Probably a dupe also... https://stackoverflow.com/questions/4885737/pass-a-php-array-to-a-javascript-function ? — ficuscr, Jun 26 '19 at 20:35

Daniel Luna · Answer 1 · 2019-06-26T20:52:11.050

0

you will not have many responses from your PHP in one request made, try to collect all the data received from your db in a variable. Modify your php code as follows.

header('Content-type: application/json');
$conn = new mysqli('localhost','root','example','tasks');
$stmt = $conn->query("SELECT * FROM task")->fetch_array();
$array = array();
while ($getResults = $stmt->fetch_array())
{
    $array[] = $getResults;
}

/* free result set */
mysqli_free_result($getResults);

/* close connection */
mysqli_close($conn);

echo json_encode($getResults);

Regards

edited Jun 26 '19 at 20:52

answered Jun 26 '19 at 20:35

Daniel Luna

341
2
9

Need to `json_encode($array)` also remove `->fetch_array()` from the query. – AbraCadaver Jun 26 '19 at 20:41
I've tried this but It does not work. I still get statusText:OK – sincorchetes Jun 26 '19 at 22:55

score 0 · Answer 2 · answered Jun 26 '19 at 20:37

have you try something like this :

$array = array();
while ($getResults = $stmt->fetch_array())
{
    $array[] = $getResults;
}

echo json_encode($array);

and adding the content type on the $.ajax request :

  $.ajax({
    url: 'get.php',
    type: 'post',
    dataType: "json"
  })
          .done(function (a) {

            $("#workSpace").html(a);
            alert(a)
            $.each(a, function (key, value) {
              $("#workSpace").html(key + ": " + value);
            });
          })
          .fail(function (a) {
            $("#workSpace").html(a);
          })
          .always(function (a) {
            var example = Object.keys(a)

            $.each(example, function (key, value) {
              $("#workSpace").html(key + ": " + value);
            });
          });

Probably want to mention remove `->fetch_array()` from the query. — AbraCadaver, Jun 26 '19 at 20:42
I've tried this but It does not work. I still get statusText:OK — sincorchetes, Jun 26 '19 at 22:55
sure dataType? add contentType: 'application/json', on your $.ajax below dataType — Renziito, Jun 26 '19 at 23:00

How I can pass array value of PHP into Ajax jQuery?

2 Answers2