douningqiu4991 2018-06-27 11:27 采纳率: 0%
浏览 19

pdo:从数据库收集数据[重复]

I'm new to php..I'm trying to collect question from database

I figure out that error appear when the reture from fetchColum is false

Fatal error: Call to a member function fetchColumn() on boolean

    //////// Collected from databse ///////
$question_id=$question_id+1;


//$no_questions = $dbo->query("select count(qst_id) from poll_qst")->fetchColumn();
$no_questions = $dbo->query("select count(question) from questions
                    left join servey_question on questions.question_id = servey_question.question_id where servey_id = serv01 ")->fetchColumn();

print("name = $no_questions
");


if($question_id > $no_questions){

$next='F'; // Flag is set to display thank you message

}else{

$next='T'; // Flag is set to display next question



$count=$dbo->prepare("select * from questions where question_id=$question_id");

if($count->execute()){

$row = $count->fetch(PDO::FETCH_OBJ);

    }
}
$main= array("data"=>array("q1"=>"$row->question","opt1"=>"$row->opt1","opt2"=>"$row->opt2","opt3"=>"$row->opt3","opt4"=>"$row->opt4","opt5"=>"$row->opt5","opt6"=>"$row->opt6","question_id"=>"$question_id"),"next"=>"$next");
// end of collection from database //////


echo json_encode($main);

my Question is why I get false as result

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c