- Beranda
- Website, Webmaster, Webdeveloper
[HELP] Menampilkan data lapora bulanan [php]
...
TS
mallarangeng
[HELP] Menampilkan data lapora bulanan [php]
Gan kok gak work ya 
Kalo pun work hasilnya gank sesuai, ane ingin menampilkan data laporan berdasarkan bulan & tahun, Pencerahanya gan,
finance_view_select.php
finance_view_report.php
Kalo pun work hasilnya gank sesuai, ane ingin menampilkan data laporan berdasarkan bulan & tahun, Pencerahanya gan, finance_view_select.php
PHP Code:
<?php
$thn=date("Y");
echo "<h2 align=center>Report finance in month</h2>
<form name=F1 method=post action=?page=finance_view_report>
<p align=center>Month and yeaars<br><br>
<select name=bln>
<option value=01>Januari</option>
<option value=02>Febbruari</option>
<option value=03>Maret</option>
<option value=04>April</option>
<option value=05>Mei</option>
<option value=06>Juni</option>
<option value=07>Julo</option>
<option value=08>Agustus</option>
<option value=09>September</option>
<option value=10>Oktober</option>
<option value=11>Nopember</option>
<option value=12>Desember</option>
</select> -
<input type=text name=thn size=4 maxlength=4 value=$thn>
<br><br>
<input type=submit class='btn btn-primary' name=simpan value=" OK "></form>
</p>
";
?>
finance_view_report.php
PHP Code:
<html>
<head>
<title>Report</title>
</head>
<body>
<table width="100%" class="table table-hover" border="0" cellspacing="0" cellpadding="0">
<tread>
<tr>
<th width="3%" align="left">No</th>
<th width="6%" align="left">Date</th>
<th width="7%" align="left">Bon Numb</th>
<th width="10%" align="left">Employ</th>
<th width="7%" align="left">Contrak Id</th>
<th width="43%" align="left">Description</th>
<th width="6%" align="left">Debit</th>
<th width="7%" align="left">Kredit</th>
</tr>
</tread>
<?php
include('config/koneksi.php');
$blnthn=$_POST[thn]."-".$_POST[bln];
$tampil=mysql_query("select finance.* from finance where tanggal < '$blnthn-01' order by tanggal asc");
$data= mysql_query($tampil);
while($data = mysql_fetch_array($tampil)){
?>
<tr>
<td><?php echo $no=$no+1;?></td>
<td><?php echo $data['tanggal'];?></td>
<td><?php echo $data['no_bon'];?></td>
<td><?php echo $data['nama_lengkap'];?></td>
<td><?php echo $data['kontrak_id'];?></td>
<td><?php echo $data['keterangan'];?></td>
<td class="text-right"><?php echo $debit; ?></td>
<td class="text-right"><?php echo $kredit; ?></td>
</tr>
<?php
}
?>
</table>
<hr>
</body>
</html>
0
2.2K
4
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
23.5KThread•5.6KAnggota
Urutkan
Terlama
Komentar yang asik ya