<?php require_once('Connections/jie.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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 komentar (tgl_masuk, nama, email, komentar, photo) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString(date('l, d F Y h:i:s A'), "text"),
                       GetSQLValueString($_POST['nama'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['komentar'], "text"),
                       GetSQLValueString($_FILES['photo']['name'], "text"));

  mysql_select_db($database_jie, $jie);
  $Result1 = mysql_query($insertSQL, $jie) or die(mysql_error());
  copy($HTTP_POST_FILES['photo']['tmp_name'],'gambar/'.$_FILES['photo']['name']);
}

$colname_rskomentar = "-1";
if (isset($_GET['id_komentar'])) {
  $colname_rskomentar = (get_magic_quotes_gpc()) ? $_GET['id_komentar'] : addslashes($_GET['id_komentar']);
}
mysql_select_db($database_jie, $jie);
$query_rskomentar = sprintf("SELECT * FROM komentar WHERE id_komentar = %s", $colname_rskomentar);
$rskomentar = mysql_query($query_rskomentar, $jie) or die(mysql_error());
$row_rskomentar = mysql_fetch_assoc($rskomentar);
$totalRows_rskomentar = mysql_num_rows($rskomentar);

mysql_select_db($database_jie, $jie);
$query_rstampilkomentar = "SELECT * FROM komentar";
$rstampilkomentar = mysql_query($query_rstampilkomentar, $jie) or die(mysql_error());
$row_rstampilkomentar = mysql_fetch_assoc($rstampilkomentar);
$totalRows_rstampilkomentar = mysql_num_rows($rstampilkomentar);
?><!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=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/JavaScript">
<!--
function mmLoadMenus() {
  if (window.mm_menu_0217094228_0) return;
  window.mm_menu_0217094228_0 = new Menu("root",188,21,"Times New Roman, Times, serif",15,"#3333CC","#993333","#9933FF","#009933","left","middle",3,0,1000,-5,7,true,false,true,0,true,true);
  mm_menu_0217094228_0.addMenuItem("sejarah","location='sejarah.php'");
  mm_menu_0217094228_0.addMenuItem("visi&nbsp;dan&nbsp;misi","location='visi.php'");
  mm_menu_0217094228_0.addMenuItem("struktur&nbsp;organisasi","location='struktur.php'");
  mm_menu_0217094228_0.addMenuItem("fungsi&nbsp;dan&nbsp;tanggung&nbsp;jawab","location='fungsi.php'");
  mm_menu_0217094228_0.addMenuItem("makna&nbsp;logo","location='makna.php'");
   mm_menu_0217094228_0.fontStyle="italic";
   mm_menu_0217094228_0.hideOnMouseOut=true;
   mm_menu_0217094228_0.bgColor='#555555';
   mm_menu_0217094228_0.menuBorder=1;
   mm_menu_0217094228_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0217094228_0.menuBorderBgColor='#777777';

        window.mm_menu_0217094430_0 = new Menu("root",188,23,"Times New Roman, Times, serif",15,"#FFFFFF","#993333","#9933FF","#009933","left","middle",4,4,1000,-5,7,true,true,true,0,true,true);
  mm_menu_0217094430_0.addMenuItem("sejarah&nbsp;","location='sejarah.php'");
  mm_menu_0217094430_0.addMenuItem("visi&nbsp;dan&nbsp;misi","location='visi.php'");
  mm_menu_0217094430_0.addMenuItem("struktur&nbsp;organisasi","location='struktur.php'");
  mm_menu_0217094430_0.addMenuItem("fungsi&nbsp;dan&nbsp;tanggung&nbsp;jawab","location='fungsi.php'");
  mm_menu_0217094430_0.addMenuItem("makna&nbsp;logo","location='makna.php'");
   mm_menu_0217094430_0.fontStyle="italic";
   mm_menu_0217094430_0.hideOnMouseOut=true;
   mm_menu_0217094430_0.bgColor='#00CC00';
   mm_menu_0217094430_0.menuBorder=2;
   mm_menu_0217094430_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0217094430_0.menuBorderBgColor='#003300';

mm_menu_0217094430_0.writeMenus();
} // mmLoadMenus()

function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<style type="text/css">
<!--
.style23 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; color: #009900; }
.style24 {font-weight: bold}
.style25 {font-size: 10px}
body {
	background-image: url(gambar/pasti-pas-pertamina%5B1%5D.jpg);
}
.style30 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; color: #009900; font-size: 36px; }
.style32 {
	font-weight: bold;
	color: #0033FF;
	font-size: 16px;
}
.style33 {
	color: #99CC00;
	font-weight: bold;
}
.style36 {font-size: 36px}
-->
</style>
<script language="JavaScript" src="mm_menu.js"></script>
</head>

