Return php array to ajax not working

Question

I am running a query to database which fetch a row and i want to return it as array which can accessed as array['min'], array['max'] etc. if i echo it with specific index, it shows the value correctly in ajax but i am unable to pass complete row through it to the ajax file.

PHP file:

<?php 
  // Database logic here
    $calid = reset($_POST);
    require '../incs/connect.php';
    $sql=mysqli_query($con,  "SELECT * FROM calcus_sets WHERE sets_id=$calid ");
    WHILE($row=mysqli_fetch_array($sql))
    {
        echo $row['min'];   break;
    }
    mysqli_close($con);
?>

JS file:

function DB_Fetecher(ops){
    $.ajax({
          type: "POST",
          data: {ops},
          url: "calcus_es1-fetcher.php",
          success: function(res)
          {
            //  alert( res );
            alert(res);
          }
    });
}

This code get right value from mysql but i want to pass full row to ajax and then use each index in ajax itself to put into textboxes.

Eddie · Accepted Answer · 2018-01-31 12:19:22Z

1

You can pass array by:

<?php 
  // Database logic here
    $calid = reset($_POST);
    require '../incs/connect.php';
    $sql=mysqli_query($con,  "SELECT * FROM calcus_sets WHERE sets_id=$calid ");

    $result = array();
    WHILE($row=mysqli_fetch_array($sql))
    {

        $result[] = array( "min" => $row['min'], "max" => $row['max'] );
    }
    mysqli_close($con);

   echo json_encode( $result );
?>

On your js, make sure to specify dataType:"json",

function DB_Fetecher(ops){
    $.ajax({
          type: "POST",
          data: {ops},
          url: "calcus_es1-fetcher.php",
          dataType:"json",
          success: function(res)
          {
            //  alert( res );
            console.log(res);
          }
    });
}

Note: It is advisable to use console.log(res); instead of alert() on debugging.

edited Jan 31, 2018 at 12:19

answered Jan 31, 2018 at 12:14

Eddie

26.8k6 gold badges39 silver badges59 bronze badges

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

5 Comments

MyJobs PK Over a year ago

not working, note fetcher function runs on indexchange of select list.

Eddie Over a year ago

What do you mean by not working? Are you able to see a log?

Eddie Over a year ago

Did you check on developer tools?

Eddie Over a year ago

Great! Happy to help :)

MyJobs PK Over a year ago

Thanks you for the help

Collectives™ on Stack Overflow

Return php array to ajax not working

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related