cara menampilkan data lewat 2 combobox dengan tabel yang berbeda

adit · Dec 31, 2014
mohon pencerahannya pak..
dalam 1 form ada 2 combobox, combobox 1 menampilkan kartu kredit dan no.credit ke textboxt yang akn digunakan sedangkan combobox ke2 tempat dia malakukan transaksi gesek kartu untuk combo 1 sdah bsa tampil tpi untuk yg combo ke2 tdk bsa apakah scrip ini untuk 1 form sja pak mohon dngan sangat bntuannya..
 <?php    
$result = mysql_query("select * from edc");    
$jsArray = "var prdName = new Array();\n";    
echo '<select name="prdId" onchange="changeValue(this.value)">';    
echo '<option>--Silahkan Pilih --</option>';    
while ($row = mysql_fetch_array($result)) {    
    echo '<option value="' . $row['id_edc'] . '">' . $row['nama_edc'] . '</option>';    
    $jsArray .= "prdName['" . $row['id_edc'] . "'] = {name:'" . addslashes($row['nama_edc']) . "',desc:'".addslashes($row['bankRT_trans'])."'};\n";    
}    
echo '</select>';    
?>
                    <input type="hidden" name="nama_edc" id="nama_edc" />
                    <input type="hidden" latestvalue="0" onChange="menghitungTransaksi(&#39;trans&#39;);" id="bankRT_trans" name="bankRT_trans" maxlength="5" size="5" onblur="tCheckNumberPersen(this);">
                    <script type="text/javascript">    
<?php echo $jsArray; ?>  
function changeValue(id){  
document.getElementById('nama_edc').value = prdName[id].name;  
document.getElementById('bankRT_trans').value = prdName[id].desc;  
};  
                  </script>
 
 
<?php
$koneksi=mysql_connect("localhost","root","") or die (mysql_error());
$pilih_db=mysql_select_db("dbgestun") or die (mysql_error());
$perintah="SELECT * FROM krt_kredit";
$jalankan_perintah=mysql_query($perintah) or die (mysql_error());
 
$result = mysql_query("select * from krt_kredit");
$jsArray = "var card_type = new Array();\n";
echo '<select name="card_type" onchange="document.getElementById(\'no_credit\').value = card_type[this.value]">';
echo '<option>-------</option>';
while ($row = mysql_fetch_array($result)) {
    echo '<option value="' . $row['card_type'] . '">' . $row['card_type'] . '</option>';
    $jsArray .= "card_type['" . $row['card_type'] . "'] = '" . addslashes($row['no_credit']) . "';\n";
}
echo '</select>';
?>
Bankrate : <input type="text" name="no_credit" id="no_credit"/>  
<script type="text/javascript">
<?php echo $jsArray; ?>
</script>

Lihat semua 2 jawaban

Silahkan login untuk menjawab!

Simpan data ke database dari data berupa checkbox

Dwi Apriyantono · Dec 18, 2014
gimana ya cara simpan data nya yang diquery dari satu tabel, kemudian datanya dipilih dengan checkbox kemudian disimpan ke tabel lainnya?

saya coba buat seperti ini :


<form action="prosestransfer.php" methode="post">
        <table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered datatables" id="example">
            <thead>
                <tr>
                    <th width="5%"><span><input type="checkbox" id="select-all"></span></th>
                    <th width="250px">Nama Pelanggan</th>
                    <th>Kota</th>
                    <th>Nomor faktur</th>
                    <th>Total nominal</th>
                </tr>
            </thead>
 
            <tbody class="selects">
                <?php
                $qry = "select a.* from mst_inv a order by a.inv_id;";
                $hasil = mysql_query($qry);
                $jumlah=$count;
                while ($data = mysql_fetch_array($hasil)) {
                    $inv_id = [0];
                    $inv_cust_code = [1];
                    $inv_cust_name = [2];
                    $inv_cust_address = [3];
                    $inv_number = [4];
                    $inv_receivable = [5];
 
                    echo "<tr class=\"odd gradeX\">
                    <td>
                        <input type=\"checkbox\" name=\"item\" id=\"item-$inv_id value=\"$inv_id\" >
                        <input type=\"hidden\" name=\"inv_cust_code[$inv_id]\" value=\"$inv_cust_code\" >
                        <input type=\"hidden\" name=\"inv_cust_name[$inv_id]\" value=\"$inv_cust_name\" >
                        <input type=\"hidden\" name=\"inv_cust_address[$inv_id]\" value=\"$inv_cust_address\" >
                        <input type=\"hidden\" name=\"inv_number[$inv_id]\" value=\"$inv_number\" >
                        <input type=\"hidden\" name=\"inv_receivable[$inv_id]\" value=\"$inv_receivable\" >
                            
                    </td>
                    <td> $data[inv_cust_name] </td>
                    <td> $data[inv_cust_city] </td>
                    <td> $data[inv_number]</td>
                    <td> $data[inv_value]</td>
 
                </tr>";
                }
                ?>
            </tbody>
 
        </table>
 
        <div class="panel-footer">
            <div class="pull-right">
                <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                <button type="submit" class="btn btn-success">Save changes</button>
                <input type="hidden" id="aksi" value="transferfaktur"
            </div>
        </div>
