<?php
include "session.php";
include "config.php";
include "function.php";
// SQLのselect部分
$sqlSelect = "news.news_id,news_title,view.views,category.cat_name";
// SQLのFrom部分
$sqlFrom = "news,view,category";
// SQLのページング部分
$sqlWHERE = " WHERE news.news_cat = category.cat_id AND news.news_id = view.news_id ORDER BY view.views DESC";
//記事総数を取得
//$total = sqlRequest("*","news");
// SQLの実行
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, $sqlPerPage);
$view = "";
$view .= "<table>";
foreach ($results as $row) {
// var_dump($row);
$view .= "<tr>";
$view .= "<td class='wd5'><input type='checkbox' name='check" . $row["news_id"] . "' class='check'></td>";
$view .= "<td class='wd5'><a href='update.php?id=" . $row["news_id"] . "'>" . $row["news_id"] . "</a></td>";
$view .= "<td class='wd25'><a href='update.php?id=" . $row["news_id"] . "'>" . $row["news_title"] . "</a></td>";
$view .= "<td class='wd10'>" . $row["cat_name"] . "</td><td class='wd15'>" . $row["views"] . "</td>";
$view .= "</tr>";
}
// table閉じタグで終了
$view .= "</table>";
// ******* ページの表示設定ここから ********
//$pager = pagerMake($total);
// ******* ページの表示設定ここまで *******
<?php
include "admin/config.php";
include "admin/function.php";
// SQLのselect部分
$sqlSelect = "news_id,news_title,news_detail,news_url,show_flg,category.cat_name,category.cat_slug,DATE_FORMAT(create_date , '%Y.%m.%d') AS create_date,DATE_FORMAT(update_date , '%Y.%m.%d') AS update_date";
// SQLのFrom部分
$sqlFrom = "news,category";
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND show_flg = 1 ORDER BY create_date DESC";
// $sql = "SELECT ". $sqlSelect ." FROM ". $sqlFrom ." ".$sqlWHERE." LIMIT 9";
// $stmt = $pdo->prepare($sql);
// $stmt->execute();
// $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, " LIMIT 9", $bindArray);
$viewMain = "";
$view = "";
foreach ($results as $key => $row) {
// var_dump($row);
if ($key < 3) {
$viewMain .= "<li><a href='single.php?news_id=" . $row["news_id"] . "'><dl><dt>";
$viewMain .= "<img src='admin/files/" . $row["news_url"] . "' alt=''></dt><dd><div class='sub'>";
$viewMain .= "<span class='catIcon " . $row["cat_slug"] . "'>" . $row["cat_name"] . "</span>";
$viewMain .= "<span class='date'>" . $row["create_date"] . "</span></div>";
$viewMain .= "<h2>" . $row["news_title"] . "</h2>";
$viewMain .= "<p class='detail'>" . letter(htmlspecialchars_decode($row["news_detail"]), 100) . "</p>";
$viewMain .= "</dd></dl></a></li>";
} else {
$view .= "<li><a href='single.php?news_id=" . $row["news_id"] . "'>";
$view .= "<span class='catIcon " . $row["cat_slug"] . "'>" . $row["cat_name"] . "</span>";
$view .= "<figure><img src='admin/files/" . $row["news_url"] . "' alt=''></figure>";
$view .= "<div class='itemContent'><p class='title'>" . $row["news_title"] . "</p>";
// -------- 検索した時
$s_title = $_GET["s"];
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND news_title LIKE :search AND news_detail LIKE :search";
$sql = "SELECT " . $sqlSelect . " FROM " . $sqlFrom . " " . $sqlWHERE . " LIMIT " . $offset . "," . PER_PAGE;
$bindArray = array(array('bind' => ':search', 'value' => "%{$s_title}%", 'param' => PDO::PARAM_STR));
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, $sqlPerPage, $bindArray);
$total = sqlRequest("count(*)", $sqlFrom, $sqlWHERE, null, $bindArray);
//パンくず取得
$pankuzu = "検索結果";
} else {
//通常の一覧ページ
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND show_flg = 1";
//$sql = "SELECT ". $sqlSelect ." FROM ". $sqlFrom ." ".$sqlWHERE." LIMIT ".$offset.",". PER_PAGE;
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, $sqlPerPage);
//記事総数を取得
$total = sqlRequest("count(*)", "news");
//パンくず取得
$pankuzu = "一覧ページ";
}
}
//$stmt->execute();
//$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
$view = "";
foreach ($results as $key => $row) {
// var_dump($row);
$view .= "<li><a href='single.php?news_id=" . $row["news_id"] . "'>";
$view .= "<span class='catIcon " . $row["cat_slug"] . "'>" . $row["cat_name"] . "</span>";
$view .= "<figure><img src='admin/files/" . $row["news_url"] . "' alt=''></figure>";
$view .= "<div class='itemContent'><p class='title'>" . $row["news_title"] . "</p>";
$view .= "<p class='date'>" . $row["create_date"] . "</p></div></a></li>";
}
// 他の記事
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND show_flg = 1 AND news.news_cat = " . $cat_id . " AND news.news_id != :id";
$results2 = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, " LIMIT 6", $bindArray);
$view = "";
foreach ($results2 as $key => $row) {
// var_dump($row);
$view .= "<li><a href='single.php?news_id=" . $row["news_id"] . "'>";
$view .= "<span class='catIcon " . $row["cat_slug"] . "'>" . $row["cat_name"] . "</span>";
$view .= "<figure><img src='admin/files/" . $row["news_url"] . "' alt=''></figure>";
$view .= "<div class='itemContent'><p class='title'>" . $row["news_title"] . "</p>";
$view .= "<p class='date'>" . $row["create_date"] . "</p></div></a></li>";
}
$pankuzu = $pdo->query("SELECT cat_name FROM category WHERE category.cat_id = " . $cat_id)->fetchColumn();
//viewを登録更新
$viewWHERE = " WHERE news_id = :id";
$viewTbl = sqlRequest("*", "view", $viewWHERE, null, $bindArray);
if (count($viewTbl) > 0) {
$viewCount = $viewTbl[0]["views"] + 1;
$sql = "UPDATE view set views = '" . $viewCount . "' WHERE news_id = :id";
} else {
$sql = "INSERT INTO view (news_id, views) VALUES (:id, 1) ";
}
$viewstmt = $pdo->prepare($sql);
$viewstmt->bindValue(':id', $id, PDO::PARAM_INT);
$viewstmt->execute();
//********viewを登録更新ここまで********//
$pdo = null;
include "header.php";
?>
<div id="contents">
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND news_title LIKE :title AND news_detail LIKE :detail";
//記事総数を取得
//$sqlPage = "SELECT count(*) FROM ". $sqlFrom ." ".$sqlWHERE;
$bindArray = array(array('bind' => ':title', 'value' => "%{$s_title}%", 'param' => PDO::PARAM_STR), array('bind' => ':detail', 'value' => "%{$s_detail}%", 'param' => PDO::PARAM_STR));
//記事総数を取得
$total = sqlRequest("count(*)", $sqlFrom, $sqlWHERE, null, $bindArray);
} else {
//通常の一覧ページ
$sqlWHERE = " WHERE category.cat_id = news.news_cat";
//記事総数を取得
$total = sqlRequest("count(*)", "news");
}
}
// SQLの実行
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, $sqlPerPage, $bindArray);
$catArray = sqlRequest("*", "category");
$view = "";
$view .= "<table>";
foreach ($results as $row) {
if ($row["show_flg"] == 1) {
$showFlg = "<span class='now'>掲載中</span>";
} else {
$showFlg = "<span>非掲載</span>";
}
// var_dump($row);
$view .= "<tr>";
$view .= "<td class='wd5'><input type='checkbox' name='check" . $row["news_id"] . "' class='check'></td>";
$view .= "<td class='wd5'><a href='update.php?id=" . $row["news_id"] . "'>" . $row["news_id"] . "</a></td>";
$view .= "<td class='wd25'><a href='update.php?id=" . $row["news_id"] . "'>" . $row["news_title"] . "</a></td>";
$view .= "<td class='wd10'>" . $row["cat_name"] . "</td><td class='wd15'>" . $row["create_date"] . "</td>";
$view .= "<td class='wd15'>" . $row["update_date"] . "</td><td class='wd15'>" . $showFlg . "</td>";
$stmt = $pdo->prepare($sql);
$result = $stmt->execute();
header("Location: edit-category.php?id=" . $id . "&result=" . $result);
} else {
$id = $_GET["id"];
$catId;
$catTitle;
//タイトル
$catSlug;
//スラッグ
$catDesc;
//説明
// include "dbcategory.php";
$sqlWHERE = " WHERE cat_id = :id";
$bindArray = array(array('bind' => ':id', 'value' => $id, 'param' => PDO::PARAM_STR));
$results = sqlRequest("*", $sqlFrom, $sqlWHERE, null, $bindArray);
foreach ($results as $row) {
$catTitle = $row["cat_name"];
$catSlug = $row["cat_slug"];
$catDesc = nl2br(htmlspecialchars_decode($row["cat_description"]));
}
}
if (isset($_GET["result"])) {
if ($_GET["result"] == 1) {
$msg = '<p class="msg msg-success">カテゴリーを変更しました！<a href="" class="fadeOut">非表示</a></p>';
} else {
$msg = '<p class="msg msg-failed">カテゴリーを変更に失敗しました！<a href="" class="fadeOut">非表示</a></p>';
}
}
$pdo = null;
include "header.php";
$imgurl;
//画像のパス
$cat;
//カテゴリー
$showFlg;
//表示非表示
$create_date;
//登録日
$update_date;
//更新日
$sqlSelect = "news_id,news_title,news_detail,news_url,show_flg,category.cat_name,create_date,update_date";
// SQLのFrom部分
$sqlFrom = "news,category";
$sqlWHERE = " WHERE category.cat_id = news.news_cat AND news_id = :id";
$bindArray = array(array('bind' => ':id', 'value' => $id, 'param' => PDO::PARAM_STR));
$results = sqlRequest($sqlSelect, $sqlFrom, $sqlWHERE, null, $bindArray);
foreach ($results as $row) {
$title = $row["news_title"];
$detail = nl2br(htmlspecialchars_decode($row["news_detail"]));
$imgurl = $row["news_url"];
$cat = $row["cat_name"];
$showFlg = $row["show_flg"];
$create_date = $row["create_date"];
$update_date = $row["update_date"];
}
}
if (isset($_GET["result"])) {
if ($_GET["result"] == 1) {
$msg = '<p class="msg msg-success">記事の更新の成功しました！<a href="" class="fadeOut">非表示</a></p>';
} else {
$msg = '<p class="msg msg-failed">記事の更新の失敗しました！<a href="" class="fadeOut">非表示</a></p>';
