php - json response returns empty

Question

I'm using slim in my rest api, this is a get method. When it is echoed the json array is empty.

$app->get("/users", function () {

$response = array();
$db = new DbHandler();

// fetching all users
$result = $db->getAllUsers();

$response["error"] = false;
$response["users"] = array();

// looping through result and preparing users array
while ($user = $result->fetch_assoc()) {
    $tmp = array();
    $tmp["id_user"] = $user["id_user"];
    $tmp["name"] = $user["name"];
    array_push($response["users"], $tmp);
}
//var_dump($tmp);
//var_dump($response);

echoRespnse(200, $response);
});

The var_dump show me perfectly the array, the problem is in the json_encode

EDIT: here is the code of the echoResponse

function echoRespnse($status_code, $response) {
    $app = \Slim\Slim::getInstance();
    $app->status($status_code);

    // setting response content type to json
    $app->contentType('application/json');

    echo json_encode($response);
}

EDIT 2: the var_dump of the $response

array(2) {
  ["error"]=>
  bool(false)
  ["users"]=>
  array(8) {
    [0]=>
    array(2) {
      ["id_user"]=>
      int(1)
      ["name"]=>
      string(14) "Pedro Gonzalez"
    }
    [1]=>
    array(2) {
      ["id_user"]=>
      int(2)
      ["name"]=>
      string(14) "Juan Marcano"
    }
    [2]=>
    array(2) {
      ["id_user"]=>
      int(3)
      ["name"]=>
      string(12) "Ana Maria"
    }
    [3]=>
    array(2) {
      ["id_user"]=>
      int(4)
      ["name"]=>
      string(13) "Eduado Perez"
    }
    [4]=>
    array(2) {
      ["id_user"]=>
      int(5)
      ["name"]=>
      string(12) "Gilberto Perez"
    }
    [5]=>
    array(2) {
      ["id_user"]=>
      int(6)
      ["name"]=>
      string(12) "Roberto Perez"
    }
    [6]=>
    array(2) {
      ["id_user"]=>
      int(7)
      ["name"]=>
      string(12) "Juan Perez"
    }
    [7]=>
    array(2) {
      ["id_user"]=>
      int(8)
      ["name"]=>
      string(15) "Juanito Alimaña"
    }
  }
}

EDIT 3: I've solved the problem. Was something about the charset of the database, i've added this code to my connect function and its work now like a charm.

function connect() {
    include_once dirname(__FILE__) . './Config.php';

    // Connecting to mysql database
    $this->conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

    // magic trick
    if (!$this->conn->set_charset("utf8")) {
         printf("Error cargando el conjunto de caracteres utf8: %s\n", $mysqli->error);
         exit();
    } else {
         printf("Conjunto de caracteres actual: %s\n", $this->conn->character_set_name());
    }

    // Check for database connection error
    if (mysqli_connect_errno()) {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    // returing connection resource
    return $this->conn;
}

where is the json_encode happening in your code? there also seems to be a typo in "echoRespnse" — ShaneOH, Jun 01 '16 at 21:17
@Barmar the var_dump prints a classic array, but across the json_encode in the rest client i'm getting an empty response. — Rorschach, Jun 01 '16 at 21:29
Answer my question: is json_encode echoing an empty array or a totally empty result? — Barmar, Jun 01 '16 at 21:32
If it's an empty result, it may be getting an error, perhaps because of an encoding issue. — Barmar, Jun 01 '16 at 21:32
adding onto @Barmar's comment, you can use var_dump(json_encode($response)) and if that's printing out `false`, you know it's an issue with encoding — ShaneOH, Jun 01 '16 at 21:35
@ShaneOH i've tried var_dump(json_encode($response)) and its returned false, what could be the problem? — Rorschach, Jun 01 '16 at 21:48
@Rorschach show us the var_dump of ($response) inside the function, just before the json_encode — ShaneOH, Jun 01 '16 at 21:49

php - json response returns empty

0 Answers0