php json encode not output anything

Question

I have simple php script that shoud output json, but it dont work

<?php 

require 'connect.php';

$sql = "SELECT * FROM horizont";
$result = $con->query($sql);
$rows = array();
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
             $rows[] = $row;
    } 
} 
echo '<pre>';
var_dump($rows);
echo '</pre>';

echo json_encode($rows);
?>

i get result on var dump , but not json code.

var dump result:

connect.php

<?php
$con = mysqli_connect("localhost","root","","horizont");

// Check connection
 if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 ?>

Fixed with :

 $con->set_charset("utf8");

Possibly related: http://stackoverflow.com/q/19361282/2298301 — Dhruv Saxena, Jan 26 '17 at 00:17
What did you get on the var_dump? Update the question with the data — Dekel, Jan 26 '17 at 00:18
i tried var_dump(json_encode($rows)); , result -> bool(false) — marko marinovic, Jan 26 '17 at 00:28
According to your `var_dump()` output the array is called `$resultArray` but your code does not do a `var_dump($resultArray);` **Please post the real code** PSEUDO CODE gets a PSEUDO ANSWER — RiggsFolly, Jan 26 '17 at 00:32
its en encoding problem, try this `json_encode( $rows, JSON_UNESCAPED_UNICODE );` — mwweb, Jan 26 '17 at 00:34
Still not the output from this code. I am out of here, to late to fight for correct information — RiggsFolly, Jan 26 '17 at 00:39
show us correct code. try this `mysql_set_charset("utf8", $con);` after `$con = ...` line — mwweb, Jan 26 '17 at 00:40
@markomarinovic if you wat to access the output with ajax you have to add the header `header('Content-type: application/json');` — mwweb, Jan 26 '17 at 00:52

score 2 · Accepted Answer · answered Jan 26 '17 at 00:46

2

For encoding problem try this:

$con->set_charset("utf8");

answered Jan 26 '17 at 00:46

mwweb

7,625
4
19
24

php json encode not output anything

1 Answers1