} //$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>"; } // table閉じタグで終了 $pdo = null; // ******* ページの表示設定ここから ******** $pager = pagerMake($total, true); // ******* ページの表示設定ここまで ******* // include "header.php"; ?> <div id="contents"> <?php include "sidebar.php"; ?> <div id="main"> <p class="pankuzu"><a href="index.php">ホーム</a> > <?php echo $pankuzu; ?> </p> <article> <!-- <h2>カテゴリー名</h2> -->
} 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>"; $view .= "</tr>"; } // table閉じタグで終了 $view .= "</table>"; // ******* ページの表示設定ここから ******** $pager = pagerMake($total); // ******* ページの表示設定ここまで ******* $pdo = null; include "header.php"; include "sidebar.php"; ?> <div id="main"> <div class="body_cont"> <div class="control"> <div class="allCtrl"> <select name="all" class="CtrlList"> <option value="">一括操作の選択</option> <option value="change">変更</option> <option value="delete">削除</option>