API tools faq
paste
joris

Data Grouping

joris
Jun 1st, 2012
152
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.94 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include "penjaga.php";
  4. require_once("config/koneksi.php");
  5. $waktu         = date("Y-m-d H:i:s");
  6.  
  7.  if(isset($_POST['save']))
  8. {
  9.          $id    =addslashes(strip_tags($_POST['id']));
  10.          $hal   =addslashes(strip_tags($_POST['hal']));
  11.          $informasi =addslashes(strip_tags($_POST['informasi']));
  12.          $nama      =$_SESSION['nama'];
  13.  
  14.  
  15.  //
  16.  $inputan="insert into informasi(hal,informasi,nama,tanggal) values('$hal','$informasi','$nama','$waktu')";
  17.  $query=mysql_query($inputan);
  18.  if($query)
  19.  {
  20.          ?>
  21.             <script language="javascript">
  22.             alert ("Berhasil Menambahkan Informasi");
  23.             document.location="user.php?page=AddInformation";
  24.             </script>
  25.          <?
  26.  }
  27.  else
  28.  {
  29.         ?>
  30.             <script language="javascript">
  31.             alert ("Gagal Menambahkan Informasi");
  32.             document.location="user.php?page=AddInformation";
  33.             </script>
  34.          <?
  35.  }
  36. }
  37. //delete
  38. if(isset($_GET['hapus']))
  39. {
  40.  $id    = $_GET['hapus'];
  41.  $del       = mysql_query("DELETE FROM informasi WHERE id='$id'");
  42.  if($del)
  43.   {
  44.            ?>
  45.             <script language="javascript">
  46.             alert ("Berhasil Hapus Data");
  47.             document.location="user.php?page=AddInformation";
  48.             </script>
  49.            <?    
  50.   }
  51.  else
  52.   {
  53.            ?>
  54.             <script language="javascript">
  55.             alert ("Gagal Hapus Data");
  56.             document.location="user.php?page=AddInformation";
  57.             </script>
  58.            <?
  59.   }
  60. }
  61. ?>
  62. <html>
  63. <head>
  64. <link type="text/css" rel="stylesheet" href="css/fb-1.css" />
  65. <link type="text/css" rel="stylesheet" href="css/fb-3.css" />
  66. <link type="text/css" rel="stylesheet" href="css/warna.css" />
  67.  
  68. <script language="javascript">
  69. function validasi(form){
  70.   if (form.hal.value == ""){
  71.     alert("Anda belum mengisikan judul informasi");
  72.     form.hal.focus();
  73.     return (false);
  74.   }
  75.      
  76.   if (form.informasi.value == ""){
  77.     alert("Anda belum mengisikan detail informasi");
  78.     form.informasi.focus();
  79.     return (false);
  80.   }
  81.   return (true);
  82. }
  83. </script>
  84.  
  85. </head>
  86. <body>
  87. <fieldset style="padding-left:10px;padding-right:10px;" class="uiBoxLightblue">
  88. <legend>Information From User</legend>
  89. <form action="" method="post" onSubmit="return validasi(this)">
  90. <table width="660" border="0" align="center" >
  91.  
  92. <tr>
  93.  <td width="110">Name</td>
  94.  <td width="3">:</td>
  95.  <td width="533"><input type="text" class="inputtext" value="<? echo $_SESSION['nama']; ?>" readonly>
  96.  &lt;&lt; Terisi secara otomatis oleh sistem dan tidak bisa diubah</td>
  97. </tr>
  98. <tr>
  99.  <td width="110">About</td>
  100.  <td width="3">:</td>
  101.  <td width="533"><input name="hal" type="text" id="hal" class="inputtext" autocomplete="off"></td>
  102. </tr>
  103. <tr>
  104.  <td>Information</td>
  105.  <td>:</td>
  106.  <td><textarea name="informasi" cols="92" rows="3" id="informasi"  autocomplete="off"></textarea></td>
  107. </tr>
  108. <tr>
  109.  <td></td>
  110.  <td></td>
  111.  <td><input type="submit" name="save" value="Saving All Data" class="uibutton confirm">
  112.  <input type="reset" value="Reset" class="uibutton"></td>
  113. </tr>
  114. </table>
  115. </form>
  116. <br>
  117. </fieldset>
  118. <div>Note : Untuk icon <img src="images/icon/check.png" width="16" height="16"> fungsinya untuk melakukan <span class="style4">EDIT DATA</span>. Sedangkan untuk icon <img src="images/icon/close.png" width="16" height="16"> fungsinya untuk <span class="style4">HAPUS DATA</span></div>
  119. <br>
  120. <fieldset class="fontstandar" >
  121. <legend  >List Information </legend>
  122.  
  123. <table width="770" align="center" class="fontstandar">
  124. <tr bgcolor="#eeeeee" align="center" >
  125.  <td width="20"><strong>No</strong></td>
  126.   <td width="116"><strong>Sender</strong></td>
  127.  
  128.  <td width="306"><strong>Information</strong></td>
  129.  <td width="77"><strong>About</strong></td>
  130.  <td width="90"><strong>Date </strong></td>
  131.  <td width="63"><strong>Action </strong></td>
  132. </tr>
  133. <?php
  134.  
  135.  $query     = "SELECT * FROM informasi where nama='".$_SESSION['nama']."' order by id desc";
  136.  require_once("pagging.inc.php");
  137.  $pg = new Pagging("user.php?page=AddInformation");
  138.  $pg->totalRecordPage = 5;
  139.  $pg->setSQL($query);
  140.  
  141.  foreach($pg->data as $hsl) {
  142.  $id            = $hsl['id'];
  143.  $hal           = $hsl['hal'];
  144.  $informasi     = $hsl['informasi'];
  145.  $nama          = $hsl['nama'];
  146.  $tanggal       = $hsl['tanggal'];
  147.  $FormatWaktu       = date("d-m-Y h:i:s A", strtotime($tanggal));
  148.  ?>
  149. <tr  class="jenis" bgcolor="#006600" align="center">
  150. <td bgcolor="#FFFFCC">        <?=++$pg->indexNumber ?></td>
  151. <td bgcolor="#FFFFCC">      <?=$nama?></td>
  152. <td bgcolor="#FFFFCC">        <?=$hal?> </td>
  153. <td align="justify" bgcolor="#FFFFCC"><div style="width:400px;word-wrap:break-word;"><?=$informasi?></div> </td>
  154.  
  155. <td bgcolor="#FFFFCC">      <?=$FormatWaktu?></td>
  156.  
  157. <td bgcolor="#FFFFCC">
  158. <a href="user.php?page=EditInformation&id=<?=$id?>" class="mouse"><img src="images/icon/check.png" width="16" height="16" border=0 align="middle"></a> ||
  159. <a href="user.php?page=AddInformation&hapus=<?=$id?>"  class="mouse"><img src="images/icon/close.png" width="16" height="16" border=0 align="middle"></a>
  160. </td>
  161. </tr>       <?  } ?>
  162. <tr class="jenis">
  163.  <td colspan="6" ><? echo implode(" ",$pg->navigator); ?></td>
  164. </tr>
  165. </table>
  166. </fieldset>
  167. </body>
  168. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!