weixin_33704591 2016-03-03 15:06 采纳率: 0%
浏览 166

PHP json_encode呼应true

I have a code to make a query over my db, and get back the response and put them in fields over my html. I want to send the response via JSON, then create the fields using that information. But when I echo my json_encode($json_output) I only get a [true].

If anyone can explain me why I'll be appreciated.

Javascritp code:

$($cadView).find('#cadForm').on('submit', function(e){

e.preventDefault();         

var str = $('#srBar').val();    

if(str == ""){

alert("Campo de busca vazio.");

}else{

$.post($('#cadForm').attr('action'), {q : str}, function(data){                     

alert(data);    


});
}

PHP code:

<?php

$q = $_POST['q'];

require('connect.php');

$i = 0;

$sql="SELECT `_nome`, `_endereco`, `_telefone`, `_imgstring`, `_dtAcesso`, `_descricao`, `_fkIdUser` FROM `tbvisitante` WHERE _nome = ?";
$stmt= $conn->prepare($sql);
$stmt->bind_param('s', $q);


if ($stmt){
    $stmt->execute();

    $stmt->bind_result($rName, $rEndereco, $rTelefone, $rImgString, $rDtAcesso, $rDescricao, $rFkIdUser);

    while ($row = $stmt->fetch()){    

        $json_output[] = $row;

        echo json_encode($json_output);

    }
}

mysqli_close($conn);    

?>
  • 写回答

1条回答 默认 最新

  • weixin_33733810 2016-03-03 15:08
    关注

    http://php.net/manual/en/mysqli-stmt.fetch.php

    mysqli_stmt::fetch returns null or a boolean. You are binding the result to variables, those are what you're supposed to use.

    Otherwise you may look into get_result instead of fetch.

    评论

报告相同问题?

悬赏问题

  • ¥15 对于squad数据集的基于bert模型的微调
  • ¥15 为什么我运行这个网络会出现以下报错?CRNN神经网络
  • ¥20 steam下载游戏占用内存
  • ¥15 CST保存项目时失败
  • ¥15 树莓派5怎么用camera module 3啊
  • ¥20 java在应用程序里获取不到扬声器设备
  • ¥15 echarts动画效果的问题,请帮我添加一个动画。不要机器人回答。
  • ¥15 Attention is all you need 的代码运行
  • ¥15 一个服务器已经有一个系统了如果用usb再装一个系统,原来的系统会被覆盖掉吗
  • ¥15 使用esm_msa1_t12_100M_UR50S蛋白质语言模型进行零样本预测时,终端显示出了sequence handled的进度条,但是并不出结果就自动终止回到命令提示行了是怎么回事: