<?php require_once dirname(dirname(dirname(dirname(__FILE__)))) . "/etc/__autoload.php"; $projectName = PROJECT; function tr_color($i) { if ($i % 2) { // $i が奇数 return "#F5F5F5"; } else { // $i が偶数 return "#DCDCDC"; } } // ここからデータベースを操作 $dbOBJ = DatabaseAccess::getInstance(); $sql = "SHOW TABLES"; $rtn_table = $dbOBJ->executeQuery($sql); $k = 1; while ($d = $rtn_table->fetchAssoc()) { foreach ($d as $v) { if ($_REQUEST["db_table"] == $k) { $option_tag .= "<option value=\"" . $_SERVER["PHP_SELF"] . "?db_table=" . $k . "\" selected>" . $v . "</option>\n"; $tbl_number = $k; } else { $option_tag .= "<option value=\"" . $_SERVER["PHP_SELF"] . "?db_table=" . $k . "\">" . $v . "</option>\n"; } $db_table_array[$k] = $v; } $k++; }
public function __construct() { $dao = DatabaseAccess::getInstance(); $this->dbConnection = $dao->getConnection(); }