Script PHP Insert Form Buku Tamu Dengan Dreamweaver CS3

php_development

Untuk membuat Insert Form Buku Tamu kita siapkan table buku tamunya dahulu yaitu seperti table dibawah ini:

[php]

CREATE TABLE `bukutamu` (

`id` int(8) NOT NULL AUTO_INCREMENT,

`nama` varchar(25) NOT NULL,

`email` varchar(25) NOT NULL,

`isi` varchar(100) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[/php]

 

Sedangkan untuk Script PHP Insert Form Buku Tamu Dengan Dreamweaver CS3 lengkapnya sebagai berikut:

[php]

<?php require_once(‘Connections/koneksi.php’); ?>

<?php

if (!function_exists(“GetSQLValueString”)) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = “”, $theNotDefinedValue = “”)

{

$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_insert”])) && ($_POST[“MM_insert”] == “form1”)) {

$insertSQL = sprintf(“INSERT INTO bukutamu (nama, email, isi) VALUES (%s, %s, %s)”,

GetSQLValueString($_POST[‘nama’], “text”),

GetSQLValueString($_POST[’email’], “text”),

GetSQLValueString($_POST[‘isi’], “text”));

mysql_select_db($database_koneksi, $koneksi);

$Result1 = mysql_query($insertSQL, $koneksi) or die(mysql_error());

}

mysql_select_db($database_koneksi, $koneksi);

$query_bukutamu = “SELECT * FROM bukutamu”;

$bukutamu = mysql_query($query_bukutamu, $koneksi) or die(mysql_error());

$row_bukutamu = mysql_fetch_assoc($bukutamu);

$totalRows_bukutamu = mysql_num_rows($bukutamu);

?><!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>

<form action=”<?php echo $editFormAction; ?>” method=”post” name=”form1″ id=”form1″>

<table align=”center”>

<tr valign=”baseline”>

<td nowrap=”nowrap” align=”right”>Nama:</td>

<td><input type=”text” name=”nama” value=”” size=”32″ /></td>

</tr>

<tr valign=”baseline”>

<td nowrap=”nowrap” align=”right”>Email:</td>

<td><input type=”text” name=”email” value=”” size=”32″ /></td>

</tr>

<tr valign=”baseline”>

<td nowrap=”nowrap” align=”right” valign=”top”>Isi:</td>

<td><textarea name=”isi” cols=”50″ rows=”5″></textarea>

</td>

</tr>

<tr valign=”baseline”>

<td nowrap=”nowrap” align=”right”>&nbsp;</td>

<td><input type=”submit” value=”Kirim” /></td>

</tr>

</table>

<input type=”hidden” name=”MM_insert” value=”form1″ />

</form>

<p>&nbsp;</p>

</body>

</html>

<?php

mysql_free_result($bukutamu);

?>

[/php]