<?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>';