Kamis, 03 Desember 2009
Latihan PHP & MYSQL
Input_member.php
<html>
<head>
<title>Buku tamu - MYSQL - PHP</title>
</head>
<body>
<font size=5 face=verdana color=blue><b>Member Club Online</b></font>
<br>================================================<br><br>
<table>
<form action="member2.php"method="post">
<tr>
<td>No Anggota </td><td>:</td><td><input type="text"name="noanggota"size="15"maxlength="5"></td>
</tr><tr>
<td>Nama </td><td>:</td><td><input type="text"name="nama"size="35"maxlength="50"></td>
</tr>
<tr>
<td>Email </td><td>:</td><td><input type="text"name="email"size="35"maxlength="50"></td>
</tr>
<tr>
<td>Alamat </td><td>:</td><td><textarea name="alamat"rows="5" cols="30"></textarea></td>
</tr>
<tr>
<td></td><td></td><td><input type="submit"value="simpan"></td>
</tr>
<tr>
</tr>
</form>
</table>
</body>
</html>
Output_member.php
<html>
<head>
<title>Title here!</title>
</head>
<body>
<font size=5 face=verdana color=blue><b>Penyimpanan Data Member Club Online</b></font>
<?
echo"<hr>";
$date=date('d F Y, H:i:s');
echo'<pre>';
echo'Tanggal Pendaftaran Member Club Online :';
echo'<b>'.$date.'</b>';
echo'<hr>';
$conn=mysql_connect("localhost","root","password");
if($conn){
mysql_select_db("uas");
echo'<pre>';
echo'<br>No Anggota : ';
echo'<b>'.$noanggota.'</b>';
echo'<br>Nama : ';
echo'<b>'.$nama.'</b>';
echo'<br>Emai : ';
echo'<b>'.$email.'</b>';
echo'<br>Alamat : ';
echo'<b>'.$alamat.'</b><br>';
$sqlstr="insert into member(noanggota, nama, email, alamat) values('$noanggota','$nama','$email','$alamat')";
$hasil=mysql_query($sqlstr,$conn);
echo"<hr>";
echo"<b><h4>Simpan Data Member Berhasil Dilakukan!</b></h4>";
mysql_close($conn);
}else{
echo"Server not connected!";
}
?>
<a href="member3.php">Klik Disini Untuk Melihat Data Anggota</a>
</body>
</html>
List_member.php
<html>
<head>
<title>Title here!</title>
</head>
<body>
<div align="center"><strong><font color="blue" face="arial" size="5">
DATA MEMBER CLUB ONLINE</DIV></STRONG></FONT>
<FORM>
<TABLE BORDER='1' align=center>
<TR BGCOLOR="GREEN">
<TD align=center>NO_ANGGOTA</TD>
<TD align=center>NAMA</TD>
<TD align=center>EMAIL</TD>
<TD align=center>ALAMAT</TD>
</TR>
<?
$koneksi=mysql_connect("localhost","root","password") or die(mysql_error());
$pilih_db=mysql_select_db("uas") or die(mysql_error());
$perintah="select * from member";
$jalankan_perintah=mysql_query($perintah)or die(mysql_error());
if(mysql_num_rows($jalankan_perintah)==0)
{
echo"<tr>"."<td colspan=5 align=center>data tidak ada</td>"."tr";
}
while($row=mysql_fetch_array($jalankan_perintah))
{
echo"<tr>";
echo"<td>$row[noanggota]</td>";
echo"<td>$row[nama]</td>";
echo"<td>$row[email]</td>";
echo"<td>$row[alamat]</td>";
echo"<TR>";
}
?>
</TABLE>
</body>
</html>
No Response to "Latihan PHP & MYSQL"
Leave A Reply