how to show submit button on datatables lastpage

how to show submit button on datatables lastpage

ariowishnuariowishnu Posts: 2Questions: 2Answers: 0

im creating simple quiz apps [ php,mysql,bootsrap 3.1.1], using datatables to show the quiz question [ 1 row per page ], below the datatables there is a button to submit the answer into mysql, currently the button is still displaying to the rest all page, for me as a begginer, the logical flow is

  • hide button on first state datatables
  • show submit button on the last page

so i need to get currently the page number which is dynamically change and store it into $variable, then use PHP Conditional Statements [ if statement ] to show the button when condition is true, last tried still no luck , or maybe any better approach to achieve this ?

below is php file for show the tables question throgh ajax into modal

<?php if(isset($_POST["quiz_id"])) { $output = ''; $connect = new mysqli("localhost","root","","admintugumulyo"); $query ="select * from bank_soal where kd_list= '".$_POST["quiz_id"]."'"; $result = $connect->query($query); $jumlah = mysqli_num_rows($result); $akhir = $jumlah; $no = 0; $output .=' <div class ="table-responsive col-md-12"> <form name="example" method="post"> <table id="example" class="table table-bordered"> <thead> <tr> <th bgcolor="navy"><font size="2" face="verdana" color="white">SOAL</font></th> </tr> </thead> <tbody>'; while($row = $result->fetch_assoc()) { $no++; $output .=' <input type="hidden" name="id[]" value="'.$row["id_soal"].'"> <input type="hidden" name="jumlah" value="'.$jumlah.'"> <tr> <td bgcolor="goldenrod"> <p><b> '.$row["soal"].' </b></p> <p> <input type="radio" id="" name="pilihan['.$row["id_soal"].']" value="a"> <label for="">'.$row["a"].'</label><br/> </p> <p> <input type="radio" id="" name="pilihan['.$row["id_soal"].']" value="b"> <label for="">'.$row["b"].'</label><br/> </p> <p> <input type="radio" id="" name="pilihan['.$row["id_soal"].']" value="c"> <label for="">'.$row["c"].'</label><br/> </p> <p> <input type="radio" id="" name="pilihan['.$row["id_soal"].']" value="d"> <label for="">'.$row["d"].'</label><br/> </p> <input type="hidden" id="" name="jawaban['.$row["id_soal"].']" value="'.$row["x"].'"> <input type="hidden" name="nosoal" value="'.$no.'"> </td> </tr>'; } $output .='</tbody></table> <input type="button" id="submit_quiz" value="submit quiz" class="btn btn-primary"/> </form></div>'; $output .=' <script> $(document).ready(function(){ $("#example").DataTable({ "bInfo":false, "lengthChange": false, searching: false, "targets": "no-sort", "bSort": false, "order": [], "pageLength": 1, }); }); $("#submit_quiz").click(function(){ var answer = confirm("Anda yakin akan menyelesaikan quiz?"); if (!answer) { //do nothing..! }else { // ajax do send job to mysql } }); } }); </script> '; echo $output; } ?>

and below is how its look on the browser

as we can see on the above picture, the button keep showing on all pages

Any recommendations would be much appreciated.


  • colincolin Posts: 12,881Questions: 0Answers: 2,198

    It might be worth considering Editor, as you need to edit a database. That would make the code to do those updates for easier,


Sign In or Register to comment.