dongliu5475 2016-01-24 12:20
浏览 15

mysqli论坛第二个声明

First of all, sorry for my bad English (I used google translate). I already read many forums but I can not find the answer. I only know that the error is in mysqli_stmt_execute ($ stmt2) ;. I would like to keep it in Procedural style.

if(isset($_GET['subject'])){
            echo"<table>";
            $stmt = mysqli_prepare($mysqli,"SELECT * FROM `***`.`topics` WHERE categorie = ?");
            $stmt2 = mysqli_prepare($mysqli,"SELECT username FROM `***`.`users` WHERE id = ?");
            //pakketje maaken
            mysqli_stmt_bind_param($stmt, 'i' , $_GET['subject']);
            mysqli_stmt_bind_param($stmt2, 'i' , $by);
            //uitvoeren
            mysqli_stmt_execute($stmt);
            //resultaat naar php variablen
            mysqli_stmt_bind_result($stmt, $id , $question , $categorie , $by , $date);
            while (mysqli_stmt_fetch($stmt)) {
            mysqli_stmt_execute($stmt2);
            mysqli_stmt_bind_result($stmt2, $bb);
            echo'<tr><td>
        <fieldset id="'.$id.'" onClick="types(this.id)">
        <table class="forumposts">
            <tr><td><b>'.$question.'</b></td><td>'.$bb.'</td><td>'.$date.'</td></tr>
        </table>
        </fieldset></td></tr>';}
            mysqli_stmt_close($stmt2);
            mysqli_stmt_close($stmt);
                echo'</table><script>
            function types(clicked_id){
                var c = clicked_id;
                window.location.href = "http://www.***.be/forum/index.php?subject='.$categorie.'&question="+c;  
            }
            </script>';
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信会员卡接入微信支付商户号收款
    • ¥15 如何获取烟草零售终端数据
    • ¥15 数学建模招标中位数问题
    • ¥15 phython路径名过长报错 不知道什么问题
    • ¥15 深度学习中模型转换该怎么实现
    • ¥15 HLs设计手写数字识别程序编译通不过
    • ¥15 Stata外部命令安装问题求帮助!
    • ¥15 从键盘随机输入A-H中的一串字符串,用七段数码管方法进行绘制。提交代码及运行截图。
    • ¥15 TYPCE母转母,插入认方向
    • ¥15 如何用python向钉钉机器人发送可以放大的图片?