将php数组转换为json

Kavi 发表于 Dev

卡维

我有以下代码

$sql = "SELECT * FROM vendor";
$result = mysqli_query($conn, $sql);
$posts = array();
if (mysqli_num_rows($result) > 0) 
    {
        while($row = mysqli_fetch_assoc($result)) 
            {
               array_push($posts , $row);
            }
    }
echo"<pre>";
  print_r($posts);
echo "</pre>";

header('Content-type: application/json');
echo json_encode('list'=>$posts);

$ posts包含我现在需要的数组。我希望将其转换为json。我尝试了这两种方法

echo json_encode($posts, JSON_UNESCAPED_UNICODE);
echo json_encode($posts)

但没有任何结果。我的PHP版本是5.5.21（CGI）

有人可以帮我吗。

山姆

在这里尝试这段代码...

<?php
header('Content-Type: text/html; charset=utf-8' );

$servername = "";
$username = "";
$password = "";
$dbname = "";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn)
    {
        die("Connection failed: " . mysqli_connect_error());
    }
mysqli_query($conn,"set character_set 'utf8'");
mysqli_set_charset($conn, "utf8");
mysqli_query($conn,"SET NAMES 'utf8'");

$sql = "SELECT * FROM vendor ";
$result = mysqli_query($conn, $sql);
$posts = array();
if (mysqli_num_rows($result) > 0) 
    {
       while($row = mysqli_fetch_assoc($result)) 
            {
              array_push($posts , $row);
            }

        echo json_encode(array('list'=>$posts), JSON_UNESCAPED_UNICODE);        
    }
else 
    {
        echo stripslashes(json_encode(array('list'=>'No list available')));
    }    
?>