What's your favorite spice? Use the search box to see what we think about it!

Most popular post:

"; $sqlspopular = "SELECT * FROM posts JOIN user ON user_id = posts.post_author_id WHERE post_status = :status AND post_visibility <= :visibility ORDER BY post_views DESC, post_date DESC LIMIT 0, 3"; $stmt = $pdo->prepare($sqlspopular); $searchbase = 'index.html?page='; $stmt->execute([ ':status'=>'published', ':visibility' => $user_can_see ]); $post = $stmt->fetch(PDO::FETCH_ASSOC); $post_id = $post['post_id']; $post_title = $post['post_title']; $post_detail = $post['post_detail']; $post_author = $post['user_nickname']; $post_date = formatSqlTime($post['post_date'], $tbFormat); $post_image = $post['post_image']; $post_user_photo = $post['user_photo']; include('./includes/display_popular.php'); ?>

Recent posts:

prepare($sqlrecent); $stmt->execute([ ':status'=>'published', ':visibility'=>$user_can_see ]); $total_posts_count = $stmt->rowCount(); if($total_posts_count > 0){ if(isset($_GET['page'])){ $page_nbr = $_GET['page']; }else{ $page_nbr = 1; } $total_pages = ceil($total_posts_count/$posts_to_display); $post_offset = ($page_nbr*$posts_to_display) - $posts_to_display; if($page_links_to_display >= $total_pages ){ $firstpage = 1; $page_links_to_display=$total_pages; }else{ $firstpage = $page_nbr - floor($page_links_to_display/2); } if($firstpage <1){ $firstpage = 1; } $lastpage = $firstpage + $page_links_to_display; if($lastpage >= $total_pages){ $lastpage = $total_pages; $firstpage = $total_pages - $page_links_to_display + 1; } // echo "var check tp = $total_pages fp = $firstpage lp = $lastpage tl = $page_links_to_display
"; }else{ $count_msg = "No results found"; } // end collection $sql = "SELECT * FROM posts JOIN user ON user_id = posts.post_author_id WHERE post_status = :status AND post_visibility <= :visibility ORDER BY post_id DESC LIMIT $post_offset, $posts_to_display"; $stmt = $pdo->prepare($sql); $stmt->execute([ ':status' => 'Published', ':visibility'=> $user_can_see ]); while($posts = $stmt->fetch(PDO::FETCH_ASSOC)) { $post_id = $posts['post_id']; $post_title = $posts['post_title']; $post_detail = truncate($posts['post_detail']); $post_image = $posts['post_image']; $post_user_photo = $posts['user_photo']; $post_date = $posts['post_date']; $post_author = $posts['user_nickname']; $post_views = $posts['post_views']; ?>

$posts_to_display){ ?>

0 ?>

Most viewed posts:

prepare($sqltopviews); $stmt->execute([ ':status' => 'published', ':visibility'=>$user_can_see ]); while($posts = $stmt->fetch(PDO::FETCH_ASSOC)) { $post_id = $posts['post_id']; $post_title = $posts['post_title']; $post_detail = truncate($posts['post_detail']); $post_image = $posts['post_image']; $post_user_photo = $posts['user_photo']; $post_date = formatSqlTime($posts['post_date'], $tbFormat); $post_author = $posts['user_nickname']; $post_views = $posts['post_views']; ?>

Browse by categories:

prepare($sqlcategories); $stmt->execute([ ':stat1' => 'Published', ':stat2' => 'published', ':visibility' => $user_can_see ]); while($categories = $stmt->fetch(PDO::FETCH_ASSOC)) { // print_r($categories); $category_id = $categories['category_id']; $category_title = $categories['category_name']; $total_posts = $categories['total_posts']; ?>

Posts