Jumat, 17 Januari 2014

form dengan aplikasi PHP dan MySQL


buat database dengan struktur berikut

buat formnya :
scrpit form :
<!DOCTYPE html>
<html>
<head>
<link rel="icon" type="image/gif" href="ss.jpg"/>
<meta charset="utf-8">
<title>CONTAC</title>
<link rel="stylesheet" href="css/style.css" type="text/css">
<style type="text/css">
body {
background-image: url(1324760.jpg);
}
    </style>
</head>
<body>
<audio controls autoplay loop hidden>
  <source src="taylor_swift-22.mp3" type="audio/mpeg">
  </audio>
<div id="background">
<div id="page">
<div id="header">
<div id="logo"><img src="heeader.jpg" alt="" width="863" height="201"></div>
<div id="navigation">
<ul>
<li>
<a href="index.html">Home</a>
</li>
<li>
<a href="profile.html">PROFILE</a>
</li>
<li>
 <a href="gallery.html">GALLERY</a>
</li>
<li>
 <a href="coret.html">CORETANKU</a>
</li>
<li class="selected">
<a href="contact.html">Contact</a>
</li>
</ul>
</div>
</div>
<div id="contents">
<div class="box">
<div>
<div id="contact" class="body">
<h1><u>Contact</u></h1>
<p>&nbsp;</p>
<form name ="contac" action="proses.php" method="post">
<table>
<tbody>
<tr>
<td>Name:</td>
<td><input  name="name" type="text" id="name" class="txtfield"></td>
</tr> <tr>
<td>Email:</td>
<td><input  name="email" type="text" id="email" class="txtfield"></td>
</tr> <tr>
<td>Subject:</td>
<td><input  name="subject" type="text" id="subject" class="txtfield"></td>
</tr> <tr>
<td>Message:</td>
<td><textarea  name="message"></textarea></td>
</tr> <tr>
<td></td>
<td><input type="submit" value="" class="btn"></td>
</tr>
</tbody>
</table>
</form>
<h2>Triana Dewi Salma</h2>
<p>
<span>Email:</span> <a href="http://www.gmail.com/tdsalma">tdsalma@gmail.com</a> </p>
<p>
<span>Blog:</span> <a href="http://trianadewisalma.blogspot.com">trianadewisalma.blogspot.com</a> </p>
</div>
</div>
</div>
</div>
</div>
<div id="footer">
<div>
<ul class="navigation">
<li class="active"></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
<div id="connect">
<a href="https://www.facebook.com/triana.d.salma/" target="_blank" class="facebook"></a> <a href="https://twitter.com/saal_salma/" target="_blank" class="twitter"></a> 
</div>
</div>
<p>© Trianadewisalma.pusku.com </p>
</div>
</div>
</body>
</html>
lalu buat file koneksi.php
<?php

$connect = mysql_connect("localhost","root","")
or die(mysql_error());

mysql_select_db("web", $connect);
?>

lalu proses.php
<?PHP

include 'koneksi.php';

$name = $_POST['name'];
$email = $_POST['email'];
$subject = $_POST['subject'];
$message = $_POST['message'];

$q = "INSERT INTO kontak (
name,
email,
subject,
message
)
VALUES(
'$name',
'$email',
'$subject',
'$message'
)"; 

if(mysql_query($q,$connect)){
echo "<!DOCTYPE html>
<html>
<head>
<link rel=\"icon\" type=\"image/gif\" href=\"ss.jpg\"/>
<meta charset=\"utf-8\">
<title>pesan dikirim</title>
<link rel=\"stylesheet\" href=\"css/style.css\" type=\"text/css\">
<style type=\"text/css\">
body {
background-image: url(1324760.jpg);
}
    </style>
</head>
<body>
<audio controls autoplay loop hidden>
  <source src=\"taylor_swift-22.mp3\" type=\"audio/mpeg\">
  </audio>
<div id=\"background\">
<div id=\"page\">
<div id=\"header\">
<div id=\"logo\"><img src=\"heeader.jpg\" alt=\"\" width=\"863\" height=\"201\"></div>
<div id=\"navigation\">
<ul>
<li>
<a href=\"index.html\">Home</a>
</li>
<li>
<a href=\"profile.html\">PROFILE</a>
</li>
<li >
 <a href=\"gallery.html\">GALLERY</a>
</li>
<li>
 <a href=\"coret.html\">CORETANKU</a>
</li>
<li class=\"selected\">
<a href=\"contact.html\">Contact</a>
</li>
</ul>
</div>
</div>
<div id=\"contents\">
<div class=\"box\">
<div>
<div id=\"kontak\" class=\"body\">
 <div><center>
 <p><img src=\"jempol.jpg\" width=\"100\" height=\"100\" align=\"center\"></p><br>
   <h2>pesan berhasil dikirim</h2><br><br>
<h3>ingin menampilkan data yang masuk??</h3><br>
<a href=\"tampildata.php\" target=\"_blank\"><img src=\"ya.jpg\"width=\"50\" height=\"50\"/></a><a href=\"contact.html\" target=\"_blank\"><img src=\"no.jpg\"width=\"50\" height=\"50\"/></a>
<h3>Terimakasih Telah Mengunjungi Web Saya</h3>
<img src=\"senyum.jpg\" width=\"200\" height=\"180\"></p>
</div>
</div>
</div>
</div>
</div>
</div>
<div id=\"footer\">
<div>
<ul class=\"navigation\">
<li class=\"active\"></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
<div id=\"connect\">
<a href=\"https://www.facebook.com/triana.d.salma/\" target=\"_blank\" class=\"facebook\"></a> <a href=\"https://twitter.com/saal_salma/\" target=\"_blank\" class=\"twitter\"></a> 
</div>
</div>
<p>© Trianadewisalma.pusku.com </p>
</div>
</div>
</body>
</html>";
}
else{
die(mysql_error());
}
?>
 kemudian file tampildata.php
<!DOCTYPE html>
<html>
<head>
<link rel="icon" type="image/gif" href="ss.jpg"/>
<meta charset="utf-8">
<title>kontak</title>
<link rel="stylesheet" href="css/style.css" type="text/css">
<style type="text/css">
body {
background-image: url(1324760.jpg);
}
    </style>
</head>
<body>
<audio controls autoplay loop hidden>
  <source src="taylor_swift-22.mp3" type="audio/mpeg">
  </audio>
<div id="background">
<div id="page">
<div id="header">
<div id="logo"><img src="heeader.jpg" alt="" width="863" height="201"></div>
<div id="navigation">
<ul>
<li>
<a href="index.html">Home</a>
</li>
<li>
<a href="profile.html">PROFILE</a>
</li>
<li >
 <a href="gallery.html">GALLERY</a>
</li>
<li>
 <a href="coret.html">CORETANKU</a>
</li>
<li  class="selected">
<a href="contact.html">Contact</a>
</li>
</ul>
</div>
</div>
<div id="contents">
<div class="box">
<div>
<div id="news" class="body">
 <div>
  <?
include"koneksi.php";
$tamu="select * from kontak";
$buku_tamu=mysql_query($tamu);
echo '<table class="komentar2" border="2" width="100%">';
echo '<tr>';
echo '<td>No</td>';
echo '<td>name</td>';
echo '<td>email</td>';
echo '<td>subject</td>';
echo '<td>message</td>';
echo '<td align=center colspan=2>Opsi</td>';
echo '</tr>';
while($data_tamu=mysql_fetch_array($buku_tamu))
{
echo '<tr>';
echo '<td>'.$data_tamu["id"].'</td>';
echo '<td>'.$data_tamu["name"].'</td>';
echo '<td>'.$data_tamu["email"].'</td>';
echo '<td>'.$data_tamu["subject"].'</td>';
echo '<td>'.$data_tamu["message"].'</td>';
echo '<td><a align=center href=edit2.php?id='.$data_tamu["id"].'>Edit</a></td>';
echo '<td><a align=center href=hapus.php?id='.$data_tamu["id"].'>Hapus</a></td>';
echo '</tr>';
}
echo '</table>';
mysql_close();
?>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="footer">
<div>
<ul class="navigation">
<li class="active"></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
<div id="connect">
<a href="https://www.facebook.com/triana.d.salma/" target="_blank" class="facebook"></a> <a href="https://twitter.com/saal_salma/" target="_blank" class="twitter"></a> 
</div>
</div>
<p>© Trianadewisalma.pusku.com </p>
</div>
</div>
</body>
</html>
tampilannya :

lalu file edit.php
<!DOCTYPE html>
<html>
<head>
<link rel="icon" type="image/gif" href="ss.jpg"/>
<meta charset="utf-8">
<title>Contact</title>
<link rel="stylesheet" href="css/style.css" type="text/css">
<style type="text/css">
body {
background-image: url(1324760.jpg);
}
    </style>
</head>
<body>
<audio controls autoplay loop hidden>
  <source src="taylor_swift-22.mp3" type="audio/mpeg">
  </audio>
<div id="background">
<div id="page">
<div id="header">
<div id="logo"><img src="heeader.jpg" alt="" width="863" height="201"></div>
<div id="navigation">
<ul>
<li>
<a href="index.html">Home</a>
</li>
<li>
<a href="profile.html">PROFILE</a>
</li>
<li >
 <a href="gallery.html">GALLERY</a>
</li>
<li >
 <a href="coret.html">CORETANKU</a>
</li>
<li class="selected">
<a href="contact.html">Contact</a>
</li>
</ul>
</div>
</div>
<div id="contents">
<div class="box">
<div>
<div id="contact" class="body">
 <div>
  <?php
include"koneksi.php";
$id=$_GET['id'];
$query=mysql_query("SELECT * from kontak where id='$id'");
while($rw_edit=mysql_fetch_array($query)){
?>
<p id="p3"><b> Edit Data:</b></p>
<form method="post" enctype="multipart/form-data" name="kontak">
  <table class="komentar1" width="670" border="0" cellspacing="0" cellpadding="0"><tr><td><table width="670" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td> Name : 
          <input type="text" size="50" name="nama" value="<?php echo $rw_edit['name']; ?>" required> <br>
        Email : 
        <input type="text" size="50" name="email" value="<?php echo $rw_edit['email']; ?>" required> <br>
         Subject : 
        <input type="text" size="50" name="subject" value="<?php echo $rw_edit['subject']; ?>" required> <br>
        Message    : <br>
        <textarea name="message"  cols="30" required><?php echo $rw_edit['message']; ?></textarea> <br>
       <input type="submit" value="" class="btn"></td>

    </tr>
  </table></td>
  </tr>
</table>
</form>
<?php }?>



</div></div>
</div>
</div>
</div>
</div>
<div id="footer">
<div>
<ul class="navigation">
<li class="active"></li>
<li></li>
<li></li>
<li></li>
<li></li>
</ul>
<div id="connect">
<a href="https://www.facebook.com/triana.d.salma/" target="_blank" class="facebook"></a> <a href="https://twitter.com/saal_salma/" target="_blank" class="twitter"></a> 
</div>
</div>
<p>© Trianadewisalma.pusku.com </p>
</div>
</div>

<?php
if($_POST['nama']){
$id=$_GET['id'];
$nama=$_POST['nama'];
$email=$_POST['email'];
$subject=$_POST['subject'];
$message=$_POST['message'];
$query=mysql_query("UPDATE kontak SET name='$nama', email='$email', subject='$subject', message='$message' where id='$id'");
echo "<script> alert(' Data Telah Berhasil Di Edit' ) </script>";
echo" <meta http-equiv='refresh' content='0;url=tampildata.php' />";
}
?> 
    
</body>
</html>

tampilan editnya :
terakhir yaitu..
delete.php
<?php
include"koneksi.php";
$id=$_GET['id'];
$hapus=mysql_query("DELETE FROM kontak where id='$id'");
echo "<script> alert(' Data Telah Berhasil Di Hapus' ) </script>";
echo" <meta http-equiv='refresh' content='0;url=tampildata.php' />";

?>