</div>
</form>
<?php
include_once 'conf/db.php';
 
session_start();
$aksi = (isset($_POST["aksi"])) ? $_POST["aksi"] : null;
 
 
//============= begin action for user =======================
if ($aksi == 'transferfaktur') {
 
        foreach($_POST['item']as $inv_id){
            //$insert=mysql_query("INSERT INTO temp_inv (inv_id, inv_cust_code, inv_cust_name, inv_cust_address, inv_number, inv_receivable) VALUES ('$inv_id', '$inv_cust_code', '$inv_cust_name', '$inv_cust_address','$inv_number','$inv_receivable')")or die(mysql_error());
            $insert=mysql_query("INSERT INTO temp_inv (inv_id, inv_cust_code, inv_cust_name, inv_cust_address, inv_number, inv_receivable) VALUES ('$inv_id', '".$_POST['inv_cust_code']['$inv_id']."','".$_POST['inv_cust_name']['$inv_id']."','".$_POST['inv_cust_address']['$inv_id']."','".$_POST['inv_number']['$inv_id']."','".$_POST['inv_receivable']['$inv_id']."')")
                    or die(mysql_error());
           
            if (!insert){
                die('Error');
            }else{
                echo $insert;
            }
        }
   
}
 
?>

hasilnya nihil, data ndak ada yg masuk ke db dan kalau di echo tidak muncul apa2... hanya di address bar browser muncul panjang :
prosestransfer.php?example_length=10&inv_cust_code%5BArray%5D=Array&inv_cust_name%5BArray%5D=Array&inv_cust_address%5BArray%5D=Array&inv_number%5BArray%5D=Array&inv_receivable%5BArray%5D=Array&inv_cust_code%5BArray%5D=Array&inv_cust_name%5BArray%5D=Array&inv_cust_address%5BArray%5D=Array&inv_number%5BArray%5D=Array&inv_receivable%5BArray%5D=Array&inv_cust_code%5BArray%5D=Array&inv_cust_name%5BArray%5D=Array&inv_cust_address%5BArray%5D=Array&inv_number%5BArray%5D=Array&inv_receivable%5BArray%5D=Array&item=on&inv_cust_code%5BArray%5D=Array&inv_cust_name%5BArray%5D=Array&inv_cust_address%5BArray%5D=Array&inv_number%5BArray%5D=Array&inv_receivable%5BArray%5D=Array&inv_cust_code%5BArray%5D=Array&inv_cust_name%5BArray%5D=Array&inv_cust_address%5BArray%5D=Array&inv_number%5BArray%5D=Array&inv_receivable%5BArray%5D=Array

Lihat semua 1 jawaban

Silahkan login untuk menjawab!

Validasi login

Fitra Mohammad Binedo · Dec 16, 2014
Gan ane mau tanya nih soal validasi login di php, klo validasi nya berdasarkan IP Address gmn caranya gan? mohon pencerahannya gan, matur nuyun:)

Lihat semua 1 jawaban

Silahkan login untuk menjawab!

gimana cara menampilkan lebih dari satu data,,berikut skrip yang udah saya buat tapi yang muncul hanya satu

