dongyi3776 2018-08-13 07:09
浏览 366
已采纳

PHP / MySQL:SyntaxError:JSON.parse:JSON数据第1行第1列的意外字符

I have this MySQL table:

mysql> select * from  members;
+-------+-----------+-----------+
| memid | firstname | lastname  |
+-------+-----------+-----------+
|     1 | billal    | begueradj |
|     2 | bill      | gates     |
|     3 | steve     | jobs      |
+-------+-----------+-----------+
3 rows in set (0.00 sec)

I have this code:

<?php
$output = array('error' => false);
$members = array();

try {
    $db = new PDO('mysql:host=localhost;dbname=bill;charset=utf8',
                   'root',
                   ''
    );
} catch(Exception $e) {
    die('Error in connecting to DB: <br/>'.$e->getMessage());
}

$response = $db->query('SELECT * FROM members');
while($row = $response->fetch()){
    echo $row['firstname'].' ';
    echo $row['lastname'].'<br/>';
    array_push($members, $row);
}

$output['members'] = $members;
$response->closeCursor();
$json = json_encode($out);
echo $json; // outputs correctly
header("Content-type: application/json");    // error here
die();
?>

And I am getting this error message when I run the PHP file containing the PHP code above:

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

Why this happens?

P.S. Of course, when I comment this line: //header("Content-type: application/json"); the error message disappears

EDIT: New code version following the comments below:

<?php
    header("Content-type: application/json");
    $output = array('error' => false);
    $members = array();

    try {
        $db = new PDO('mysql:host=localhost;dbname=bill;charset=utf8',
                       'root',
                       ''
        );
    } catch(Exception $e) {
        die('Error in connecting to DB: <br/>'.$e->getMessage());
    }

    $response = $db->query('SELECT * FROM members');
    while($row = $response->fetch()){       
        array_push($members, $row);
    }

    $output['members'] = $members;
    $response->closeCursor();
    $json = json_encode($out); 
    //echo $json;    

?>

Still getting the same error message

  • 写回答

2条回答 默认 最新

  • douti6740 2018-08-13 07:20
    关注

    header() should be placed above all output, so before you echo anything.

    Plus, since your not encoding the whole thing to JSON, instead only parts, I'm guessing your missing start and end of the JSON.

    Correct JSON outputs:

    ex1:

    {
      "key1": "value1",
      "key2": "value2",
      "key3": "value3"
    }
    

    ex2:

    [
      {
        "key1": "value1",
        "key2": "value2",
        "key3": "value3"
      },
      {
        "key1": "value1",
        "key2": "value2",
        "key3": "value3"
      },
      {
        "key1": "value1",
        "key2": "value2",
        "key3": "value3"
      }
    ]
    

    PHP:

    <?php
    
    $output = ["error" => false, "members" => []];
    
    try {
      $db = new PDO("mysql:host=localhost;dbname=bill;charset=utf8", "root", "");
    } catch(Exception $e) {
      die("Error in connecting to DB: <br/>{$e->getMessage()}");
    }
    
    $response = $db->query("SELECT * FROM members");
    
    while($row = $response->fetch(PDO::FETCH_ASSOC)) {
      array_push($output["members"], $row);
    }
    
    $response->closeCursor();
    
    $json = json_encode($output);
    
    header("Content-type: application/json");
    
    echo $json;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 系统 24h2 专业工作站版,浏览文件夹的图库,视频,图片之类的怎样删除?
  • ¥15 怎么把512还原为520格式
  • ¥15 MATLAB的动态模态分解出现错误,以CFX非定常模拟结果为快照
  • ¥15 求高通平台Softsim调试经验
  • ¥15 canal如何实现将mysql多张表(月表)采集入库到目标表中(一张表)?
  • ¥15 wpf ScrollViewer实现冻结左侧宽度w范围内的视图
  • ¥15 栅极驱动低侧烧毁MOSFET
  • ¥30 写segy数据时出错3
  • ¥100 linux下qt运行QCefView demo报错
  • ¥50 F1C100S下的红外解码IR_RX驱动问题