Commit: 495aa8f12e528b2bc4935e786aee8dc4f4a98625 - magic (git)

magic framework の開発

Commit MetaInfo

• Revision: 495aa8f12e528b2bc4935e786aee8dc4f4a98625 (tree)
• Time: 2011-12-16 12:10:49
• Author: taka451213 <taka451213@hotm...>
• Commiter: taka451213

Log Message

Signed-off-by: taka451213 <[e-mail]>

Change Summary

• modified: koshien/app/dao/pc/IndexDao.php

Incremental Difference

--- a/koshien/app/dao/pc/IndexDao.php
+++ b/koshien/app/dao/pc/IndexDao.php
@@ -1,45 +1,45 @@
-<?php
-final class IndexDao extends Dao {
-    public function __construct() {
-    }
-    public function selectTournament() {
-        $stmt = " select user_no,";
-        $stmt .= "       tournament_no,";
-        $stmt .= "       tournament_name,";
-        $stmt .= "       main_image,";
-        $stmt .= "  from ms_tournament";
-        $stmt .= " where start_flag = 1";
-        $stmt .= " order by status";
-        $res = $this->pdo->prepare($stmt);
-        $res->execute();
-        return $res->fetchAll(PDO::FETCH_ASSOC);
-    }
-//     public function deleteTournament($userNo, $tournamentNo) {
-//         $stmt = " delete from ms_tournament";
-//         $stmt .= " where user_no = ?";
-//         $stmt .= "   and tournament_no = ?";
-//         $res = $this->pdo->prepare($stmt);
-//         $res->execute(array($userNo, $tournamentNo));
-//         return $res->rowCount();
-//     }
-//     public function updateTournament($userNo, $tournamentNo) {
-//         $stmt = " update ms_tournament";
-//         $stmt .= "   set status = 1";
-//         $stmt .= " where user_no = ?";
-//         $stmt .= "   and tournament_no = ?";
-//         $stmt .= "   and status = 0";
-//         $res = $this->pdo->prepare($stmt);
-//         $res->execute(array($userNo, $tournamentNo));
-//         return $res->rowCount();
-//     }
-//     public function selectImage($userNo, $tournamentNo) {
-//         $stmt = " select main_image";
-//         $stmt .= "  from ms_tournament";
-//         $stmt .= " where user_no = ?";
-//         $stmt .= "   and tournament_no = ?";
-//         $res = $this->pdo->prepare($stmt);
-//         $res->execute(array($userNo, $tournamentNo));
-//         return $res->fetchColumn();
-//     }
-}
+<?php
+final class IndexDao extends Dao {
+    public function __construct() {
+    }
+    public function selectTournament() {
+        $stmt = " select user_no,";
+        $stmt .= "       tournament_no,";
+        $stmt .= "       tournament_name,";
+        $stmt .= "       main_image,";
+        $stmt .= "  from ms_tournament";
+        $stmt .= " where start_flag = 1";
+        $stmt .= " order by status";
+        $res = $this->pdo->prepare($stmt);
+        $res->execute();
+        return $res->fetchAll(PDO::FETCH_ASSOC);
+    }
+//     public function deleteTournament($userNo, $tournamentNo) {
+//         $stmt = " delete from ms_tournament";
+//         $stmt .= " where user_no = ?";
+//         $stmt .= "   and tournament_no = ?";
+//         $res = $this->pdo->prepare($stmt);
+//         $res->execute(array($userNo, $tournamentNo));
+//         return $res->rowCount();
+//     }
+//     public function updateTournament($userNo, $tournamentNo) {
+//         $stmt = " update ms_tournament";
+//         $stmt .= "   set status = 1";
+//         $stmt .= " where user_no = ?";
+//         $stmt .= "   and tournament_no = ?";
+//         $stmt .= "   and status = 0";
+//         $res = $this->pdo->prepare($stmt);
+//         $res->execute(array($userNo, $tournamentNo));
+//         return $res->rowCount();
+//     }
+//     public function selectImage($userNo, $tournamentNo) {
+//         $stmt = " select main_image";
+//         $stmt .= "  from ms_tournament";
+//         $stmt .= " where user_no = ?";
+//         $stmt .= "   and tournament_no = ?";
+//         $res = $this->pdo->prepare($stmt);
+//         $res->execute(array($userNo, $tournamentNo));
+//         return $res->fetchColumn();
+//     }
+}
 // EOF.
\ No newline at end of file