birul · Dec 9, 2014 
<?php
	include "connect.php";
 
	$jsArray1 = "var idxspp = new Array();\n";
	$jsArray2 = "var idxdpp = new Array();\n";
	echo "<table width='60%' border='1'>
			<tr><td>Nama </td><td>SPP</td><td>DPP</td></tr>
			<tr>
				<td><select name='uv' id='uv' onchange='document.getElementById(\"spp\").value = idxspp[this.value]'>
					<option value='0'>Pilih </option>";
					$tampil=mysql_query("SELECT * FROM coba ORDER BY nama");
					while($r=mysql_fetch_array($tampil)){
					echo "<option value=$r[id_coba]>$r[nama]</option>";
					$jsArray1 .= "idxspp['" . $r[id_coba] . "'] = '" . addslashes($r['SPP']) . "' ;\n";
					$jsArray2 .= "idxdpp['" . $r[id_coba] . "'] = '" . addslashes($r['DPP']) . "' ;\n";
 
            }
    echo "  		</select>
				</td>
				<td><input type=text name='spp' id='spp'></td>
				<td><input type=text name='dpp' id='dpp'></td>
			</tr>";
	echo "	
			</table>";
	?>
	<script type="text/javascript"> 
	<?php echo "$jsArray1 $jsArray2 ";?>
 
    </script>

Lihat semua 1 jawaban

Silahkan login untuk menjawab!

mas mau tanya cara simpan kombinasi combobox dengan cekbox trs di kasih dengan textbox gmna ya,,

andi setiyawan · Dec 6, 2014
mas mau tanya cara simpan kombinasi combobox dengan cekbox trs di kasih dengan textbox gmna ya,,
<?php //===========CODE DELETE RECORD ================
require_once ('Pakar/otentifikasi_pakar.php');
					require_once ('inc/koneksi.php');
					$act=$_GET['act'];
	$KD_PENYAKIT = $_GET['KD_PENYAKIT'];
	if ($act=="relasi"){				
				
?>					
<script type="text/javascript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<div class="text_area" align="justify">
  <div class="art-PostContent"><div class="art-BlockHeader">
                <div class="l"></div>
                <div class="r"></div>
                    <div class="art-header-tag-icon">
                        <div class="t">
                          <div align="center">Pengolahan Data Relasi</div>
                        </div>
                    </div>
                    </div>
</div>     
<br />
<form method="post" action="?page=9&act=tampil">
<table width="100%" align="center" cellpadding="5">
 
  <tr>
    <td>
     <select name="CmbPenyakit" id="jumpMenu" class="cmblog">
		<option value=""> [ Daftar Penyakit ]
		</option>
      
        <?php
$query="SELECT * from PENYAKIT order by KD_PENYAKIT";
	$parsesql = oci_parse($conn, $query);
 	oci_execute($parsesql) or die(oci_error());
		while ($datap=oci_fetch_array($parsesql)) {
	// Untuk Buat Nilai Terpilih
	if ($datap['KD_PENYAKIT']==$KD_PENYAKIT) {
		$cek = "selected";
	}
	else {
		$cek ="";
	}
					echo "<option value='$datap[KD_PENYAKIT]'$cek>
		$datap[PENYAKIT]</option>";
				}
				?>
      </select>
      <input type="hidden" name="KD_PENYAKIT" value="<?php echo $KD_PENYAKIT;?>" /></td>
    </tr>
	<br>
  <tr>
    <td></td>
  </tr>
  <tr>
    <td colspan="3"><hr color="#AAAAAA"></td>
  </tr>
  <tr>
	<tD>
	<input type="submit" name="Submit"  class="btn"value="Tampil"><a href='?page=9&act=berhasil&KD_PENYAKIT'><img src="images/data-add-icon.png" width="30" height="30"  title="Tambah Data Gejala"></a>Tambah</td>
</tr>
  </table>
</form>
</div>
 
<?php
}
elseif ($act=="tampil"){
$KP = $_POST['CmbPenyakit'];
$KD_PENYAKIT = $_GET['KD_PENYAKIT'];
?>
  <?php
  $query="SELECT * FROM PENYAKIT WHERE KD_PENYAKIT='$KP'";
	$parsesql = oci_parse($conn, $query);
 	oci_execute($parsesql) or die(oci_error());
	while ($datap=oci_fetch_array($parsesql)){
$sakit= $datap['PENYAKIT'];
?>
 
  <div class="art-PostContent"><div class="art-BlockHeader">
                <div class="l"></div>
                <div class="r"></div>
                    <div class="art-header-tag-icon">
                        <div class="t">
                          <div align="center">Daftar Gejala Dari Penyakit <?php echo $sakit;?></div>
                        </div>
                    </div>
                    </div>
                    <?php
	}?>
</div>   
<br /></br>
<form action="" method="post">
<table width="100%" border="0" cellpadding="2" cellspacing="1" id="table">
<tr>
 
<tr >
	<th width="21" align="center"><b>No</b></th>
	<th width="47"><b>Kode Gejala</b></th>
	<th width="316">
	<b>Nama Gejala</b></th>
	<th width="31"><b>Nilai MB</b></th>
	<th width="31"><b>Nilai MD</b></th>
	<th width="31"><b>Nilai CF</b></th>
</tr>
<?php
  $query= "SELECT 
RELASI.KD_PENYAKIT,
RELASI.NO_RELASI,
RELASI.MB,
RELASI.MD,
RELASI.CF,
  GEJALA.KD_GEJALA, 
  GEJALA.GEJALA 
  FROM RELASI JOIN GEJALA ON RELASI.KD_GEJALA = GEJALA.KD_GEJALA JOIN PENYAKIT ON RELASI.KD_PENYAKIT = PENYAKIT.KD_PENYAKIT WHERE KD_PENYAKIT='$KP'";
$parsesql = oci_parse($conn, $query);
 	oci_execute($parsesql) or die(oci_error());
		while($rows=oci_fetch_object($parsesql)){
	$no++;
?>
<tr>
 
    <td height="25"><?php echo $posisi+$no ?></td>
    <td height="25"><?php	echo $rows-> KD_GEJALA;?></td>
    <td height="25"><?php	echo $rows ->GEJALA;?></td>
    <td><?php	echo $rows ->MB;?></td>
    <td><?php	echo $rows ->MD;?></td>
    <td><?php	echo $rows ->CF;?></td>
</tr>
   <?php	
}
?>
</table>
<input type="button" name="batal" value="Kembali" class="btn" onClick="javascript:history.go(-1)" />
</form>
<?php
}
 
