<div class="col-xs-12 col-sm-3 text-center">
<h2>Popularity</h2>
<?php
sidebar();
//sidebarランキング関数呼び出し
foreach ($results as $row) {
h_insert($row);
//変数代入関数呼び出し
echo '<a href="news.php?id=' . $news_id . '">';
echo '<div class="htumbnail text-center">';
echo '<img src="img/' . $img . '" height="100" width="150" class="img-rounded">';
echo '<div class="caption">';
category_icon($category_id);
//カテゴリーアイコン表示関数呼び出し
echo '<p>' . $news_title . '</p></div></div></a>';
}
?>
</div>
function news_view()
{
global $results, $update_date, $news_id, $news_title, $news_detail, $category_id, $category_name, $img, $alt;
if (isset($_GET["id"])) {
$news_id = $_GET["id"];
//人気記事カウントアップ
$sql = "INSERT INTO click_count(count_id,news_id, click_date) VALUES (NULL, '" . $news_id . "', sysdate())";
db_start($sql);
//記事詳細表示
$sql = "SELECT * FROM news,category,img where news.news_id = {$news_id} AND show_flg = 1 AND news.category_id = category.category_id AND news.news_id = img.news_id";
//db関数呼び出し
db_start($sql);
echo '<div class="col-xs-12 col-sm-9">';
foreach ($results as $row) {
//変数代入関数呼び出し
h_insert($row);
echo '<div class="thumbnail"><img class="img-responsive" src="img/' . $img . '"><div class="caption"><h2>' . $news_title . '</h2><p>';
echo date('Y/m/d', strtotime($update_date));
category_icon($category_id);
echo '</p><p class="kiji">' . $news_detail . '</p></div></div>';
echo '<div class="text-right"><a href="news.php"><button class="btn btn-default">ニュース一覧</button></a></div>';
}
echo '</div>';
} else {
$sql = "SELECT * FROM news,category,img where show_flg = 1 AND news.category_id = category.category_id AND news.news_id = img.news_id";
db_start($sql);
echo '<div class="col-xs-12 col-sm-9">';
foreach ($results as $row) {
//変数代入関数呼び出し
h_insert($row);
echo '<a href="news.php?id=' . $news_id . '"><div class="thumbnail"><img width="250" height="150" src="img/' . $img . '">';
echo '<div class="caption"><h2>';
echo mb_substr($news_title, 0, 50) . '</h2><p>';
echo date('Y/m/d', strtotime($update_date));
category_icon($category_id);
echo '</p></div></div></a>';
}
echo '</div>';
}
$pdo = null;
}