Convert PHP Array to JSON object with UTF-8

Question

I have the following PHP code which pulls the data form mysql (unicode entries)

$conn = mysqli_connect("localhost", "root", "", "mapping") or die ("Error".mysqli_error($conn));
mysqli_set_charset($conn,"utf8");
$sql = "select * from villages";

$result = mysqli_query($conn, $sql) or die ("error" . mysqli_error($conn));
$myArray = array();
while($row = mysqli_fetch_assoc($result)){
    $myArray[] = $row;
}
mysqli_close($conn);

echo json_encode($myArray, JSON_UNESCAPED_UNICODE);

?>

$myArray[0] is:

{"id":"1","village":"अकबरपुर","villageEn":"akbarpur","subdiv":"हुजूर","tehsil":"हुजूर","ricircle":"रातीबढ़","patwarih":"अकबरपुर"}

When I do console.log() all the array items are shown in at once, what I want is to view them as objects[javascript (aka JSON)] in browser devtools

Browser devtools not showing objects; if it is already converted how do i display all villages using object call? — Anas
– Anas, Commented Apr 8, 2017 at 18:17
I'm not sure if I understand what you mean by "display using object call". — sidyll
– sidyll, Commented Apr 8, 2017 at 18:18
Browser devtools is showing whole data of array in a <body> not showing object view like object1{village.. subdiv...}..object2.. etc. — Anas
– Anas, Commented Apr 8, 2017 at 18:23

Jigar Parmar · Accepted Answer · 2017-04-08 18:33:38Z

4

Try this one to print in browser devtools :

$myArray = json_encode($myArray, JSON_UNESCAPED_UNICODE);
echo 'village : '.$myArray['village'];
echo 'subdiv : '.$myArray['subdiv'];

answered Apr 8, 2017 at 18:33

Jigar Parmar

412 bronze badges

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

Comments

Jeff · Accepted Answer · 2017-04-08 18:50:41Z

1

if you want to use the json in javascript you can simply do that:
(I suppose you call that php file directly, not via an ajax call!)

<?php
$conn = mysqli_connect("localhost", "root", "", "mapping") or die ("Error".mysqli_error($conn));
mysqli_set_charset($conn,"utf8");
$sql = "select * from villages";

$result = mysqli_query($conn, $sql) or die ("error" . mysqli_error($conn));
$myArray = array();
while($row = mysqli_fetch_assoc($result)){
   $myArray[] = $row;
}
mysqli_close($conn);

?>
<script>
// here's the trick!
var villages = <?php echo json_encode($myArray, JSON_UNESCAPED_UNICODE); ?>;
console.log(villages);
</script>

If you use it via an ajax call check out @julekgwa's answer!

edited Apr 8, 2017 at 18:50

answered Apr 8, 2017 at 18:36

Jeff

6,9611 gold badge19 silver badges34 bronze badges

Comments

Junius L · Accepted Answer · 2017-04-08 18:42:41Z

0

use JSON.parse() in your javascript (using jQuery).

//assuming that you are using ajax
$.post('get_villages.php', function(data) {
   var villages = JSON.parse(data);
   for (var village in villages) {
       console.log(village.id + ' ' + village.village + ' ' + village.villageEng);
   }
});

edited Apr 8, 2017 at 18:42

answered Apr 8, 2017 at 18:33

Junius L

16.2k6 gold badges61 silver badges105 bronze badges

Collectives™ on Stack Overflow

Convert PHP Array to JSON object with UTF-8

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related