Skip welcome & menu and move to editor
Welcome to JS Bin
File
Add library
Share
Login or Register
Blog
Help
Load cached copy from
  • Run with JS
  • Save
  • Share
  • …
 
<!DOCTYPE html>
<html>
<head>
    <title></title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css">
    <script type="text/javascript">
            $(document).ready(function() {
                $('#tableViewKuota').DataTable( {
                    dom: 'Bfrtip',
                    buttons: [
                        'copy', 'csv', 'excel', 'pdf', 'print'
                    ]
                } );
            } );
    </script>
    <style type="text/css">
    #tableViewKuota th{
            white-space: nowrap;
        }
    #tableViewKuota td{
        white-space: nowrap;
        text-align: center;
    }
    </style>
</head>
<body>
    <table  class="" id="tableViewKuota" width="100%" ">
          <thead>
            <tr>
              
            <th>Universitas</th>  
            <th>Stase</th>  
            <th>Sept Tgl 1-7</th>
            <th>Sept Tgl 8-14</th>
            <th>Sept Tgl 15-21</th>
            <th>Sept Tgl 22-28</th>
            <th>Okt Tgl 29-5</th>
            <th>Okt Tgl 6-12</th>
            <th>Okt Tgl 13-19</th>
            <th>Okt Tgl 20-26</th>
            <th>Nov Tgl 27-2</th>
            <th>Nov Tgl 3-9</th>
            <th>Nov Tgl 10-16</th>
            <th>Nov Tgl 17-23</th>
            <th>Nov Tgl 24-30</th>
            <th>Des Tgl 1-7</th>
            <th>Des Tgl 8-14</th>
            <th>Des Tgl 15-21</th>
            <th>Des Tgl 22-28</th>
            <th>Jan Tgl 29-4</th>
            <th>Jan Tgl 5-11</th>
            <th>Jan Tgl 12-18</th>
            <th>Jan Tgl 19-25</th>
            <th>Feb Tgl 26-1</th>
            <th>Feb Tgl 2-8</th>
            <th>Feb Tgl 9-15</th>
            <th>Feb Tgl 16-22</th>
            <th>Feb Tgl 23-29</th>
            <th>Mar Tgl 1-7</th>
            <th>Mar Tgl 8-14</th>
            <th>Mar Tgl 15-21</th>
            <th>Mar Tgl 22-28</th>
            <th>Apr Tgl 29-4</th>
            <th>Apr Tgl 5-11</th>
            <th>Apr Tgl 12-18</th>
            <th>Apr Tgl 19-25</th>
            <th>Mei Tgl 26-2</th>
            <th>Mei Tgl 3-9</th>
            <th>Mei Tgl 10-16</th>
            <th>Mei Tgl 17-23</th>
            <th>Mei Tgl 24-30</th>
            <th>Jun Tgl 31-6</th>
            <th>Jun Tgl 7-13</th>
            <th>Jun Tgl 14-20</th>
            <th>Jun Tgl 21-27</th>
            <th>Jul Tgl 28-4</th>
            <th>Jul Tgl 5-11</th>
            <th>Jul Tgl 12-18</th>
            <th>Jul Tgl 19-25</th>
            <th>Agt Tgl 26-1</th>
            <th>Agt Tgl 2-8</th>
            <th>Agt Tgl 9-15</th>
            <th>Agt Tgl 16-22</th>
            <th>Agt Tgl 23-29</th>
            </tr>
          </thead>
                    <tfoot>
                            <?php 
                    include("Db_kuota.php");    
                    $anak=mysqli_query($dbkuota,"SELECT SUM(Sept1),SUM(Sept2),SUM(Sept3),SUM(Sept4), SUM(Okt1),SUM(Okt2),SUM(Okt3),SUM(Okt4), SUM(Nov1),SUM(Nov2),SUM(Nov3),SUM(Nov4),SUM(Nov5), SUM(Des1),SUM(Des2),SUM(Des3),SUM(Des4), SUM(Jan1),SUM(Jan2),SUM(Jan3),SUM(Jan4), SUM(Feb1),SUM(Feb2),SUM(Feb3),SUM(Feb4),SUM(Feb5), SUM(Mar1),SUM(Mar2),SUM(Mar3),SUM(Mar4), SUM(Apr1),SUM(Apr2),SUM(Apr3),SUM(Apr4), SUM(Mei1),SUM(Mei2),SUM(Mei3),SUM(Mei4),SUM(Mei5), SUM(Jun1),SUM(Jun2),SUM(Jun3),SUM(Jun4), SUM(Jul1),SUM(Jul2),SUM(Jul3),SUM(Jul4), SUM(Agt1),SUM(Agt2),SUM(Agt3),SUM(Agt4),SUM(Agt5) FROM book_kuota WHERE Id_Stase IN ('1')");//here run the sql query.  
  
        while($row=mysqli_fetch_array($anak)){
            $JumSept1=$row[0];  
            $JumSept2=$row[1];  
            $JumSept3=$row[2]; 
            $JumSept4=$row[3];
            $JumOkt1=$row[4];
            $JumOkt2=$row[5];
            $JumOkt3=$row[6];
            $JumOkt4=$row[7];
            $JumNov1=$row[8];
            $JumNov2=$row[9];
            $JumNov3=$row[10];
            $JumNov4=$row[11];
            $JumNov5=$row[12];
            $JumDes1=$row[13];
            $JumDes2=$row[14];
            $JumDes3=$row[15];
            $JumDes4=$row[16];
            $JumJan1=$row[17];
            $JumJan2=$row[18];
            $JumJan3=$row[19];
            $JumJan4=$row[20];
            $JumFeb1=$row[21];
            $JumFeb2=$row[22];
            $JumFeb3=$row[23];
            $JumFeb4=$row[24];
            $JumFeb5=$row[25];
            $JumMar1=$row[26];
            $JumMar2=$row[27];
            $JumMar3=$row[28];
            $JumMar4=$row[29];
            $JumApr1=$row[30];
            $JumApr2=$row[31];
            $JumApr3=$row[32];
            $JumApr4=$row[33];
            $JumMei1=$row[34];
            $JumMei2=$row[35];
            $JumMei3=$row[36];
            $JumMei4=$row[37];
            $JumMei5=$row[38];
            $JumJun1=$row[39];
            $JumJun2=$row[40];
            $JumJun3=$row[41];
            $JumJun4=$row[42];
            $JumJul1=$row[43];
            $JumJul2=$row[44];
            $JumJul3=$row[45];
            $JumJul4=$row[46];
            $JumAgt1=$row[47];
            $JumAgt2=$row[48];
            $JumAgt3=$row[49];
            $JumAgt4=$row[50];
            $JumAgt5=$row[51];
            
        }//while look to fetch the result and store in a array $row.  
               ?>
              <tr>
                  <td colspan="2">Jumlah</td>
                  <td><?php echo $JumSept1; ?></td>
                  <td><?php echo $JumSept2; ?></td>
                  <td><?php echo $JumSept3; ?></td>
                  <td><?php echo $JumSept4; ?></td>
                  <td><?php echo $JumOkt1; ?></td>
                  <td><?php echo $JumOkt2; ?></td>
                  <td><?php echo $JumOkt3; ?></td>
                  <td><?php echo $JumOkt4; ?></td>
                  <td><?php echo $JumNov1; ?></td>
                  <td><?php echo $JumNov2; ?></td>
                  <td><?php echo $JumNov3; ?></td>
                  <td><?php echo $JumNov4; ?></td>
                  <td><?php echo $JumNov5; ?></td>
                  <td><?php echo $JumDes1; ?></td>
                  <td><?php echo $JumDes2; ?></td>
                  <td><?php echo $JumDes3; ?></td>
                  <td><?php echo $JumDes4; ?></td>
                  <td><?php echo $JumJan1; ?></td>
                  <td><?php echo $JumJan2; ?></td>
                  <td><?php echo $JumJan3; ?></td>
                  <td><?php echo $JumJan4; ?></td>
                  <td><?php echo $JumFeb1; ?></td>
                  <td><?php echo $JumFeb2; ?></td>
                  <td><?php echo $JumFeb3; ?></td>
                  <td><?php echo $JumFeb4; ?></td>
                  <td><?php echo $JumFeb5; ?></td>
                  <td><?php echo $JumMar1; ?></td>
                  <td><?php echo $JumMar2; ?></td>
                  <td><?php echo $JumMar3; ?></td>
                  <td><?php echo $JumMar4; ?></td>
                  <td><?php echo $JumApr1; ?></td>
                  <td><?php echo $JumApr2; ?></td>
                  <td><?php echo $JumApr3; ?></td>
                  <td><?php echo $JumApr4; ?></td>
                  <td><?php echo $JumMei1; ?></td>
                  <td><?php echo $JumMei2; ?></td>
                  <td><?php echo $JumMei3; ?></td>
                  <td><?php echo $JumMei4; ?></td>
                  <td><?php echo $JumMei5; ?></td>
                  <td><?php echo $JumJun1; ?></td>
                  <td><?php echo $JumJun2; ?></td>
                  <td><?php echo $JumJun3; ?></td>
                  <td><?php echo $JumJun4; ?></td>
                  <td><?php echo $JumJul1; ?></td>
                  <td><?php echo $JumJul2; ?></td>
                  <td><?php echo $JumJul3; ?></td>
                  <td><?php echo $JumJul4; ?></td>
                  <td><?php echo $JumAgt1; ?></td>
                  <td><?php echo $JumAgt2; ?></td>
                  <td><?php echo $JumAgt3; ?></td>
                  <td><?php echo $JumAgt4; ?></td>
                  <td><?php echo $JumAgt5; ?></td>
              </tr>
          </tfoot>
          <tbody>
            <?php  
        include("Db_kuota.php");    
        $run=mysqli_query($dbkuota,"SELECT Nama_Univ, Nama_Stase, 
          Sept1, Sept2, Sept3, Sept4, 
          Okt1, Okt2, Okt3, Okt4, 
          Nov1, Nov2, Nov3, Nov4, Nov5, 
          Des1, Des2, Des3, Des4, 
          Jan1, Jan2, Jan3, Jan4, 
          Feb1, Feb2, Feb3, Feb4, Feb5, 
          Mar1, Mar2, Mar3, Mar4, 
          Apr1, Apr2, Apr3, Apr4, 
          Mei1, Mei2, Mei3, Mei4, Mei5, 
          Jun1, Jun2, Jun3, Jun4, 
          Jul1, Jul2, Jul3, Jul4, 
          Agt1, Agt2, Agt3, Agt4, Agt5
            FROM book_kuota 
            INNER JOIN universitas ON book_kuota.Id_Univ = universitas.Id_Univ 
            INNER JOIN stase ON book_kuota.Id_Stase = stase.Id_Stase 
            WHERE book_kuota.Id_Stase='1'");//here run the sql query.  
  
        while($row=mysqli_fetch_array($run))//while look to fetch the result and store in a array $row.  
        {  
  
            $Universitas=$row[0];
            $Stase=$row[1]; 
            $Sept1=$row[2];  
            $Sept2=$row[3];  
            $Sept3=$row[4]; 
            $Sept4=$row[5];
            $Okt1=$row[6];
            $Okt2=$row[7];
            $Okt3=$row[8];
            $Okt4=$row[9];
            $Nov1=$row[10];
            $Nov2=$row[11];
            $Nov3=$row[12];
            $Nov4=$row[13];
            $Nov5=$row[14];
            $Des1=$row[15];
            $Des2=$row[16];
            $Des3=$row[17];
            $Des4=$row[18];
            $Jan1=$row[19];
            $Jan2=$row[20];
            $Jan3=$row[21];
            $Jan4=$row[22];
            $Feb1=$row[23];
            $Feb2=$row[24];
            $Feb3=$row[25];
            $Feb4=$row[26];
            $Feb5=$row[27];
            $Mar1=$row[28];
            $Mar2=$row[29];
            $Mar3=$row[30];
            $Mar4=$row[31];
            $Apr1=$row[32];
            $Apr2=$row[33];
            $Apr3=$row[34];
            $Apr4=$row[35];
            $Mei1=$row[36];
            $Mei2=$row[37];
            $Mei3=$row[38];
            $Mei4=$row[39];
            $Mei5=$row[40];
            $Jun1=$row[41];
            $Jun2=$row[42];
            $Jun3=$row[43];
            $Jun4=$row[44];
            $Jul1=$row[45];
            $Jul2=$row[46];
            $Jul3=$row[47];
            $Jul4=$row[48];
            $Agt1=$row[49];
            $Agt2=$row[50];
            $Agt3=$row[51];
            $Agt4=$row[52];
            $Agt5=$row[53];  
        ?>  
  
        <tr>  
<!--here showing results in the table -->  
​
            <td><?php echo $Universitas; ?></td>  
            <td><?php echo $Stase; ?></td>  
            <td><?php echo $Sept1; ?></td>  
            <td><?php echo $Sept2; ?></td>  
            <td><?php echo $Sept3; ?></td> 
            <td><?php echo $Sept4; ?></td>
            <td><?php echo $Okt1; ?></td>
            <td><?php echo $Okt2; ?></td>
            <td><?php echo $Okt3; ?></td>
            <td><?php echo $Okt4; ?></td>
            <td><?php echo $Nov1; ?></td>
            <td><?php echo $Nov2; ?></td>
            <td><?php echo $Nov3; ?></td>
            <td><?php echo $Nov4; ?></td>
            <td><?php echo $Nov5; ?></td>
            <td><?php echo $Des1; ?></td>
            <td><?php echo $Des2; ?></td>
            <td><?php echo $Des3; ?></td>
            <td><?php echo $Des4; ?></td>
            <td><?php echo $Jan1; ?></td>
            <td><?php echo $Jan2; ?></td>
            <td><?php echo $Jan3; ?></td>
            <td><?php echo $Jan4; ?></td>
            <td><?php echo $Feb1; ?></td>
            <td><?php echo $Feb2; ?></td>
            <td><?php echo $Feb3; ?></td>
            <td><?php echo $Feb4; ?></td>
            <td><?php echo $Feb5; ?></td>
            <td><?php echo $Mar1; ?></td>
            <td><?php echo $Mar2; ?></td>
            <td><?php echo $Mar3; ?></td>
            <td><?php echo $Mar4; ?></td>
            <td><?php echo $Apr1; ?></td>
            <td><?php echo $Apr2; ?></td>
            <td><?php echo $Apr3; ?></td>
            <td><?php echo $Apr4; ?></td>
            <td><?php echo $Mei1; ?></td>
            <td><?php echo $Mei2; ?></td>
            <td><?php echo $Mei3; ?></td>
            <td><?php echo $Mei4; ?></td>
            <td><?php echo $Mei5; ?></td>
            <td><?php echo $Jun1; ?></td>
            <td><?php echo $Jun2; ?></td>
            <td><?php echo $Jun3; ?></td>
            <td><?php echo $Jun4; ?></td>
            <td><?php echo $Jul1; ?></td>
            <td><?php echo $Jul2; ?></td>
            <td><?php echo $Jul3; ?></td>
            <td><?php echo $Jul4; ?></td>
            <td><?php echo $Agt1; ?></td>
            <td><?php echo $Agt2; ?></td>
            <td><?php echo $Agt3; ?></td>
            <td><?php echo $Agt4; ?></td>
            <td><?php echo $Agt5; ?></td>
        </tr> 
          </tbody>
              <?php } ?>   
​
        </table>
​
</body>
</html>
 
​
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers