Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //require_once "core/init.php";
- function tampilkan(){
- $query = "SELECT * FROM blog order by waktu DESC";
- return result($query);
- }
- function tampilkan_per_id($id){
- $query = "SELECT * FROM blog WHERE id=$id";
- return result($query);
- }
- function hasil_cari($cari){
- $query = "SELECT * FROM blog WHERE isi LIKE '%$cari%'";
- return result($query);
- }
- function result($query){
- global $link;
- $result= mysqli_query($link, $query);
- if ($result ){
- return $result;
- }else{
- or die ('gagal :'.mysqli_error()."<br/>".$sql);
- return false;
- }
- }
- function tambah_data($judul, $konten , $tag){
- $query = "INSERT INTO blog(judul, isi , tag) VALUES ('$judul', '$konten' , '$tag')";
- return run($query);
- }
- function edit_data($judul, $konten, $tag, $id){
- $query = "UPDATE blog SET judul='$judul', isi='$konten', tag='$tag'WHERE id=$id";
- return run($query);
- }
- function hapus_data($id){
- $query = "DELETE FROM blog WHERE id=$id";
- return run($query);
- }
- function run($query){
- global $link;
- if(mysqli_query($link, $query)) return true;
- else return false;
- # code...
- }
- function excerpt($string){
- $string = substr($string, 0, 10);
- return $string . "....";
- }
- //==============================================
- require_once "view/header.php";
- $articles = tampilkan();
- if (isset($_GET['cari'])) {
- $cari = $_GET['cari'];
- $articles = hasil_cari($cari);
- # code...
- }
- ?>
- <form action="" method="get">
- <input type="search" name="cari" placeholder="Search">
- </form>
- <nav class="black " role="navigation">
- <div class="nav-wrapper container">
- <a id="logo-container" href="#" class="brand-logo">Logo</a>
- <ul class="right hide-on-med-and-down">
- <li><a href="index.php">Home</a></li>
- </ul>
- <ul id="nav-mobile" class="side-nav">
- <li><a href="index.php">Home</a></li>
- </ul>
- <a href="" data-activates="nav-mobile" class="button-collapse"><i class="material-icons">Content</i></a>
- </div>
- </nav>
- <?php
- while($row=mysqli_fetch_assoc($articles)): ?>
- <div class="each_article">
- <h3><a href="single.php?id=<?php echo $row['id'];?>"><?php echo $row['judul']; ?></a></h3>
- <p>
- <?php echo excerpt($row['isi']); ?>
- </p>
- <p class="waktu">Post : <?php echo $row['waktu']; ?></p>
- <p class="tag"> Tag : <?php echo $row['tag']; ?></p>
- <a href="edit.php?id=<?php echo $row['id']; ?>">Edit</a>
- <a href="delete.php?id=<?php echo $row['id']; ?>">Delete</a>
- </div>
- <?php endwhile; ?>
- <?php
- require_once "view/footer.php";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement