Example #1
0
}
//$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> -->
Example #2
0
    } 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>