Advertisement
GWibisono

fix

Aug 3rd, 2016
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.      include 'bd/blocks/bd.php';
  3.      $result = mysqli_query($db,"SELECT keywords,description,author FROM page WHERE page='blog'");
  4.      $myrow = mysqli_fetch_array($result);
  5. if(isset($_GET['date']) ){ //&& !empty($_GET['date'])
  6.     $date = $_GET['date'];
  7. }
  8. /*
  9. elseif (!isset($_GET['date']) && empty($_GET['date'])) {
  10.     header("Location: index.php");
  11.     exit;
  12. }*/
  13. else{
  14. //  header("Location: index.php");
  15.     echo("<script>location.href = 'index.php';</script>");
  16.     exit;
  17. }
  18. //$date= "$date";
  19. //$dates=substr($date,0,7);
  20. $dates= date("Y-m", strtotime($date));
  21. $sql="SELECT count(date) c FROM blog WHERE date='$dates' ";
  22. $sql="SELECT count(date) c FROM blog WHERE date like '{$dates}%' ";
  23.  
  24. $result2 = mysqli_query($db,$sql);
  25. //since the data contain month-year.. you should use other name for this fieldname.
  26.  
  27. $res=mysqli_fetch_array($result2);
  28. if($res['c']==0){
  29.     echo("<script>alert('no blog found'); location.href = 'index.php';</script>");
  30.     exit;
  31. }
  32. /*
  33. echo mysqli_num_rows($result2);
  34. if(mysqli_num_rows($result2)){
  35.  header("Location: index.php");
  36.     exit;
  37. }
  38. */
  39.      $date_title=$date;
  40.      $date_begin =$date;
  41.      $date++;
  42.      $date_end=$date;
  43.      $date_begin=$date_begin.'-00';
  44.      $date_end=$date_end.'-00';
  45.  ?>
  46. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  47. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">  
  48.     <head>
  49.         <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  50.         <meta http-equiv="Content-Language" content="en" />
  51.         <meta name="description" content="<?php echo $myrow['description']; ?>" />
  52.         <meta name="keywords" content="<?php echo $myrow['keywords']; ?>" />
  53.         <meta name="author" content="<?php echo $myrow['author']; ?>" />
  54.         <title><?php echo 'archive for '. $date_title .'';?></title>
  55.     <!-- HEADER -->
  56.         <?php include 'bd/blocks/head.php'; ?>
  57.         <!--ENDS HEADER -->
  58.     </head>
  59.     <body>
  60.     <!-- WRAPPER -->
  61.     <div id="wrapper">
  62.    
  63.    
  64.    
  65.     <!-- navigation & HEADER -->
  66.     <?php include 'bd/blocks/header.php'; ?>
  67.     <!-- ENDS navigation & HEADER-->   
  68.     <!-- MAIN -->
  69.     <div id="main">
  70.        
  71.    
  72.     <!-- posts -->
  73.     <div id="posts">
  74.        
  75.         <!-- single-post -->
  76.     <?php
  77.     $sql="SELECT id,text,author,view,img,choose,title,date FROM blog WHERE date > '$date_begin' AND date < '$date_end' ORDER BY id DESC";
  78.        $result = mysqli_query($db,$sql);
  79.         while($myrow = mysqli_fetch_array($result)){
  80.          $let55=explode(" ",$myrow["text"]);
  81.          $me=0;
  82.          $newtxt="";
  83.          while($me<55){
  84.              $newtxt.="".$let55[$me]." ";
  85.              $me+=1;
  86. }
  87.                           printf('
  88.         <div class="post">
  89.             <p class="post-title custom">%s</p>
  90.             <p class="post-meta">%s <span>by %s</span></p>
  91.             <p class="post-comments custom">%s</p><br><br>
  92.             <div class="%s-img"><a href="single.php?id=%s"><img src="%s" alt="" widht="610" height="230"/></a><span></span></div>
  93.             <p class="brief">%s...</p>
  94.             <p><a href="single.php?id=%s" class="more">More</a></p>
  95.         </div>',$myrow["title"] , $myrow["date"] , $myrow["author"] ,$myrow["view"] ,$myrow["choose"] , $myrow["id"]  ,  $myrow["img"] , $newtxt , $myrow["id"]);}
  96.     ?>
  97.         <!-- ENDS single-post -->
  98.        
  99.         <!-- blog-pager -->
  100.         <ul class="blog-pager">
  101.             <li><a href="#">NEWER</a></li>
  102.             <li><a href="#">OLDER</a></li>
  103.         </ul>
  104.         <!-- ENDS blog-pager -->
  105.            
  106.            
  107.        
  108.     </div>
  109.     <!-- ENDS posts -->
  110.    
  111.     <!-- sidebar -->
  112.         <?php include 'bd/blocks/side-block.php'; ?>
  113.         <!-- ENDS sidebar -->
  114.  
  115.  
  116.         </div>
  117.         <!-- ENDS sidebar -->
  118.    
  119.        
  120.        
  121.     </div>
  122.     <!-- ENDS MAIN -->
  123.    
  124.     </div>
  125.     <!-- ENDS WRAPPER -->
  126.    
  127.    
  128.    
  129.     <!-- FOOTER -->
  130.     <?php include 'bd/blocks/footer.php'; ?>
  131.     <!-- ENDS FOOTER -->
  132.     </body>
  133. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement