返回数据Ajax - Mysql

Question

I'm trying to return data from a table using Mysql and Ajax, but got nothing in the variable. Connexion to database is Ok and the query is ok too.

The table contains 2 ids, which I'm trying to retrieve :

process.php

<?php
   $con = mysqli_connect('localhost','root','root','DBB');
   if (!$con) {
       die('Could not connect: ' . mysqli_error($con));
   }


   $sql="SELECT id FROM events";
   $result = mysqli_query($con,$sql);

   echo json_encode($result);

?>

The Ajax function

<script>
function print() {

    $.ajax({  
         url: "process.php",   
         dataType: 'json',
         success : function(data)
         {
             console.log(data); // OUTPUT
         } 
    });
}
</script>

Output

Object {current_field: null, field_count: null, lengths: null, num_rows: null, type: null}

Answer 1

The $result variable in PHP doesn't actually return the IDs, you have to iterate through it to get the IDs like so:

<?php
    $con = mysqli_connect('localhost','root','root','DBB');
    if (!$con) {
        die('Could not connect: ' . mysqli_error($con));
    }


    $sql = "SELECT id FROM events";
    $ids = array();
    if ($result = mysqli_query($con,$sql)) {
        while ($obj = $result->fetch_object()) {
            $ids[] = $obj->id;
        }
    }

    echo json_encode($ids);
?>