Berikut Skripnya :
sambung.php
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_sambung = "localhost";
$database_sambung = "dw_bookstore";
$username_sambung = "root";
$password_sambung = "";
$sambung = mysql_pconnect($hostname_sambung, $username_sambung, $password_sambung) or trigger_error(mysql_error(),E_USER_ERROR);
?>
show.php
<?php require_once('Connections/sambung.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_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO authors (au_id, au_lname, au_fname, phone, address, city, `state`, zip) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['au_id'], "text"),
GetSQLValueString($_POST['au_lname'], "text"),
GetSQLValueString($_POST['au_fname'], "text"),
GetSQLValueString($_POST['phone'], "text"),
GetSQLValueString($_POST['address'], "text"),
GetSQLValueString($_POST['city'], "text"),
GetSQLValueString($_POST['state'], "text"),
GetSQLValueString($_POST['zip'], "text"));
mysql_select_db($database_sambung, $sambung);
$Result1 = mysql_query($insertSQL, $sambung) or die(mysql_error());
$insertGoTo = "show.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_sambung, $sambung);
$query_rsAuthor = "SELECT * FROM authors";
$rsAuthor = mysql_query($query_rsAuthor, $sambung) or die(mysql_error());
$row_rsAuthor = mysql_fetch_assoc($rsAuthor);
$totalRows_rsAuthor = mysql_num_rows($rsAuthor);
//---------------------------------------------------------------------
$namaTabel = "authors";
$query = "SELECT * FROM $namaTabel";
$hasil = mysql_query($query);
$jumField = mysql_num_fields($hasil);
$sites = array();
while ($data = mysql_fetch_array($hasil))
{
$sites [] = array('au_id' => $data['au_id'],
'au_lname' => $data['au_lname'],
'au_fname' => $data['au_fname'],
'phone' => $data['phone'],
'address' => $data['address'],
'city' => $data['city'],
'state' => $data['state'],
'zip' => $data['zip']);
}
// 5. PARSING DATA SQL -> XML Document : print_r($sites);
$document = new DOMDocument();
$document->formatOutput = true;
$root = $document->createElement( "data" );
$document->appendChild( $root );
foreach( $sites as $book )
{
$block = $document->createElement( "authors" );
//------------------------------------------------------
$au_id = $document->createElement( "au_id" );
$au_id->appendChild(
$document->createTextNode( $book['au_id'] )
);
$block->appendChild( $au_id );
//------------------------------------------------------
$au_lname = $document->createElement( "au_lname" );
$au_lname->appendChild(
$document->createTextNode( $book['au_lname'] )
);
$block->appendChild( $au_lname );
//------------------------------------------------------
$au_fname = $document->createElement( "au_fname" );
$au_fname->appendChild(
$document->createTextNode( $book['au_fname'] )
);
$block->appendChild( $au_fname);
//------------------------------------------------------
$phone = $document->createElement( "phone" );
$phone->appendChild(
$document->createTextNode( $book['phone'] )
);
$block->appendChild( $phone );
//------------------------------------------------------
$address = $document->createElement( "address" );
$address->appendChild(
$document->createTextNode( $book['address'] )
);
$block->appendChild( $address );
//------------------------------------------------------
$city = $document->createElement( "city" );
$city->appendChild(
$document->createTextNode( $book['city'] )
);
$block->appendChild( $city );
//------------------------------------------------------
$state = $document->createElement( "state" );
$state->appendChild(
$document->createTextNode( $book['state'] )
);
$block->appendChild( $state );
//------------------------------------------------------
$zip = $document->createElement( "zip" );
$zip->appendChild(
$document->createTextNode( $book['zip'] )
);
$block->appendChild( $zip );
//------------------------------------------------------
$root->appendChild( $block );
}
// 6. MENYIMPAN DATA DALAM BENTUK FILE LinkAuthors.xml
$document->save("LinkAuthors.xml");
?>
<!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>
<p> </p>
<h1 align="center">Praktikum Webservice</h1>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">Au_id:</td>
<td><input type="text" name="au_id" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Au_lname:</td>
<td><input type="text" name="au_lname" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Au_fname:</td>
<td><input type="text" name="au_fname" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Phone:</td>
<td><input type="text" name="phone" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Address:</td>
<td><input type="text" name="address" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">City:</td>
<td><input type="text" name="city" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">State:</td>
<td><input type="text" name="state" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Zip:</td>
<td><input type="text" name="zip" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Insert record" /></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p align="center">File dalam bentuk XML dengan nama file <a href="LinkAuthors.xml">LinkAuthors.xml</a></p>
<table border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<th bgcolor="#FFCC66">au_id</th>
<th bgcolor="#FFCC66">au_lname</th>
<th bgcolor="#FFCC66">au_fname</th>
<th bgcolor="#FFCC66">phone</th>
<th bgcolor="#FFCC66">address</th>
<th bgcolor="#FFCC66">city</th>
<th bgcolor="#FFCC66">state</th>
<th bgcolor="#FFCC66">zip</th>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rsAuthor['au_id']; ?></td>
<td><?php echo $row_rsAuthor['au_lname']; ?></td>
<td><?php echo $row_rsAuthor['au_fname']; ?></td>
<td><?php echo $row_rsAuthor['phone']; ?></td>
<td><?php echo $row_rsAuthor['address']; ?></td>
<td><?php echo $row_rsAuthor['city']; ?></td>
<td><?php echo $row_rsAuthor['state']; ?></td>
<td><?php echo $row_rsAuthor['zip']; ?></td>
</tr>
<?php } while ($row_rsAuthor = mysql_fetch_assoc($rsAuthor)); ?>
</table>
<p align="center">File dalam bentuk XML dengan nama file <a href="LinkAuthors.xml">LinkAuthors.xml</a></p>
</body>
</html>
<?php
mysql_free_result($rsAuthor);
?>
Sebenarnya tutorialnya sudah saya buat dan saya upload di youtube, sehingga anda tinggal menonton saja. Mungkin tutorialnya masih biasa saja yang penting bisa membantu kita belajar. Ada 5 buah tutorial yang kami suguhkan secara berurutan. Berikut linknya silakan di tonton.
Tidak ada komentar:
Posting Komentar