Selasa, 04 September 2012
desainer
Desain Form & Koneksi Database
1. Buat Database : Buku_nimmasing2
2. Buat Table : Anggota Desain Form :
Struktur table sebagai berikut :
Simpan dengan nama member.php
<body>
<form action="simpan.php" method="post">
<table width="345" border="1" align="center" cellpadding="2" cellspacing="1"
bordercolor="#00FF00" bgcolor="#FF00FF">
<tr bgcolor="#0066FF">
<td colspan="3"><div align="center">
<h2><strong>::: Masukan Data Anggota ::: </strong></h2>
</div></td>
</tr>
<tr>
<td width="104"><strong>Id Anggota </strong></td>
<td width="15"><div align="center"><strong>:</strong></div></td>
<td width="202"><input name="txtid" type="text" maxlength="5" /></td>
</tr>
<tr>
<td><strong>Nama</strong></td>
<td><div align="center"><strong>:</strong></div></td>
<td><input name="txtnama" type="text" /></td>
</tr>
<tr>
<td><strong>Alamat</strong></td>
<td><div align="center"><strong>:</strong></div></td>
<td><textarea name="talamat" ></textarea></td>
</tr>
<tr>
<td><strong>Jenis Kelamin </strong></td>
<td><div align="center"><strong>:</strong></div></td>
<td><p>
<input name="rjenis" type="radio" value="Perempuan" />Perempuan
<input name="rjenis" type="radio" value="Laki" />Laki-Laki</p></td>
1
Field Type Size Ket
Id_Anggota Char 5 PK
Nama_anggota Varchar 35
Alamat Varchar 50
Kelamin Varchar 10
Web Programming 2 YEA/Ridwan
</tr>
<tr>
<td colspan="3"><div align="center"><input name="simpan" type="submit"
value="Simpan" /> <input name="reset" type="reset" value="Reset" />
</div></td>
</tr>
</table>
<br /><br /><div align="center"><a href="tampil.php" class="style1">LIHAT DATA
ANGGOTA</a>
</div>
</form>
</body>
Simpan dengan nama : simpan.php
<body>
<?php
$koneksi=mysql_connect("localhost","root","yuniekaachyani")or die ("Gagal konek
server".mysql_error());
mysql_select_db("buku",$koneksi)or die ("Database gagal dibuka".mysql_error());
if($_POST['simpan']){
mysql_query("INSERT INTO anggota VALUES ('$txtid','$txtnama','$talamat','$rjenis')");
echo"<script>window.location='tampil.php'</script>";
}
?>
</body>
Simpan dengan nama : tampil.php
<body>
<div align="center"><a href="member.php" class="style1">INPUT ANGGOTA</a>
</div>
<table width="656" border="1" align="center" cellpadding="2" cellspacing="1"
bgcolor="#FFFFCC">
<tr>
<td colspan="5"><div align="center">
<h2><strong><marquee behavior="scroll" scrollamount="3">::: DATA ANGGOTA ::: </
marquee></strong></h2>
2
Web Programming 2 YEA/Ridwan
</div></td>
</tr>
<tr>
<td width="99"><div align="center"><strong>Id Member </strong></div></td>
<td width="130"><div align="center"><strong>Nama Member </strong></div></td>
<td width="173"><div align="center"><strong>Alamat</strong></div></td>
<td width="105"><div align="center"><strong>Jenis Kelamin </strong></div></td>
<td width="111"><div align="center"><strong>Aksi</strong></div></td>
</tr>
<?php
$koneksi=mysql_connect("localhost","root","yuniekaachyani")or die ("Gagal konek
server".mysql_error());
if($koneksi){
mysql_select_db("buku",$koneksi)or die("Database gagal dibuka ".mysql_error());
$que = mysql_query("SELECT * FROM anggota");
while($hasil=mysql_fetch_array($que)){
?>
<tr bgcolor=#99FF66>
<td><?php echo $hasil['0'];?></td>
<td><?php echo $hasil['1'];?></td>
<td><?php echo $hasil['2'];?></td>
<td><?php echo $hasil['3'];?></td>
<td align="center">
<a href="hapus.php?id_anggota=<?php echo $hasil['0'];?>">Hapus</a> ||
<a href="ubahdata.php?id_anggota=<?php echo $hasil['id_anggota'];?>">Ubah</a></td>
</tr>
<?php }} ?>
</table>
</body>
Langganan:
Postingan (Atom)