if($act=="berhasil"){
$KD_PENYAKIT = $_GET['KD_PENYAKIT'];
$NO_RELASI =$_GET['NO_RELASI'];
 
?>
<script type="text/javascript">
function hit()
	{
	var b1 = parseFloat (document.forms.relasi.MB.value);
	if (isNaN (b1))
	b1=0.0;
	var b2 = parseFloat (document.forms.relasi.MD.value);
	if (isNaN (b2))
	b2=0.0;
	var b3 = parseFloat (document.forms.relasi.CF.value);
	if (isNaN (b3))
	b3=0.0;
	document.forms.relasi.CF.value = (b1-b2);
	
	}
</script>
<script type="text/javascript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<div class="text_area" align="justify">
  <div class="art-PostContent"><div class="art-BlockHeader">
                <div class="l"></div>
                <div class="r"></div>
                    <div class="art-header-tag-icon">
                        <div class="t">
                          <div align="center">Pengolahan Data Relasi</div>
                        </div>
                    </div>
                    </div>
</div>     
<br />
 
<form method="post" name="relasi" action="?page=9&act=simpanrelasi">
<table width="100%" align="center" cellpadding="5">
<tr>
    <td colspan="5"><hr color="#AAAAAA"></td>
    
  </tr>
  <tr>
    <td colspan="3" class="subtitle">Nama Penyakit</td>
    </tr>
  <tr>
    <td colspan="3">
      <select name="jumpMenu" id="jumpMenu" class="cmblog" onChange="MM_jumpMenu('parent',this,0)">
        <option value="?page=9&act=berhasil&KD_PENYAKIT">[ Daftar Penyakit ]</option>
        <?php
$query="SELECT * from PENYAKIT order by KD_PENYAKIT";
	$parsesql = oci_parse($conn, $query);
 	oci_execute($parsesql) or die(oci_error());
		while ($datap=oci_fetch_array($parsesql)) {
	// Untuk Buat Nilai Terpilih
	if ($datap['KD_PENYAKIT']==$KD_PENYAKIT) {
		$cek = "selected";
	}
	else {
		$cek ="";
	}
					echo "<option value='?page=9&act=berhasil&KD_PENYAKIT=$datap[KD_PENYAKIT]' $cek>$datap[PENYAKIT]</option>";
				}
				?>
        </select>
      <input type="hidden" name="KD_PENYAKIT" value="<?php echo $KD_PENYAKIT;?>" /></td>
    </tr>
	<br>
  <tr>
    <td width="68%"></td>
    <td width="15%"></td>
    <td width="17%"></td>
  </tr>
  <tr>
    <td colspan="5"><hr color="#AAAAAA"></td>
    
  </tr>
  <tr>
    <td class="subtitle">Daftar Gejala</td>
    <td colspan="2" class="subtitle" align="center">Nilai MB, MD dan CF</td>
    </tr>
	<?php
	$no=0;
  $query = "SELECT * FROM GEJALA ORDER BY KD_GEJALA";
$parsesql = oci_parse($conn, $query);
 	oci_execute($parsesql) or die(oci_error());
		while ($data=oci_fetch_array($parsesql)) {
		$no++;
	?>
  <tr>
    <td>
    <input name="cekgejala[]" type="checkbox" value="<?php echo $data['KD_GEJALA'];?>" <?php echo $cek;?> />&nbsp;<?php echo "[".$data['KD_GEJALA']."]&nbsp;".$data['GEJALA'];?></td>
    <td>
      <input type="text" style="width:30px" name="MB" class ="nilai" id="MB" /></td>
    <td><label for="MD"></label>
      <input type="text" style="width:30px"name="MD" class ="nilai" id="MD" /></td>
    <td><label for="CF"></label>
      <input type="text" style="width:30px" name="CF" class ="nilai" id="CF" /></td>
    
    </tr>
  <?php }?>
  <tr><td></td>
    <td></td>
    <td></td>
  </tr>
  <tr>
    <td colspan="5"><hr color="#AAAAAA"></td>
    
  </tr>
  <tr>
    <td colspan="3" align="center" class="judul"><input type="submit" class="btn" name="simpan" value="Simpan" onclick="return confirm('Apakah anda yakin data relasi ini akan disimpan?')"/>&nbsp;<input type="reset" class="btn" value="Normalkan" /></td>
    </tr>
</table>
</form>
</div>
<?php
}
 
