Advertisement
GWibisono

silakan coba

Mar 19th, 2016
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. //require_once "core/init.php";  
  3. function tampilkan(){
  4.  
  5.     $query = "SELECT * FROM blog order by waktu DESC";
  6.     return result($query);
  7. }
  8.  
  9. function tampilkan_per_id($id){
  10.  
  11.     $query = "SELECT * FROM blog WHERE id=$id";
  12.     return result($query);
  13. }
  14.  
  15. function hasil_cari($cari){
  16.     $query = "SELECT * FROM blog WHERE isi LIKE '%$cari%'";
  17.     return result($query);
  18.  
  19. }
  20.  
  21. function result($query){
  22.     global $link;
  23.     $result= mysqli_query($link, $query);
  24.     if ($result ){
  25.         return $result;
  26.     }else{
  27.          or die ('gagal :'.mysqli_error()."<br/>".$sql);
  28.         return false;
  29.     }
  30.  
  31.  
  32. }
  33.  
  34. function tambah_data($judul, $konten , $tag){
  35.     $query = "INSERT INTO blog(judul, isi , tag) VALUES ('$judul', '$konten' , '$tag')";
  36.     return run($query);
  37.  
  38. }
  39.  
  40. function edit_data($judul, $konten, $tag, $id){
  41.     $query = "UPDATE blog SET judul='$judul', isi='$konten', tag='$tag'WHERE id=$id";
  42.     return run($query);
  43.  
  44. }
  45.  
  46. function hapus_data($id){
  47.     $query = "DELETE FROM blog WHERE id=$id";
  48.     return run($query);
  49.  
  50. }
  51.  
  52. function run($query){
  53.     global $link;
  54.  
  55.     if(mysqli_query($link, $query)) return true;
  56.     else return false;
  57.         # code...
  58.    
  59. }
  60.  
  61. function excerpt($string){
  62.     $string = substr($string, 0, 10);
  63.     return $string . "....";
  64. }
  65. //==============================================
  66. require_once "view/header.php";
  67.  
  68.  
  69. $articles = tampilkan();
  70.  
  71.  
  72. if (isset($_GET['cari'])) {
  73.     $cari     = $_GET['cari'];
  74.     $articles = hasil_cari($cari);
  75.     # code...
  76. }
  77.  
  78. ?>
  79.  
  80. <form action="" method="get">
  81. <input type="search" name="cari" placeholder="Search">
  82.    
  83. </form>
  84.  
  85.   <nav class="black " role="navigation">
  86.     <div class="nav-wrapper container">
  87.       <a id="logo-container" href="#" class="brand-logo">Logo</a>
  88.       <ul class="right hide-on-med-and-down">
  89.         <li><a href="index.php">Home</a></li>
  90.          </ul>
  91.  
  92.       <ul id="nav-mobile" class="side-nav">
  93.         <li><a href="index.php">Home</a></li>
  94.       </ul>
  95.       <a href="" data-activates="nav-mobile" class="button-collapse"><i class="material-icons">Content</i></a>
  96.     </div>
  97.   </nav>
  98.  
  99.  
  100. <?php
  101. while($row=mysqli_fetch_assoc($articles)):  ?>
  102.  
  103. <div class="each_article">
  104.     <h3><a href="single.php?id=<?php echo $row['id'];?>"><?php echo $row['judul']; ?></a></h3>
  105.         <p>
  106.             <?php echo excerpt($row['isi']); ?>
  107.         </p>
  108.         <p class="waktu">Post : <?php echo $row['waktu']; ?></p>
  109.         <p class="tag"> Tag : <?php echo $row['tag']; ?></p>
  110.         <a href="edit.php?id=<?php echo  $row['id']; ?>">Edit</a>
  111.         <a href="delete.php?id=<?php echo  $row['id']; ?>">Delete</a>
  112.  
  113. </div>
  114. <?php endwhile; ?>
  115.  
  116.  
  117. <?php
  118. require_once "view/footer.php";
  119. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement