..:: Arian-Cyber ::..: Cara Update, Delete dan Edit Buku Tamu dengan Dreamweaver (Lanjutan)

Monday 2 December 2013

Cara Update, Delete dan Edit Buku Tamu dengan Dreamweaver (Lanjutan)

16:31 | Posted by Arian |

Pada postingan kali ini adalah lanjutan dari postingan saya kemaren mengenai Membuat Buku Tamu Sederhana dengan Textfield Spry. Postingan sebelumnya sudah membuat Input Buku Tamu saja. Nah sekarang adalah lanjutannya yaitu Form Tampil Buku Tamu, Edit Buku Tamu, Update Buku Tamu dan Delete Buku Tamu.

Logika sederhanyanya begini:

Setelah memasukkan Data Tamu maka akan Tampil Data Tamu
Di dalam Form Tampil Buku Tamu ada pilihan atau Aksi bisa Edit dan Hapus Data Tamu.
Klik Edit untuk memperbarui Data Tamu
Klik Hapus untuk menghapus Data Tamu

Berikut adalah File-file yang harus anda siapkan terlebih dahulu. Anda bisa gunakan Web Editor atau Notepad.

Pertama buat Form Tampil Data Tamu, berikut kodingnya

<?php require_once('../../../Connections/koneksi_admin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_koneksi_admin, $koneksi_admin);
$query_tampil_tamu = "SELECT * FROM buku_tamu ORDER BY id ASC";
$tampil_tamu = mysql_query($query_tampil_tamu, $koneksi_admin) or die(mysql_error());
$row_tampil_tamu = mysql_fetch_assoc($tampil_tamu);
$totalRows_tampil_tamu = mysql_num_rows($tampil_tamu);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body background="images/page.jpeg">
<h1 align="center">
Buku Tamu</h1>
<table border="1" cellpadding="2" align="center">
<tr>     <td>No</td>     <td>Nama</td>     <td>Email</td>     <td>Pesan</td>     <td colspan="2">Aksi</td>   </tr>
<?php do { ?>
<tr>       <td><?php echo $row_tampil_tamu['id']; ?></td>       <td><?php echo $row_tampil_tamu['nama']; ?></td>       <td><?php echo $row_tampil_tamu['email']; ?></td>       <td><?php echo $row_tampil_tamu['pesan']; ?></td>       <td><a href="edit_tamu.php?id=<?php echo $row_tampil_tamu['id']; ?>">Edit</a></td>       <td><a href="hapus_tamu.php?id=<?php echo $row_tampil_tamu['id']; ?>">Hapus</a></td>     </tr>
<?php } while ($row_tampil_tamu = mysql_fetch_assoc($tampil_tamu)); ?> </table>
<p>
<center>
<a href="input_tamu.php">Input Buku Tamu</a></center>
</p>
</body>
</html>
<?php
mysql_free_result($tampil_tamu);
?>
</texarea></pre>
</div>

Lanjut untuk koding Edit Data Tamu

<?php require_once('../../../Connections/koneksi_admin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE buku_tamu SET nama=%s, email=%s, pesan=%s WHERE id=%s",
                       GetSQLValueString($_POST['nama'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['pesan'], "text"),
                       GetSQLValueString($_POST['id'], "int"));

  mysql_select_db($database_koneksi_admin, $koneksi_admin);
  $Result1 = mysql_query($updateSQL, $koneksi_admin) or die(mysql_error());

  $updateGoTo = "tampil_tamu.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

mysql_select_db($database_koneksi_admin, $koneksi_admin);
$id=$_GET['id'];
$query_edit_tamu = "SELECT * FROM buku_tamu where id=$id";
$edit_tamu = mysql_query($query_edit_tamu, $koneksi_admin) or die(mysql_error());
$row_edit_tamu = mysql_fetch_assoc($edit_tamu);
$totalRows_edit_tamu = mysql_num_rows($edit_tamu);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body background="images/page.jpeg">
<h1 align="center">
Form Edit Buku Tamu</h1>
<form action="<?php echo $editFormAction; ?>
" method="post" name="form1" id="form1">
  <table align="center">
<tr valign="baseline">       <td nowrap="nowrap" align="right">Id:</td>       <td><?php echo $id; ?></td>     </tr>
<tr valign="baseline">       <td nowrap="nowrap" align="right">Nama:</td>       <td><input type="text" name="nama" value="<?php echo htmlentities($row_edit_tamu['nama'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>     </tr>
<tr valign="baseline">       <td nowrap="nowrap" align="right">Email:</td>       <td><input type="text" name="email" value="<?php echo htmlentities($row_edit_tamu['email'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>     </tr>
<tr valign="baseline">       <td nowrap="nowrap" align="right">Pesan:</td>       <td><input type="text" name="pesan" value="<?php echo htmlentities($row_edit_tamu['pesan'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>     </tr>
<tr valign="baseline">       <td nowrap="nowrap" align="right"> </td>       <td><input type="submit" value="Update record" /></td>     </tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
  <input type="hidden" name="id" value="<?php echo $row_edit_tamu['id']; ?>" />
</form>
<p>
 </p>
</body>
</html>
<?php
mysql_free_result($edit_tamu);
?>

Terakhir adalah koding untuk Hapus Data Tamu

<?php require_once('../../../Connections/koneksi_admin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {
  $deleteSQL = sprintf("DELETE FROM buku_tamu WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));

  mysql_select_db($database_koneksi_admin, $koneksi_admin);
  $Result1 = mysql_query($deleteSQL, $koneksi_admin) or die(mysql_error());

  $deleteGoTo = "tampil_tamu.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body background="images/page.jpeg">
<h1 align="center">
Buku Tamu</h1>
</body>
</html>

Catatan*
Form Buku Tamu di atas saya buat dengan menggunakan Adobe Dreamweaver CS6 memanfaatkan fasilitas DATA OBJECT

Untuk yang ingin Download bisa

Jasa Pembuatan Website Murah, dengan tampilan elegan, ArianCyber

Sekian pembahasan atau postingan saya mengenai Update, Delete dan Update Buku Tamu . Apabilla ada kesalahan dalam pembahasan atau postingan saya mohon untuk dibenarkan karena saya masih dalam tahap belajar bukan Expert. Apabila ada Saran atau kritik silakan anda tulis di kotak komentar yang sudah di sediakan atau bisa kontak langsung ke saya. Semoga bermanfaat.
Apabila ada dari anda ingin memposting halaman ini harap cantumkan sumbernya dan dengan bahasa anda sendiri, jadilah blogger yang baik dan mempunyai Etika dalam dunia maya.

Untuk yang kurang jelas bisa sertakan komentar Anda, Terima Kasih

//,)™

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-7267515865878961"
data-ad-slot="4861783713"
data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

..:: Arian-Cyber ::..

Being Bad Is Good, But Being Good Is Better !!!

Welcome

Search

Category

Popular Post

Cara Update, Delete dan Edit Buku Tamu dengan Dreamweaver (Lanjutan)

0 comments:

Post a Comment

Me on G+

Colleger

Blog Arsive

Translate

Visitor Total

This Yours