Tutorial PHP Pemula & Mahir

Question

jika dichexbox , maka data akan muncul

Salihin Untar · Aug 31, 2012

<html>
<head>
<title>Delima pinglogistra</title>
   <link href="jquery/bigrid/bigrid.css" type="text/css" rel="Stylesheet" />
    <script language="javascript" src="jquery/jquery.js"></script>
    <script language="javascript" src="jquery/bigrid/bigrid.js"></script>
    <script language="javascript">
        $(document).ready(function(){
           $("#BIGrid1").bigrid({fixedrow:2, fixedcolumn:1, visiblerow: 4, visiblecolumn: 3});
           
           $("#BiGrid2").bigrid({fixedrow:2, fixedcolumn:1, visiblerow: 4, visiblecolumn: 2});
        });

    </script>
	
    <style>
        body, td, div
        {
        	font-family: Verdana;
        	font-size:10px;
        }
        h1
        {
        	font-family: Verdana;
        }
        .header
        {
        	text-decoration:underline;
        }
.style6 {color: #0000FF; font-weight: bold; font-size: 12; }
.style7 {font-size: 12}
    .style8 {
	color: #0000FF;
	font-weight: bold;
}
    </style>
 <link href="thickbox/thickbox.css" rel="stylesheet" type="text/css" />
 <script language="javascript" src="js/jquery_ajax.js"></script>
 <script language="javascript" src="thickbox/thickbox.js"></script>
 <script language="javascript">
function selectPegawai(nik,no_dm){
  $('input[@name=nik]').val(nik);
  $('input[@name=nm_sopir]').val(no_dm);
  tb_remove(); // hilangkan dialog thickbox
}
$(document).ready(function(){
  $('input[@name=nik]').blur( // beri event pada saat onBlur inputan kode pegawai
	function(){				
	  var vNIP = $(this).val();
	  $.get('cari_akun_sopir.php',{nik: vNIP},
		function(nm_sopir){
		  // jika response tidak kosong nilainya maka masukkan nilai ke inputan nm_sopir pegawai
		  if(nm_sopir.length > 0){ 
			$('input[@name=nm_sopir]').val(nm_sopir);	   
			$('#divAlertPegawai').text(' ').css('color','blue');
		  } else $('#divAlertPegawai').text('NIK "'+vNIP+'" Tidak Ditemukan').css('color','red');

  		}
		
	  );
	}
  );
  // beri event pada saat keyup kode pegawai agar kode yang dimasukan font-nya UPPERCASE semua (optional)
  $('input[@name=pegawai]').keyup(
	function(){
	  $(this).val(String($(this).val()).toUpperCase());
	}
  );
});


function selectPegawai2(nik,no_dm){
  $('input[@name=nik]').val(nik);
  $('input[@name=no_ums]').val(no_dm);
  tb_remove(); // hilangkan dialog thickbox
}
$(document).ready(function(){
  $('input[@name=nik]').blur( // beri event pada saat onBlur inputan kode pegawai
	function(){				
	  var vNIP = $(this).val();
	  $.get('cari_no_ums.php',{nik: vNIP},
		function(no_ums){
		  // jika response tidak kosong nilainya maka masukkan nilai ke inputan nm_sopir pegawai
		  if(no_ums.length > 0){ 
			$('input[@name=no_ums]').val(no_ums);	   
			$('#divAlertPegawai').text(' ').css('color','blue');
		  } else $('#divAlertPegawai').text('NIK "'+vNIP+'" Tidak Ditemukan').css('color','red');

  		}
		
	  );
	}
  );
  // beri event pada saat keyup kode pegawai agar kode yang dimasukan font-nya UPPERCASE semua (optional)
  $('input[@name=pegawai]').keyup(
	function(){
	  $(this).val(String($(this).val()).toUpperCase());
	}
  );
});

function selectPegawai3(nik,no_dm){
  $('input[@name=nik]').val(nik);
  $('input[@name=Ztgl_ums]').val(no_dm);
  tb_remove(); // hilangkan dialog thickbox
}
$(document).ready(function(){
  $('input[@name=nik]').blur( // beri event pada saat onBlur inputan kode pegawai
	function(){				
	  var vNIP = $(this).val();
	  $.get('cari_tgl_ums.php',{nik: vNIP},
		function(Ztgl_ums){
		  // jika response tidak kosong nilainya maka masukkan nilai ke inputan nm_sopir pegawai
		  if(Ztgl_ums.length > 0){ 
			$('input[@name=Ztgl_ums]').val(Ztgl_ums);	   
			$('#divAlertPegawai').text(' ').css('color','blue');
		  } else $('#divAlertPegawai').text('NIK "'+vNIP+'" Tidak Ditemukan').css('color','red');

  		}
		
	  );
	}
  );
  // beri event pada saat keyup kode pegawai agar kode yang dimasukan font-nya UPPERCASE semua (optional)
  $('input[@name=pegawai]').keyup(
	function(){
	  $(this).val(String($(this).val()).toUpperCase());
	}
  );
});

function selectPegawai4(nik,no_dm){
  $('input[@name=nik]').val(nik);
  $('input[@name=bon]').val(no_dm);
  tb_remove(); // hilangkan dialog thickbox
}
$(document).ready(function(){
  $('input[@name=nik]').blur( // beri event pada saat onBlur inputan kode pegawai
	function(){				
	  var vNIP = $(this).val();
	  $.get('cari_jum_ums.php',{nik: vNIP},
		function(bon){
		  // jika response tidak kosong nilainya maka masukkan nilai ke inputan nm_sopir pegawai
		  if(bon.length > 0){ 
			$('input[@name=bon]').val(bon);	   
			$('#divAlertPegawai').text(' ').css('color','blue');
		  } else $('#divAlertPegawai').text('NIK "'+vNIP+'" Tidak Ditemukan').css('color','red');

  		}
		
	  );
	}
  );
  // beri event pada saat keyup kode pegawai agar kode yang dimasukan font-nya UPPERCASE semua (optional)
  $('input[@name=pegawai]').keyup(
	function(){
	  $(this).val(String($(this).val()).toUpperCase());
	}
  );
});

 </script>	
</head>
<body>
<p>&nbsp;</p>

<div align="center">
  <?php 
			
			$query_ord=mysql_fetch_array(mysql_query("SELECT max(no_id) FROM dt_tmp_bpkk ORDER BY tgl_bpkk DESC"));
			$nomor_so=$query_ord[0]+1;
			$no_skrg = sprintf('%04s', $nomor_so);
			$format = date("ymd");

			$tahun = substr($format,0,2);
			$bulan = substr($format,2,2);
			if ($bulan == '01' or $bulan == '1'){
			    $bln = 'I';
			} elseif ($bulan == '02' or $bulan == '2'){
			    $bln = 'II';
			} elseif ($bulan == '03' or $bulan == '3'){
			    $bln = 'III';
			} elseif ($bulan == '04' or $bulan == '4'){
			    $bln = 'IV';
			} elseif ($bulan == '05' or $bulan == '5'){
			    $bln = 'V';
			} elseif ($bulan == '06' or $bulan == '6'){
			    $bln = 'VI';
			} elseif ($bulan == '07' or $bulan == '7'){
			    $bln = 'VII';
			} elseif ($bulan == '08' or $bulan == '8'){
			    $bln = 'VIII';
			} elseif ($bulan == '09' or $bulan == '9'){
			    $bln = 'IX';
			} elseif ($bulan == '10' or $bulan == '10'){
			    $bln = 'X';
			} elseif ($bulan == '11' or $bulan == '11'){
			    $bln = 'XI';
			} elseif ($bulan == '12' or $bulan == '12'){
			    $bln = 'XII';
			} else {
			    $bln = 0;
			}  
			
			if ($_SESSION['area'] = 'JAKARTA'){
			    $kd_area = 'B';
			} elseif ($_SESSION['area'] = 'SEMARANG') {
			    $kd_area = 'H';
			} elseif ($_SESSION['area'] = 'SURABAYA') {	
			    $kd_area = 'L';
			} elseif ($_SESSION['area'] = 'YOGYAKARTA') {	
			    $kd_area = 'Y';
			} else {
			    $kd_area = '';
			}
					
			$no_bpkk= $no_skrg ."$kd_area"."/BPKK/"."$bln/"."$tahun";

			
			
			$Ptanggal = date("d-m-Y");
			
		?>
</div>
<div align="center">
  

<br>  

<?
$no_id = $_GET['no_id'];	
$query9 = mysql_query("SELECT * from dt_muat_so where Xid = '$no_id' ");
$Pdata9 = mysql_fetch_assoc($query9);
if(!$Pdata9['nik'] == '' and !$Pdata9['nik_krani'] == ''){
   $PXnik = $Pdata9['nik_krani'];
   $PXnama = $Pdata9['krani'];
} else {
   $PXnik = $Pdata9['nik'];
   $PXnama = $Pdata9['nm_sopir'];
}
   
?>		

<fieldset style="width:755px">
<legend class="style8">Bukti Pengeluaran Kas Kecil </legend>
<form action="isi_bpkk.php" method="post" name="form1" target="_self" id="form1"> 
<table width="642" border=1 align="center" cellpadding=2 cellspacing=0 borderColor="black" id="BIGrid2" style="width:642;border-collapse:collapse;">   
    <tr>
      <td rowspan="2">&nbsp;</td>
      <td><div align="left">No.BPKK</div></td>
      <td><div align="left">
        <input name="no_bpkk" type="text" id="no_bpkk" style="background-color:#FFFFCC" value="<?php echo $no_bpkk;?>" size="20" maxlength="20" readonly="true" />
      </div></td>
      <td><div align="left">Tanggal BPKK </div></td>
      <td><div align="left">
        <input name="tgl_bpkk" type="text" id="tgl_bpkk" style="background-color:#FFFFCC" value="<? echo $Ptanggal;?>" size="12" maxlength="12" readonly="true">
      </div></td>
    </tr>
    
    <tr>
      <td><div align="left">Dibayarkan kepada Sopir / Krani </div></td>
      <td colspan="3"><div align="left">
        <div align="left">
          <input name="nik" type="text" id="nik" size="10" value ="<? echo $PXnik; ?>"/>
          <input name="nm_sopir" type="text" id="nm_sopir" style="background-color:#FFFFCC" value="<? echo $PXnama; ?>" size="30" maxlength="30" readonly="readonly" />
        </div>
      </div></td>
    </tr>
   
	


      
    <tr>
      <td width="30"><div align="center" class="style6">No.</div></td>
      <td width="215"><div align="center" class="style6">Keterangan</div></td>
      <td width="140"><span class="style7"></span></td>
      <td width="110"><div align="center" class="style6">Debet</div></td>
      <td width="115"><div align="center" class="style6">Kredit</div></td>
    </tr>
<?
$query8 = mysql_query("SELECT p.*,DATE_FORMAT(d.tgl_muat,'%d-%m-%Y') as Ztgl_muat,DATE_FORMAT(d.tgl_kas,'%d-%m-%Y') as Ztgl_kas,d.no_kas,d.krani,d.nik_krani,d.no_sbm,d.no_pol_skrg,d.no_ship,d.nm_sopir,d.nik,d.nm_kernet,b.sangu from dt_order_tmp p LEFT JOIN dt_cust_rute b ON b.lokasi_asal = p.lokasi_asal and b.lokasi_tujuan = p.lokasi_tujuan and b.tipe_truk = p.tipe_truk2 LEFT JOIN dt_muat_so d ON d.Xid = p.no_id where p.no_id = '$no_id' ");
$Pdata = mysql_fetch_assoc($query8);
?>			
    
    <tr>
      <td rowspan="17"><strong>1.</strong></td>
      <td><div align="left">No.SO</div></td>
      <td><div align="left"><? echo $Pdata['no_so']; ?>
        <input name="no_so" type="hidden" id="no_so" value="<? echo $Pdata['no_so']; ?>"/>
      </div></td>
      <td rowspan="17" class="gridHeader"><input name="PXid" type="hidden" id="PXid" value="<?=$Pdata["no_id"];?>"></td>
      <td rowspan="17" class="gridHeader">&nbsp;</td>
    </tr>
    <tr>
      <td><div align="left">Customer Order </div></td>
      <td><div align="left"><? echo $Pdata['nm_cust']; ?>
            <input name="nm_cust" type="hidden" id="nm_cust" value="<? echo $Pdata['nm_cust']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">No.account customer </div></td>
      <td><div align="left"><? echo $Pdata['no_akun_cust']; ?>
            <input name="no_akun_cust" type="hidden" id="no_akun_cust" value="<? echo $Pdata['no_akun_cust']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">No.Polisi</div></td>
      <td><div align="left"><? echo $Pdata['no_pol_skrg']; ?>
            <input name="no_pol_skrg" type="hidden" id="no_pol_skrg" value="<? echo $Pdata['no_pol_skrg']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">Tipe truk </div></td>
      <td><div align="left"><? echo $Pdata['tipe_truk2']; ?>
        <input name="tipe_truk2" type="hidden" id="tipe_truk2" value="<? echo $Pdata['tipe_truk2']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">Equivalent</div></td>
      <td><div align="left"><? echo $Pdata['tipe_truk3']; ?></div></td>
    </tr>
    
    <tr>
      <td><div align="left">Sopir</div></td>
      <td><div align="left"><? echo $Pdata['nm_sopir']; ?>
        <input name="nm_sopir" type="hidden" id="nm_sopir" value="<? echo $Pdata['nm_sopir']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">NIK Sopir </div></td>
      <td><div align="left"><? echo $Pdata['nik']; ?>
        <input name="nik" type="hidden" id="nik" value="<? echo $Pdata['nik']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">Kernet</div></td>
      <td><div align="left"><? echo $Pdata['nm_kernet']; ?></div></td>
    </tr>
    <?
$total = $sangu - $bon;
$tab_claim = 0.1 * $total;
?>
    <tr>
      <td><div align="left">Krani</div></td>
      <td><div align="left"><? echo $Pdata['krani']; ?></div></td>
    </tr>
    <tr>
      <td><div align="left">NIK Krani </div></td>
      <td><div align="left"><? echo $Pdata['nik_krani']; ?></div></td>
    </tr>
    <tr>
      <td><div align="left">No.Shipment</div></td>
      <td><div align="left"><? echo $Pdata['no_ship']; ?></div></td>
    </tr>
    
    <tr>
      <td><div align="left">Jenis muatan (Produk) </div></td>
      <td><div align="left"><? echo $Pdata['jns_muatan']; ?></div></td>
    </tr>
    <tr>
      <td><div align="left">Lokasi asal</div></td>
      <td><div align="left"><? echo $Pdata['lokasi_asal']; ?>
        <input name="lok_asal" type="hidden" id="lok_asal" value="<? echo $Pdata['lokasi_asal']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">Lokasi tujuan </div></td>
      <td><div align="left"><? echo $Pdata['lokasi_tujuan']; ?>
        <input name="lok_tujuan" type="hidden" id="lok_tujuan" value="<? echo $Pdata['lokasi_tujuan']; ?>"/>
      </div></td>
    </tr>
    
    <tr>
      <td><div align="left">No.SBM</div></td>
      <td><div align="left"><? echo $Pdata['no_sbm']; ?>
        <input name="no_sbm" type="hidden" id="no_sbm" value="<? echo $Pdata['no_sbm']; ?>"/>
      </div></td>
    </tr>
    <tr>
      <td><div align="left">Tgl.Muat</div></td>
      <td><div align="left"><? echo $Pdata['Ztgl_muat']; ?></div></td>
    </tr>
    
    <tr>
      <td>&nbsp;</td>
	  
 
<?
$que1 = mysql_query("SELECT * from tabel_master where nama_rekening =  'BIAYA UANG JALAN' ");
$data1 = mysql_fetch_assoc($que1);
?>		  
      <td bgcolor="#FFCCFF"><div align="left"><strong>BIAYA UANG JALAN </strong></div></td>
      <td><div align="left"><? echo $data1['kode_rekening']; ?>
          <input name="no_akun_sangu" type="hidden" id="no_akun_sangu" value="<? echo $data1['kode_rekening']; ?>"/>
      </div></td>
      <td class="gridHeader"><div align="right"><? echo number_format($Pdata['sangu']); ?>
        <input name="sangu" type="hidden" id="sangu" size="10" value="<? echo $Pdata['sangu']; ?>"/>
      </div></td>
      <td class="gridHeader">&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td bgcolor="#FFCCFF"><div align="left"><strong>HUTANG PREMI SOPIR  </strong></div></td>

<?
$que2 = mysql_query("SELECT * from tabel_master where nama_rekening =  'HUTANG PREMI SOPIR' ");
$data2 = mysql_fetch_assoc($que2);
?>	
      <td><div align="left"><? echo $data2['kode_rekening']; ?>
          <input name="no_akun_sangu2" type="hidden" id="no_akun_sangu2" value="<? echo $data2['kode_rekening']; ?>"/>
      </div></td>
      <td class="gridHeader">&nbsp;</td>
      <td class="gridHeader"><div align="right"><? echo number_format($Pdata['sangu']); ?>
        <input name="sangu2" type="hidden" id="sangu2" size="10" value="<? echo $Pdata['sangu']; ?>"/>
      </div></td>
    </tr>
  </table>
<?
$Zjudge = $_SESSION['judge'];

$strSQL = "SELECT *,DATE_FORMAT(tgl_ums,'%d-%m-%Y') as Ztgl_ums from dt_ums where cek_ums = '3' and lunas = '1' and nik = '$PXnik' and cek_bpkk = '' order by tgl_ums DESC";


$objQuery = mysql_query("SET SQL_BIG_SELECTS =1");
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");


?>  
<br>
<div align="left">
  <fieldset style="width:919px">
  <legend class="style8">BPKK</legend>
    <table width="919" border=1 align="center" cellpadding=2 cellspacing=0 borderColor="black" id="BIGrid2" style="width:910;border-collapse:collapse;">
      <tr>
        <th width="57" rowspan="2" align="center" bgcolor="#FFFFCC"><div align="center">No.</div></th>
        <th colspan="3" align="center" bgcolor="#FFFFCC"><div align="center">UMS</div></th>
        <th colspan="3" align="center" bgcolor="#FFFFCC"><div align="center">Penyelesaian  BPKK </div></th>
      </tr>
      <tr>
        <th width="124" align="center" bgcolor="#FFFFCC"><div align="center">Tanggal</div></th>
        <th width="168" align="center" bgcolor="#FFFFCC"><div align="center">No.</div></th>
        <th width="124" align="center" bgcolor="#FFFFCC"><div align="center">Jumlah</div></th>
        <th width="147" align="center" bgcolor="#FFFFCC"><div align="center">Tanggal </div></th>
        <th width="161" align="center" bgcolor="#FFFFCC"><div align="center">No.</div></th>
        <th width="76" align="center" bgcolor="#FFFFCC"><div align="center">Jumlah</div></th>
      </tr>
      <?
$i = 0;
while($rows=mysql_fetch_array($objQuery)){
$i++;

?>

      <tr>
        <td><div align="left"> <? echo $i; ?> </div></td>
        <td><div align="left"><? echo $rows['Ztgl_ums']; ?></div></td>
        <td><div align="left"><? echo $rows['no_ums']; ?></div></td>
        <td align="right"><? echo number_format($rows['bon']); ?></td>
		<td>&nbsp;</td>
		<td>&nbsp;</td>
		<td>&nbsp;</td>
	  </tr>
			<?php
			$rowset = mysql_query("select *,DATE_FORMAT(tgl_bpkk,'%d-%m-%Y') as Ztgl_bpkk from dt_bpkk where no_ums ='".$rows['no_ums']."' order by tgl_bpkk ASC");
			while($data = mysql_fetch_array($rowset)){
			?>		
<tr>			
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td align="right">&nbsp;</td>
        <td align="right">&nbsp;</td>
		<td><div align="left">
		  <div align="left"><? echo $data['Ztgl_bpkk']; ?></div>
		</div></td>
		<td><div align="left"><? echo $data['no_bpkk']; ?></div></td>
		<td align="right"><? echo number_format($data['sangu']); ?></td>
      </tr>
<?
$Zjum_sangu = $Zjum_sangu + $data['sangu'];
}	  
}
?>	  
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><div align="left">
  <div align="left"><? echo $Ptanggal; ?></div>
</div></td>
<td><div align="left">
  <div align="left"><? echo $no_bpkk; ?></div>
</div></td>	
<td align="right"><? echo number_format($Pdata['sangu']); ?></td>	  
      <tr>
        <td colspan="6"><div align="right">Total</div></td>
        <td align="right"><? echo number_format($Zjum_sangu + $Pdata['sangu']); ?></td>
      </tr>
      <tr>
        <td colspan="7" align="center"><input name="no_kwitansi" type="hidden" id="no_kwitansi" style="background-color:#FFFFCC" value="<?php echo $no_kwitansi;?>" size="15" readonly="true" />
            <input type="hidden" name="hdnCount2" value="<?=$i;?>"></td>
      </tr>
    </table>
</fieldset>
</div>	
    <br>

<div align="left">
  <fieldset style="width:755px">
  <legend class="style8">Uang Muka Sementara</legend>
  <table width="919" border=1 align="left" cellpadding=2 cellspacing=0 borderColor="black" id="BIGrid2" style="width:910;border-collapse:collapse;">
    <tr>
      <td width="62" rowspan="2"><div align="center">Cek pelunasan </div></td>
      <td width="31" rowspan="2"><div align="center">No.</div></td>
      <td colspan="2"><div align="center">UMS </div></td>
      <td colspan="2"><div align="center">Sopir</div></td>
      <td width="191" rowspan="2"><div align="center">Untuk order </div></td>
      <td colspan="2"><div align="center">Lokasi</div></td>
      <td width="67" rowspan="2"><div align="center">
        <div align="center">Jumlah</div>
      </div></td>
    </tr>
    <tr>
      <td width="78"><div align="center">Tanggal</div></td>
      <td width="90"><div align="center">No.</div></td>
      <td width="55"><div align="center">NIK</div></td>
      <td width="54"><div align="center">Nama</div></td>
      <td width="102"><div align="center">Asal</div></td>
      <td width="124"><div align="center">Tujuan</div></td>
    </tr>
    <?

$no = 1;
$sql2 = "SELECT *,DATE_FORMAT(tgl_ums,'%d-%m-%Y') as Ztgl_ums from dt_ums where nik = '$PXnik' and lunas = '1' and cek_ums = '3' and cek_bpkk = '' order by tgl_ums ASC";

$retval2 = mysql_query("SET SQL_BIG_SELECTS =1");
$retval2 = mysql_query($sql2) or die ("Error Query [".$sql2."]");

?>
    <?
$i = 0;
while($rows2=mysql_fetch_array($retval2)){
$i++;
?>
     <tr>
      <td><div align="center">
        <input type="checkbox" name="chkDel_adm[]" id="chkDel_adm<?=$i;?>" value="<?=$rows2["no_id"];?>" onClick="ClickMakeColorByTr(document.frmMain.chkDel_adm<?=$i;?>,'tr<?=$i;?>');">
        <input type="hidden" name="textfield" value="<?=$rows2["no_id"];?>">
      </div></td>
      <td><? echo $i; ?></td>
      <td><? echo $rows2['Ztgl_ums']; ?></td>
      <td><? echo $rows2['no_ums']; ?>
        <input name="no_ums" type="hidden" id="no_ums" value="<?=$rows2["no_ums"];?>"></td>
      <td colspan="-25"><? echo $rows2['nik']; ?></td>
      <td><? echo $rows2['nm_sopir']; ?></td>
      <td><? echo $rows2['nm_cust']; ?></td>
      <td><? echo $rows2['lokasi_asal']; ?></td>
      <td><? echo $rows2['lokasi_tujuan']; ?></td>
      <td><div align="right">
        <input name="bon" type="hidden" id="bon" value="<?php echo $rows2['bon'];?>" />
        <? echo number_format($rows2['bon']); ?></div></td>
    </tr>
    <?
$no++;
$Zjum_ums = $Zjum_ums + $rows2['bon'];
}
mysql_free_result($retval2); //tambahan
?>
    <tr>
      <td colspan="10"><div align="center">
        <input name="kode_bukti" type="hidden" id="kode_bukti" value="<?php echo $no_bpkk;?>" />
        <input type="hidden" name="hdnCount" value="<?=$i;?>">
        <input type="submit" onClick="return confirm('Simpan data ini dan Sisa uang jalan akan dibayarkan?')" value="Simpan" name="simpan"/>
      </div></td>
    </tr>
  </table>
  </fieldset>
</div>
</form>  


  <p>&nbsp;</p>

  <p>&nbsp;</p>
  <p><br>
    </p>
  <div align="left">
<p>Total BPKK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = <? echo number_format($Zjum_sangu + $Pdata['sangu']) ; ?> <br>
Total UMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = <? echo number_format($Zjum_ums) ; ?> <br>
Kurang / Lebih bayar = <? echo number_format($Zjum_ums - $Zjum_sangu - $Pdata['sangu'] ) ; ?>
</p>
</div>

<div style="font-size:9px">
<?
include("footer2.php");
?>
</div>
</body>
</html>

Selamat pagi mas Ellyx
Mohon bantuannya,
1.Saya ingin ( tanpa submit )
Ada 2 atau 3 checxbox , dimana jika di checklist chechboxnya , maka data dari database akan muncul.Contohnya jika checkbox 1 di checklist , maka data dari database muncul dengan data dari checklist no.1 (misalnya no_id saja).
Jika di click checkbox 1 dan 2 maka muncul data dengan no_id = 1 dan 2
2.Saya ada masalah dengan :
dengan textfield
Yang saya inginkan , jika tidak ada isinya , maka data disebelahnya menjadi hidden.
tapi jika diisi dengan angka atau huruf apapun(tidak ada kaitannya dengan database yang muncul di hidden maka data disebelahnya menjadi tampil (show)
Contoh
..Input.. Nama Alamat (show)
..tidak diinput (diisi) hidden

Terima kasih Mas,mohon pencerahannya

Silahkan login untuk menjawab!

Answer 1

0

Ellyx Christian · Sep 2, 2012 · 0 Suka · 0 Tidak Suka

tolong sampaikan masalah kamu, bagian mana yang salah/error. Kode kamu terlalu panjang sulit untuk dicek.