<body onload="MM_preloadImages('images/tombol2_01.gif','images/tombol2_02.gif','images/tombol2_03.gif','images/tombol2_04.gif','images/tombol2_05.gif','images/tombol2_06.gif')">
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="826" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#00FF00">
  <tr>
    <td height="200" colspan="2"><img src="ATAS-PUJIE.gif" width="820" height="200" /></td>
  </tr>
  <tr>
    <td height="30" colspan="2"><a href="home.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image2','','images/tombol2_01.gif',1)"><img src="images/tombol1_01.gif" name="Image2" width="93" height="30" border="0" id="Image2" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','images/tombol2_02.gif',1)"><img src="images/tombol1_02.gif" name="Image3" width="112" height="30" border="0" id="Image3" onmouseover="MM_showMenu(window.mm_menu_0217094430_0,0,30,null,'Image3')" onmouseout="MM_startTimeout();" /></a><a href="galery.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','images/tombol2_03.gif',1)"><img src="images/tombol1_03.gif" name="Image4" width="116" height="30" border="0" id="Image4" /></a><a href="download.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','images/tombol2_04.gif',1)"><img src="images/tombol1_04.gif" name="Image5" width="136" height="30" border="0" id="Image5" /></a><a href="bukutamu.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','images/tombol2_05.gif',1)"><img src="images/tombol1_05.gif" name="Image6" width="146" height="30" border="0" id="Image6" /></a><a href="kontakkami.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image7','','images/tombol2_06.gif',1)"><img src="images/tombol1_06.gif" name="Image7" width="165" height="30" border="0" id="Image7" /><img src="images/tombol1_07.jpg" width="52" height="30" border="0" /></a></td>
  </tr>
  <tr>
    <td width="563" height="220" align="center" valign="top" bordercolor="#006600" bgcolor="#AA9F00" class="style30">
   
    <marquee>Selamat Datang di Web Site Kami.... 
    </marquee></td>
    <td width="256" valign="top" bgcolor="#CCFF66"><p class="style33"><blink>
      <div align="center"><span class="style36"><blink>Komentar : </blink></span></div>
    </blink></p>
        <hr />
        <p class="style32"><blink>Apa menurut anda tentang web saya..??</blink> </p>
      <form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" name="form1">
          <?php do { ?>
            <table width="200" align="center">
              <tr valign="baseline">
                <td width="3" align="right" nowrap>&nbsp;</td>
                <td width="185"><span class="style23">Nama : <br />
                      <input type="text" name="nama" value="" size="20" />
                </span></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right">&nbsp;</td>
                <td><span class="style23">Email : <br />
                      <input type="text" name="email" value="" size="20" />
                </span></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right" valign="top">&nbsp;</td>
                <td><span class="style23">Komentar : <br />
                      <textarea name="komentar" cols="20" rows="5"></textarea>
                                  </span></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right">:</td>
                <td><span class="style23">Photo : <br />
                      <input name="photo" type="file" class="style24" size="15" />
                </span></td>
              </tr>
              <tr valign="baseline">
                <td nowrap align="right">&nbsp;</td>
                <td><input type="submit" class="style23" value="posting" /></td>
              </tr>
          </table>
            <?php } while ($row_rskomentar = mysql_fetch_assoc($rskomentar)); ?>
        <input type="hidden" name="tgl_masuk" value="" />
          <input type="hidden" name="MM_insert" value="form1" />
      </form>
      <p>&nbsp;</p>
      <?php do { ?>
        <table width="256" border="2" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="68" rowspan="4"><img src="gambar/<?php echo $row_rstampilkomentar['photo']; ?>" width="68" /></td>
            <td width="180" bgcolor="#00FFFF"><strong><?php echo $row_rstampilkomentar['nama']; ?></strong></td>
          </tr>
          <tr>
            <td bgcolor="#00FFFF"><em><?php echo $row_rstampilkomentar['email']; ?></em></td>
          </tr>
          <tr>
            <td bgcolor="#00FFFF"><span class="style25"><?php echo $row_rstampilkomentar['tgl_masuk']; ?></span></td>
          </tr>
          <tr>
            <td bgcolor="#00FFFF"><?php echo $row_rstampilkomentar['komentar']; ?></td>
          </tr>
        </table>
        <br />
        <br />
    <?php } while ($row_rstampilkomentar = mysql_fetch_assoc($rstampilkomentar)); ?><p>&nbsp;</p></td>
  </tr>
  <tr>
    <td height="30" colspan="2" align="center" bgcolor="#009900">Copyright&copy;2011 by:Pujie </td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($rskomentar);

mysql_free_result($rstampilkomentar);
?>
