如何在javascript中包含php，以便从数据库中检索数据，形成带有MCQ问题的论文

how to include php in javascript for retriving data from database to form a paper with MCQ questions

本文关键字：问题 数据 MCQ 数据库 包含 javascript php 检索      更新时间：2023-09-26
       <?php
            $server = "localhost";
            $username = "";
            $password = "";
            $db = "test";
            $conn = new mysqli($server,$username,$password,$db);
            if($conn->error){
                die("Error :- ". $conn->error);
            }
            $query = "select * from mcq_questions";
            $result = $conn->query($query);
      ?>
    <script type="text/javascript">
        var n = <?php echo $result->num_rows ?>;
        var i;
            for(i = 0; i < n; i++){
                var question = "";
                question = '<?php  
                            $row = $result->fetch_assoc();
                            echo $row['question'];
                    ?>';
                document.write(question);
            }
     </script>

我想打印数据库中存在的所有MCQ问题以及多个选项，但是当我这样做时，只有第一个问题被打印n次....有人能帮我一下吗?

您需要在PHP内部迭代并将字符串作为JS数组打印到您的question变量

<script type="text/javascript">
    var n = <?php echo $result->num_rows ?>;
    var i;
        for(i = 0; i < n; i++){
            var question = "";
            question = '<?php  
                while($row = $result->fetch_assoc()) {
                    echo $row['question'] . ','
                }
              ?>';
            document.write(question);
        }
 </script>

看这个解释:http://www.w3schools.com/php/php_mysql_select.asp

相关文章：