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");

What did you get on the var_dump? Update the question with the data — Dekel
– Dekel, Commented Jan 26, 2017 at 0:18

mwweb · Accepted Answer · 2017-01-26 00:46:06Z

2

For encoding problem try this:

$con->set_charset("utf8");

answered Jan 26, 2017 at 0:46

mwweb

7,9454 gold badges21 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

php json encode not output anything

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related