$poem_id = $vars[1];
//--for poem id not found in poems table--//
if (!check_poem($database, $poem_id)) {
echo $tpl->render("themes/site/" . theme_name . "/html/404.php");
exit;
}
foreach ($vars as $var) {
if (strpos($var, 'p:') === 0) {
$page_no_var = $var;
//get the current Page from URL
}
}
//--increment views of poem--//
$update_poem = view_increment($database, $poem_id);
//--get poem information--//
$get_poem = get_poem($database, $poem_id);
//--get topic information--//
if ($get_poem['topic_id']) {
$poem_topics_array = array();
//get topic ids as array
$poem_topics = unserialize($get_poem['topic_id']);
foreach ($poem_topics as $poem_topic_id) {
if (!array_key_exists($poem_topic_id, $poem_topics_array)) {
$poem_topic_array[$poem_topic_id] = get_topic($database, $poem_topic_id);
}
}
$get_poem['topic_id'] = $poem_topic_array;
}
//--get author information--//
// $author_id = $get_poem['author_id'];
// if($get_poem['author_id']){
$popular_users = $get_popular['users'];
if (!empty($popular_users)) {
$users_info = array();
foreach ($popular_users as $users_id) {
$data = get_user_info($database, $users_id);
$users_info[] = $data[0];
}
#print_r($users_info);
foreach ($users_info as $key => $v) {
$rating = avg_rating("users", $v['id'], $database);
$users_info[$key]['rating'] = $rating;
}
$users_info = sortMultiArrayByKey($users_info, "rating");
#print_r($users_info);
$tpl->popular_users = $users_info;
}
$popular_poems = $get_popular['poems'];
if (!empty($popular_poems)) {
$poem_info = array();
foreach ($popular_poems as $poem_id) {
$poem_info[] = get_poem($database, $poem_id);
}
foreach ($poem_info as $key => $v) {
$rating = avg_rating("poems", $v['id'], $database);
$poem_info[$key]['rating'] = $rating;
}
$poem_info = sortMultiArrayByKey($poem_info, "rating");
$tpl->popular_poems = $poem_info;
#print_r($poem_info);
}
echo $tpl->render("themes/site/" . theme_name . "/html/index.php");
<?php
//ini_set("display_errors",1);
require_once 'inc/inc.php';
require_once 'func/func_reg.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (isset($_POST['poem_id'])) {
$poem = get_poem($db, $_POST['poem_id']);
echo json_encode($poem);
}
}
if (!empty($get_user_given_ratings['users'])) {
foreach ($get_user_given_ratings['users'] as $k => $user_given_rating) {
$data = get_user_info($database, $user_given_rating['id']);
$get_user_given_ratings['users']['users'][] = $data[0];
}
}
$tpl->get_users = $get_user_given_ratings['users'];
//pr($tpl->get_users);exit;
//--get poem saved by user--//
$get_saved = saved_poems($database, $user_id);
$get_saved_poems = $get_saved['poems'];
$get_saved_poets = $get_saved['author'];
$get_saved_user = $get_saved['users'];
if (!empty($get_saved_poems)) {
foreach ($get_saved_poems as $k => $poem_id) {
$get_saved_poems[$k] = get_poem($database, $poem_id);
}
$tpl->saved_poems = $get_saved_poems;
}
//--get saved poets--//
if (!empty($get_saved_poets)) {
foreach ($get_saved_poets as $k => $poet_id) {
$get_saved_poets[$k] = get_author($database, $poet_id);
}
$tpl->saved_poets = $get_saved_poets;
}
//--get saved users--//
if (!empty($get_saved_user)) {
foreach ($get_saved_user as $k => $poet_id) {
$data = get_user_info($database, $poet_id);
$get_saved_user[$k] = $data[0];
$current_count = $get_topic_poems['present_count'];
$page_array = array();
$page_array['current_page'] = $paginate['page_no'];
$page_array['total_pages'] = $total_pages;
$page_array['total_records'] = $count_records;
$page_array['current_count'] = $current_count;
$page_array['param_vars'] = $vars;
$page_array['page_no_var'] = $page_no_var;
$tpl->page_array = $page_array;
//--get poem data--//
if (!empty($get_topic_poems['data'])) {
$topic_poems_info = array();
//get poems information for each poem received
foreach ($get_topic_poems['data'] as $poem_id) {
if (check_poem($database, $poem_id)) {
$topic_poems_info[] = get_poem($database, $poem_id);
}
}
}
$tpl->topic_poems_info = $topic_poems_info;
//--get all topics and count poem of topic--//
$get_sidebar_topics = all_topic($database);
//--count sidebar topics poems--//
if (!empty($get_sidebar_topics)) {
foreach ($get_sidebar_topics as $key => $sidebar_topic) {
$sidebar_topic_id = $sidebar_topic['topic_id'];
$get_sidebar_topics[$key]['poems_count'] = get_topic_poems($database, $sidebar_topic_id, array("ONLYCOUNT" => TRUE));
}
}
$tpl->sidebar_topics = $get_sidebar_topics;
// Send SEO Data
