weixin_33743661 2015-10-11 18:11 采纳率: 0%
浏览 5

JSON从php解码信息

I'm getting errors decoding JSON string.

ERROR:

Uncaught SyntaxError: Unexpected token {

My php code:

<?php 

$socket = $_GET["socket"];

$bd = new PDO("mysql:host=localhost;dbname=gestao_utilizadores" , "root" , "");

$getComponentes = $bd->prepare("SELECT * FROM componentes WHERE ( Socket=:socket )");
$getComponentes->bindValue(':socket' , $socket);
$getComponentes->execute();
$resultado = $getComponentes->fetchAll();

For ($i = 0; $i < $getComponentes->rowCount() ; $i++) { 
    $componentes = json_encode(array('tipo' => $resultado[$i]["Tipo"] , 'nome' => $resultado[$i]["Nome"] , 'socket' => $resultado[$i]["Socket"]));
    echo $componentes; 
}   

?>

My Javascript code:

$.ajax({
        url: 'compatibilidades.php',
        data: { 
            socket: $("#board option:selected").attr('value') 
        },
        success: function(dadosRecebidos) {
            teste = JSON.parse(dadosRecebidos);
            alert(teste);
        }
    });

The error is on javascript or PHP?

  • 写回答

1条回答 默认 最新

  • weixin_33727510 2015-10-11 18:15
    关注
    <?php 
    
    $socket = $_GET["socket"];
    
    $bd = new PDO("mysql:host=localhost;dbname=gestao_utilizadores" , "root" , "");
    
    $getComponentes = $bd->prepare("SELECT * FROM componentes WHERE ( Socket=:socket )");
    $getComponentes->bindValue(':socket' , $socket);
    $getComponentes->execute();
    $resultado = $getComponentes->fetchAll();
    
    $arr = array();
    
    for ($i = 0; $i < $getComponentes->rowCount() ; $i++) { 
        $componentes = array('tipo' => $resultado[$i]["Tipo"] , 'nome' => $resultado[$i]["Nome"] , 'socket' => $resultado[$i]["Socket"]);
        array_push($arr, $componentes);
    }   
    
    echo json_encode($arr); 
    
    ?>
    

    Output the JSON only once, otherwise you end up with an output of several JSON strings, something like

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

    and that's not valid JSON

    评论

报告相同问题?

悬赏问题

  • ¥15 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