elseif($act=="simpanrelasi"){
	$MB = $_POST['MB'];
	$MD	= $_POST['MD'];
	$CF = $_POST['CF'];
	$KD_PENYAKIT = $_POST['KD_PENYAKIT'];
	
	$cekgejala = $_POST['cekgejala'];
	
	$jum = count($cekgejala);
	if($jum==0){
		echo "<meta http-equiv=\"refresh\" content=\"0; url=index_pakar.php?page=9&act=berhasil\">";
	}
	else{
		$qpil = "SELECT * FROM Relasi WHERE KD_PENYAKIT='$KD_PENYAKIT'";
		$parsesql = oci_parse($conn, $qpil);
		oci_execute($parsesql) or die(oci_error());
				while ($datapil=oci_fetch_array($parsesql)) {
			for($i = 0; $i < $jum; ++$i){
				if($datapil['KD_GEJALA'] != $cekgejala[$i]){
				
				}
			}
		}
		for($i = 0; $i < $jum; ++$i){
			$qryr = "SELECT * FROM Relasi WHERE KD_PENYAKIT='$KD_PENYAKIT' AND KD_GEJALA='$cekgejala[$i]'";
			$parsesql = oci_parse($conn, $qryr);
 			oci_execute($parsesql) or die(oci_error());
			$cocok= oci_num_rows($parsesql);
			if(!$cocok==1){
				
				$qryr="INSERT INTO RELASI(NO_RELASI,KD_PENYAKIT,KD_GEJALA,MB,MD,CF)  VALUES('','$KD_PENYAKIT','$cekgejala[$i]','$MB','$MD','$CF')";
				$parsesql = oci_parse($conn, $qryr);
				oci_execute($parsesql) or die(oci_error());
				$gejala = $cekgejala[$i].",";
				echo "<meta http-equiv=\"refresh\" content=\"0; url=index_pakar.php?page=9&act=tampil&KD_PENYAKIT=\">";
			}
		}
		echo "<meta http-equiv=\"refresh\" content=\"0; url=?page=9&act=tampil&KD_PENYAKIT=\">";
	}
}
?>
Silahkan login untuk menjawab!

senior myphptutorial,, gimana cara membuat pop up pada saat insert pada textbox (kodeprimary) keluar pop up klo data sudah ada pada database,,dan bagaimana membuat readonly ketika data sudah memenuhi syarat contoh di entrykan nip, langsung tampil nama,gol

