View difference between Paste ID: pnPAhGyD and sGdMBtfr

 <?php
-include 'config/konek.php';
+echo " <font color=#1d58a7>
-//sumber http://arydipa.blogspot.com/2011/04/buat-grafik-sederhana-dengan-php.html
+    Filter tanggal ";
-$query = "select count(*) as Berhasil from plan2 where Terlaksana = 'Berhasil'";
+echo "<form method=POST action=?module=graph>
     Cari Tanggal Mulai : <input type='text' name='tanggal' size='10'>
      Cari Tanggal Akhir : <input type='text' name='tanggal_2' size='10'>
      <input type='submit' name='cari' value='Cari'>
      </form>";
 
-$query = "select count(*) as Gagal from plan2 where Terlaksana != 'Berhasil'";
+
 
 mysql_query ("select * from plan where TGL_MULAI between   '$_POST[tanggal]' and '$_POST[tanggal_2]' ");
 $query = "select count(*) as Berhasil from plan2 where Terlaksana = 'Berhasil' and TGL_MULAI between   '$_POST[tanggal]' and '$_POST[tanggal_2]'";
 $hasil = mysql_query($query);
 $data  = mysql_fetch_array($hasil);
 $Berhasil= $data['Berhasil'];
 
-// menghitung presentase berhasil dan perempuan
+
 $query = "select count(*) as Berhasil from plan2 where Terlaksana != 'Berhasil' and TGL_MULAI between   '$_POST[tanggal]' and '$_POST[tanggal_2]'";
 $hasil = mysql_query($query);
 $data  = mysql_fetch_array($hasil);
 $Gagal = $data['Gagal'];
 
 // menghitung total training
 $total = $Berhasil+ $Gagal;
 
 // menghitung presentase berhasil dan gagal
- <font color=#1d58a7>
+if ($total == 0) {
     echo "Tidak ada training yang terjadi";
 }else {
 $keberhasilan = $Berhasil/$total * 100;
 $kegagalan = $Gagal/$total * 100;
 }
 // menentukan panjang grafik batang berdasarkan prosentase
 $panjangberhasil = $keberhasilan * 30 / 100;
 $panjanggagal = $kegagalan * 30 / 100;
 
 ?>
 
 <h3>Rekapitulasi Hasil Training <br> Berdasarkan Berhasilnya Training</h3>
 
 <p><b>Berhasil</b> (Jumlah: <?php echo "$Berhasil Berhasil"; ?> | <?php echo "Persentase : $keberhasilan"; ?>%) <div style="height: 20px; width: <?php echo $panjangberhasil; ?>%; background-color: #009900;" title="Berhasil (Jumlah: <?php sprintf("%01.1f",($Berhasil)); ?> | <?php sprintf("%01.1f",($keberhasilan)); ?>%)"></div></p>
 
 <p><b>Gagal</b> (Jumlah: <?php echo "$Gagal Gagal"; ?> | <?php echo "Persentase : $kegagalan"; ?>%) <div style="height: 20px; width: <?php echo $panjanggagal; ?>%; background-color: RED;" title="Gagal (Jumlah: <?php $Gagal; ?> | <?php sprintf("%01.1f",($kegagalan)); ?>%)"></div></p>
  </font>
 
 <?php
 echo "<b> <h3> Jumlah Training saat ini adalah : $total Training</h3></b>";
 ?>