lperbulan

<?php
$bulan = $_POST['bulan'];
$tahun = $_POST['tahun'];
$host="localhost";
$user="root";
$pass="";
$db="rentalmobil";
$sambung=mysql_connect($host,$user,$pass);
mysql_select_db($db,$sambung);

include 'koneksi.php';
$no=1;
$query = "SELECT * FROM tjenis INNER JOIN ttype
ON ttype.idj=tjenis.idj
INNER JOIN tharga ON tharga.idt=ttype.idt
INNER JOIN tcash ON tcash.id_h=tharga.id_h
INNER JOIN tpembeli ON tpembeli.id_pem=tcash.id_pem
where month(tanggal)='$bulan' AND year(tanggal)='$tahun'
";
$exe = mysql_query($query);
$bulan1 = array("Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember",);
$hari =  array("Minggu","Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu",);
$month = intval(date('m'))-1;
$days = date('w');
$tgl_angka = date('d');
$year = date('Y');
if($bulan==01){
  $bc = 'januari';
}else
if($bulan==02){
  $bc = 'februari';
}else
if($bulan==03){
  $bc = 'maret';
}else
if($bulan==04){
  $bc = 'april';
}else
if($bulan==05){
  $bc = 'mei';
}else
if($bulan==06){
  $bc = 'juni';
}else
if($bulan==07){
  $bc = 'juli';
}else
if($bulan==08){
  $bc = 'agustus';
}else
if($bulan==09){
  $bc = 'september';
}else
if($bulan==10){
  $bc = 'oktober';
}else
if($bulan==11){
  $bc = 'november';
}else
if($bulan==12){
  $bc = 'desember';
}
else {
  $bc = '?';
}
?>
<div style="
text-transform: uppercase;
margin: auto;
width:1100px;
padding-bottom: 40px;
text-align:center;
padding-top: 40px;
">
DATA PEMBELIAN KREDIT MOTOR HONDA
</br>DEALER HONDA HAUR KUNING BANJARBARU
</br>PERIODE : BULAN <?php echo $bc ;?> TAHUN <?php echo $tahun ?>
</div>
<br>
</div>
<center>

  <table cellpadding="10px;" style="text-align: center; font-size: 12px;text-transform: uppercase;  margin-left: 115px; margin-right: 115px; " border="1px solid black"  >
    <tr style="background-color: #d1d1d1;">
      <td>KODE</td>
      <td>NAMA PEMBELI</td>
      <td>ALAMAT</td>
      <td>NO HP</td>
      <td>PEKERJAAN</td>
      <td>PENDAPATAN</td>
      <td>JENIS MOTOR</td>
      <td>TIPE MOTOR</td>
      <td>HARGA</td>
    </tr>
    <?php
    while($row = mysql_fetch_assoc($exe)){
      $a = $row['kodec'];
      $b = $row['nama'];
      $c = $row['alamat'];
      $d = $row['hp'];
      $e = $row['pekerjaan'];
      $f = $row['pendapat'];
      $g = $row['jenis'];
      $h = $row['type'];
      $i = $row['harga'];


      ?>
      <tr>
        <td><?php echo $a;?></td>
        <td width="100px"><?php echo $b;?></td>
        <td><?php echo $c;?></td>
        <td><?php echo $d;?></td>
        <td><?php echo $e;?></td>
        <td><?php echo $f;?></td>
        <td><?php echo $g;?></td>
        <td><?php echo $h;?></td>
        <td><?php echo $i;?></td>


      </tr>
      <?php
      $no++;
    }

    ?>
  </table>
</center>
<br>
<div style="
text-align: right;
font-size: 20px;
padding-right: 100px;
padding-top: 60px;

">
<?php
$bulan = array("Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember",);
$hari =  array("Minggu","Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu",);
$month = intval(date('m'))-1;
$days = date('w');
$tgl_angka = date('d');
$year = date('Y');
?>
Banjarbaru : <?php echo $hari[$days];?>  <?php echo $tgl_angka;?>-<?php echo $bulan[$month];?>-<?php echo  $year;?>
</div>