PHP Indonesia - Facebook | PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
para master mohon bantuanya... saya ingin pada inp... Oct 6th 2013, 14:10, by Red Arrow | para master mohon bantuanya... saya ingin pada input text pakai adalah pengurangan dari input text B_LWBP - L_LWBP coding yang saya buat seperti ini
<?php include ("Connections/koneksi2.php"); // mengambil data Pelanggan yang akan diedit $q = "SELECT * FROM pelanggan WHERE ID_PEL = '".$_GET['ID_PEL']."'"; $r = mysql_query($q) or die ($q); $d = mysql_fetch_array ($r); // proses penyimpanan update if (isset ($_POST['simpan'])) { $ID_PEL = $_POST['ID_PEL']; $B_LWBP = $_POST['B_LWBP']; $L_LWBP = $_POST['L_LWBP']; $PAKAI = $_POST['PAKAI']; $q = "UPDATE pelanggan SET B_LWBP = '".$B_LWBP."', PAKAI = '".$PAKAI."' WHERE ID_PEL = '".$ID_PEL."'"; $r = mysql_query($q) or die (mysql_error()); if($r) { // untuk kembali ke halaman cInputStandPlg.php header ("location:cInputStandPlg.php"); } else { $msg = "Data tidak bisa diedit"; } } ?> <form action="InputStand.php?kode=<?php echo $_GET['ID_PEL'];?>" method="POST"> <fieldset> <legend> Form Input Stand Pelanggan </legend> <table width="100%"> <?php if ($msg='') { echo "<tr> <td> </td> <td> </td> <td> $msg </td> </tr>"; } ?> <tr> <td width="8%">ID PEL</td> <td width="2%"> : </td> <td width="40%"> <input type='text' name='ID_PEL' value='<?php echo $d[1];?>'> </td> <td width="1%"> </td> <td width="10%">LOKASI</td> <td width="1%">:</td> <td width="36%"><input type='text' name='LOKASI' value='<?php echo $d[3];?>' /></td> </tr> <tr> <td> Nama </td><td> : </td> <td> <input name='nama' type='text' value='<?php echo $d[9];?>' size="47"> </td> <td> </td> <td>NM CATER</td> <td>:</td> <td><input type='text' name='NM_CATER' value='<?php echo $d[31];?>' /></td> </tr> <tr> <td> Alamat </td><td> : </td> <td> <input name='Alamat' type='text' value='<?php echo $d[10];?>' size="47"> </td> <td> </td> <td>NM_KOORD</td> <td>:</td> <td><input type='text' name='NM_KOORD' value='<?php echo $d[33];?>' /></td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td>B_LWBP</td><td> : </td> <td><input name='B_LWBP' type='text' value='<?php echo $d[25];?>' /></td> <td> </td> <td>latitude</td> <td>:</td> <td><input name='latitude' type='text' value='<?php echo $d[80];?>' size="47" /></td> </tr> <tr> <td>L_LWBP </td> <td>: </td> <td><input name='L_LWBP' type='text' value='<?php echo $d[26];?>' /></td> <td> </td> <td>longitude </td> <td>:</td> <td><input name='longitude' type='text' value='<?php echo $d[81];?>' size="47" /></td> </tr> <tr> <td>PAKAI</td> <td>:</td> <td><input name='PAKAI' type='text' value='<?php echo $d[27];?>' /></td> <td> </td> <td><label for="KET_KWH">KET_KWH</label></td> <td>:</td> <td><select name="KET_KWH" id="KET_KWH"> <option>KWH METER MACET</option> <option>KWH METER MUNDUR</option> <option>KWH METER TIDAK ADA</option> <option>PELANGGAN TIDAK SESUAI RBM</option> <option>RUMAH TUTUP</option> </select></td> </tr> <tr> <td></td> <td></td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td></td> <td></td> <td><input type='submit' name='simpan' value='Ubah' /> <input type='reset' name='reset' value='Reset' /></td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </form> </fieldset> |
| | databsenya gan sekalain hehe | | |
|
Tidak ada komentar:
Posting Komentar