azlanirwan · Dec 4, 2014 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>gaji</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<style media="all" type="text/css">
@import "../admin/all.css";
</style>
</head>
<body>
<div id="main">
  <div id="header"></div>
  <div id="middle">
    <div id="left-column">
      <h3>Menu</h3>
      <ul class="nav">
        <li><a href="../upembuat.php">Home</a></li>
        <li><a href="gaji.php">Entry Gaji </a></li>
        <li><a href="slip_gaji.php">Data Slip Gaji</a></li>
      </ul>
      <a href="../logout.php?upembuat" class="link">Keluar</a></div>
    <div id="center-column">
      <div class="table"> <img src="../admin/img/bg-th-left.gif" width="8" height="7" alt="" class="left" /> <img src="../admin/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
      <form name="form_gaji" method="post" action="simpan_gaji.php" onSubmit="return validasi(this)">
        <table class="listing form" cellpadding="0" cellspacing="0">
          <tr>
            <th colspan="3" align="center" class="full">Entry GAJI</th>
          </tr>
          <tr>
            <td class="first" width="190"><strong>NIP</strong></td>
            
            <td width="33" class="last">&nbsp;</td>
            <td width="388" class="last"><?php
echo "<select name=txtnip>
<option value=0 selected>-Pilih Nip Karyawan-</option>";
include "../Library/koneksi.php";
$sqlfak	= mysql_query("select * from pegawai_tetap order by nip");
while ($data= mysql_fetch_array($sqlfak))
 {
echo "<option value=$data[nip]>$data[nip]</option>";
}
echo "</select>";
?></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Nama </strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama" readonly/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Jabatan</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama2"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Golongan</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Gaji Pokok</strong></td>
            <td class="first">Rp.</td>
            <td class="first"><span class="last">
              <input type="text" class="text" name="nama4"/>
            </span></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Fungsional</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Potongan Taperium</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Anak</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Beras</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Keluarga </strong></td>
            <td class="first">&nbsp;</td>
            <td class="first"><span class="last">
              <input type="text" class="text" name="nama3"/>
            </span></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Pajak</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Tunjangan Istri</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Potongan IWP</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Jumlah Potongan</strong></td>
            <td class="last">&nbsp;</td>
            <td class="last"><input type="text" class="text" name="nama5"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Gaji Kotor</strong></td>
            <td class="last">Rp.</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td class="first"><strong>Gaji Bersih</strong></td>
            <td class="last">Rp.</td>
            <td class="last"><input type="text" class="text" name="nama"/></td>
          </tr>
          <tr class="bg">
            <td></td>
            <td>&nbsp;</td>
            <td><input type="submit" name="save" value="SIMPAN" /></td>
          </tr>
        </table>
        <p>&nbsp;</p>
      <div class="table">
        <H3 align="center">LAPORAN DATA GAJI PEGAWAI</H3>
        <table width="659" cellpadding="0" cellspacing="0" class="listing">
          <tr>
          <th width="60" height="38" class="first">No</th>
                      <th width="103">NIP </th>
 
            <th width="70">Nama </th>
            <th width="69">Jabatan </th>
            <th width="68">Golongan </th>
            <th width="63">Gaji Pokok </th>
            <th width="60">Gaji Kotor </th>
            <th width="58">Gaji Bersih </th>
            <th width="60">Aksi</th>
          </tr>
         <?php
include "../library/koneksi.php";
$sql1	= "select * from daftar_gaji order by nip";
$query1 = mysql_query($sql1);
$nomor=0;
while($data1 = mysql_fetch_array($query1))
 {
$nomor++;
echo "<tr>";
echo "<td>$nomor</td>";
echo "<td>$data1[nip]</td>";
echo "<td>$data1[nama]</td>";
echo "<td>$data1[jabatan]</td>";
echo "<td>$data1[golongan]</td>";
echo "<td>$data1[gaji_pokok]</td>";
echo "<td>$data1[gaji_kotor]</td>";
echo "<td>$data1[gaji_bersih]</td>";
 
?>
<td><a href="../admin/form_update_jabatan.php?Ubahid=<?php echo $data1[id_jabatan]?>"><img src='../img/edit-icon.gif'></img> </a>| 
<a href="../admin/delete_jabatan.php?Hapusid=<?php echo $data1[id_jabatan] ?>" onClick="return confirm('Anda Yakin Hapus Data dengan No_=<?php echo $data1[no] ?>')"><img src='../img/hr.gif'></img> </a></td>
<?php
echo "</tr>";
}
?>
        </table>
        <p><a href="../laporan/laporan_gaji_karyawan.php"><img src="../images/printer.gif" width="54" height="41" alt="print" /></a></p>
        </form>
      </div>
<p>&nbsp;</p>
    </div>
  </div>
  <div id="footer"></div>
</div>
</body>
</html>
Silahkan login untuk menjawab!