<?php include  "database.php";?> 
             <?php session_start();?> 
             <?php

            // Getting total rows there in table
            $query="SELECT * FROM questions";
            $results=$mysqli->query($query) or die($mysqli->error.__LINE__);
            $total=$results->num_rows;
            $row=$results->fetch_assoc();
            //Reading the rows next by next and vice versa

            $offset=$row["question_number"];
            // when button next is clicked it will fetch the next row
            if(isset($_POST["NEXT"])){
                $offset++;
            }
            // if previous is clicked the previous row will be displayed
            elseif(isset($_POST["Previous"])){
                if($offset>1){
                    $offset--;
                }
            }
            $sql="select * from questions where question_number=$offset";
            $result=$mysqli->query($sql);

            if($result->num_rows > 0){

                while($row=$result->fetch_assoc()){

                    ?> <!DOCTYPE html> 
                    <html> 
                    <head> 
                    <meta charset="utf-8"> 
                    <title> PHP Quizzer</title> 
                    <link rel="stylesheet" href="css/style.css" type="text/css"/> 
                    <link rel="stylesheet" href="style.css" type="text/css"/> 
                    </head>
                    <body>
                    <header> 
                    <div class="container">
                    <h1>PHP Quizzer </h1> 
                    </div> 
                    </header> 
                    <main> 
                    <div class="container"> 
                    <div class="current">Question <?php echo $row["question_number"];?> of <?php echo $total;?> 
                    </div> 
                    <p class="question"> 
                    <?php echo $row["question_number"].".".$row['text'];?> </p>
                    <form method="post" action="question2.php"> 
                    <ul class="choices"> 
                    <li><input name="choice" type="radio" value="A"/><?php echo $row['A'];?> 
                    <li><input name="choice" type="radio" value="B"/><?php echo $row['B'];?> 
                    <li><input name="choice" type="radio" value="C"/><?php echo $row['C'];?> 
                    <li><input name="choice" type="radio" value="D"/><?php echo $row['D'];?> 
                    </ul>
                    <input type="submit" value="submit"/> 
                    <input type="submit" value="Previous" name="Previous"/> 
                    <input type="submit" value="NEXT" name="NEXT"/> 
                    <input type="hidden"  name="offset" value=""/> 
                    </form> 
                    </div> 
                    </main> 
                    <footer> 
                    <div class="container">
                            Copyright ©2020, PHP Quizzer.
                        </div> </footer> </body> </html> <?php
                }
            }
            $mysqli->close();
            ?>
  // Get all rows that exist in table
    $query="SELECT * FROM questions";
    $results=$mysqli->query($query) or die($mysqli->error.__LINE__);
    $total=$results->num_rows;

    // If one or more rows exist
   if($result->num_rows > 0){

           // Loop through each row of questions, storing it in the $row variable for each loop iteration
            while($row=$result->fetch_assoc()){

            // Print out the question
            echo $row["question_number"].".".$row['text'];
            }

    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.