dongou3158 2015-02-16 19:44
浏览 40

json php返回字符串null

I am following a very interesting tutorial which will help me a lot But I'm in trouble.

My php

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=ISO-8859-1");
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '123456';
$dbname = 'directory';
$sql = "select e.id, e.firstName, e.lastName, e.title, e.picture, count(r.id) reportCount " . 
    "from employee e left join employee r on r.managerId = e.id " .
    "group by e.id order by e.lastName, e.firstName";
try {
    $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);  
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $dbh->query($sql);  
    $employees = $stmt->fetchAll(PDO::FETCH_OBJ);
    $dbh = null;
    echo '{"items":'. json_encode($employees) .'}'; 
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}'; 
}
?>

some are returning null string especially when they have accents.

I tried several alternatives like as

header("Content-Type: application/json; charset=utf-8");

and

mysql_query("SET character_set_results=utf8", $dbh) 
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 设计简单目录管理系统,要满足以下内容
    • ¥15 关于九十度混合耦合器信号分析问题
    • ¥15 Cesm如何关闭不用的模块呢
    • ¥15 vue2两层数据导出为excle
    • ¥15 有人能帮我做一下这个项目吗
    • ¥15 网络上传速率比下载速率高
    • ¥15 (标签-游戏|关键词-网页游戏)
    • ¥15 这个咋搞🥹可能需要手把手教
    • ¥15 接口和关键字的问题,多选
    • ¥15 yolov5s模型下载就卡住,没有运行结果