File belum Sempurna (contoh)
-----------------------------------
File uubb.php
-----------------------------------
!html>
!head>
!title>Data bank!/title>
!/head>
!body>
!form name ="formeditdatabank" METHOD="POST" FORM action ="uubb2.php">
!table border ="0">
!tr>
!td colspan = "2" align ="center" height ="1" size ="6">!b>CARI KODE BANK!/b>!/td>
!/tr>
!tr>
!td>!b> kode bank !/b>!/td>
!td> !input type ="text"name="textkode"size="5" maxlength="5">!/td>
!/tr>
!tr>
!td>!/td> !td>
!input type ="submit" value ="cari kode">
!input type ="reset" value ="batal">
!/td>
!/tr>
!/table>
!/body>
!/html>
----------------------------------
File uubb2.php
----------------------------------
~html>
~head>
~title>uubb2 BANK ~/title>
~/head>
~?php
include ("koneksi.php");
mysql_select_db("java_trans");
$query= mysql_query("select * from bank where kode_bank='$_POST[textkode]'") or die(mysql_error());
$data = mysql_fetch_array($query);
?>
~body>
~form name="formeditbank" METHOD="POST" FORM action ="uubbxx.php">
~table border ="0">
~tr>
~td colspan = "2" align ="center" height ="1" size ="6">~b>UPDATE DATA BANK~/b>~/td>
~/tr>
~tr>
~td>~b> kode bank :~/b>~/td>
~td>
~input type = "text" name="textkode" size="5" value=
~?
print "$data[kode_bank]";
?>>
~/td>
~/tr>
~td>Nama Bank :~/td>
~td>
~input type = "text" name="textnama_bank" size="20" value =
~?php
echo "$data[nama_bank]";
?>>
~/td>
~/tr>
~/tr>
~td>Nomor Rekening :~/td>
~td>
~input type = "text" name="textno_rek" size="20" value =
~?php
echo"$data[no_rek]";
?>>
~/td>
~/tr>
~/tr>
~td>Nama Rekening :~/td>
~td>
~input type = "text" name="textnama_rek" size="20" value =
~?php
echo"$data[nama_rek]";
?>>
~/td>
~/tr>
~/tr>
~td>Alamat Bank :~/td>
~td>
~input type="text" name="textalamat_bank" size="30" value =
~?php
echo"$data[alamat_bank]";
?>>
~/td>
~/tr>
~/tr>
~td>Nomor Telephone :~/td>
~td>
~input type = "text" name="textno_telp" size="15" value =
~?php
echo"$data[no_telp]";
?>>
~/td>
~/tr>
~/tr>
~td>Nomor Fax :~/td>
~td>
~input type = "text" name="textno_fax" size="15" value =
~?php
echo"$data[no_fax]";
?>>
~/td>
~/tr>
~/tr>
~td>Email :~/td>
~td>
~input type = "text" name="textemail" size="20" value =
~?php
echo"$data[email]";
?>>
~/td>
~/tr>
~tr>
~td>~/td> ~td> ~input type ="submit" value ="Update Data">
~input type ="reset" value ="batal">
~input type ="button" value ="keluar" OnClick="">
~/td>
~/tr>
~/table>
~/body>
~/html>
---------------------------------
File uubbxx.php
---------------------------------
~?php
$kb=$_POST["textkode"];
$nb=$_POST["textnama_bank"];
$rek=$_POST["textno_rek"];
$nrek=$_POST["textnama_rek"];
$al=$_POST["textalamat_bank"];
$tp=$_POST["textno_telp"];
$tf=$_POST["textno_fax"];
$em=$_POST["textemail"];
?>
~?php
include ("koneksi.php");
mysql_select_db("java_trans");
$masuk="UPDATE bank SET kode_bank='$kb',nama_bank='$nb',no_rek='$rek',nama_rek='$nrek',alamat_bank='$al',no_telp='$tp',no_fax='$tf',email='$em' where kode_bank ='$kb'";
$hasil=mysql_query($masuk);
if (!mysql_query($masuk,$koneksi))
{
die('Error: '.mysql_error());
}
echo "Data BANK BERHASIL di Update";
mysql_close($koneksi);
echo '~a href = "entribank.php"> Kembali ke Entri Data ~/a>';
echo '~/form>';
--------------------------------------------------
Contoh tentang lggt, sama dengan uubb hanya ada
--------------------------------------------------
File lggt.php
--------------------
~?php
$kb=$_POST["textkode"];
?>
~?php
include ("koneksi.php");
mysql_select_db("java_trans");
$masuk="DELETE from bank where kode_bank='$kb'";
$hasil=mysql_query($masuk);
if (!mysql_query($masuk,$koneksi))
{
die('Error: '.mysql_error());
}
echo "Data BANK BERHASIL di HAPUS!!";
mysql_close($koneksi);
echo '~a href = "hapusdatabank.php"> Hapus Data Lagi~/a>';
echo '~/form>';
?>
Jumat, 27 November 2009
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar