Exemplo n.º 1
0
 public function indexAction()
 {
     $config = Config::singleton();
     require $config->get('modelsFolder') . 'indexModel.php';
     $db = new indexModel();
     $this->data["hello"] = $db->example();
     $this->view->show("index.php", $this->data);
 }
Exemplo n.º 2
0
 function __construct()
 {
     $mod = new indexModel();
     $rows = $mod->getRows('*', array(array('name', '=', 'lmyoaoa')));
     print_r($rows);
     /*
     $rows = $mod->getRowsCount(array(
         array('name', '=', 'lmyoaoa'),
     ));
     print_r($rows);
     */
     $id = $mod->add(array('name' => 'a'), true);
     var_dump('新增的ID为:' . $id);
     $up = $mod->update(array(array('name', '=', 'b')), array('name' => "c'"));
     var_dump($up);
 }
 function run()
 {
     require_once $this->sysRoot . '/Model/mysqlModel.php';
     require_once $this->sysRoot . '/Model/indexModel.php';
     $indexModel = new indexModel();
     $newsData = $indexModel->run();
     // newsDataを利用してcodeを生成
     $code = '';
     for ($i = 0; $i < count($newsData); $i++) {
         $imgPath = '';
         if (0 < $newsData[$i]['images']) {
             // 画像が存在する
             // So, display it.
             $imgPath = NEWS_IMAGE_PATH . $newsData[$i]['image_src1'];
             $imgAlt = $newsData[$i]['image_alt1'];
         } else {
             // 画像が存在しない
             // teamによって表示させる画像を切り替える
             $imgPath = $this->helpers->teamsImg[$newsData[$i]['team']];
             $imgAlt = $this->helpers->teamsName[$newsData[$i]['team']];
         }
         // split for php5.2
         $code .= '<li><a href="/news/';
         $code .= $newsData[$i]['year'];
         $code .= '/';
         $code .= $newsData[$i]['news_id'];
         $code .= '">';
         $code .= '<div><img src="' . $imgPath . '" alt="' . $imgAlt . '" style="width: 200px;"></div>';
         // split for php5.2
         //$code .= '<p>' . $newsData[$i]['jpcreated'] . ' / ' . $this->helpers->teamsName[$newsData[$i]['team']] . '</p>';
         $code .= '<p>';
         $code .= $newsData[$i]['jpcreated'];
         $code .= ' / ';
         $code .= $this->helpers->teamsName[$newsData[$i]['team']];
         $code .= '</p>';
         $code .= '<p>' . $newsData[$i]['title'] . '</p>';
         $code .= '</a></li>';
     }
     require_once $this->sysRoot . '/Controller/templateController.php';
     $tpl = new templateController($this->sysRoot);
     $tpl->newsList = $code;
     $tpl->show($this->sysRoot . '/View/index.php');
 }
 public function getPages()
 {
     if (empty(self::$conn)) {
         self::$conn = $this->connect_pdo();
     }
     $sql = "SELECT p.id,p.name,p.des,p.image_icon,p.time_on,author_id,CONCAT_WS(' ',first_name,last_name) AS user_name\n\t\t\t\t\tFROM pages AS p\n\t\t\t\t\tLEFT JOIN users AS u\n\t\t\t\t\t\tON u.id=p.author_id\n\t\t\t\t\tORDER BY p.time_on DESC limit 3";
     $stmt = self::$conn->query($sql);
     $pages = array(array());
     $i = 0;
     while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
         $pages[$i++] = $row;
     }
     $i--;
     return $pages;
 }