PHP DatabaseAccess::getInstance示例

<?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++;
}

示例#2

显示文件

文件： content.php 项目： troycaeser/WheresMyWallet

 public function __construct()
 {
     $dao = DatabaseAccess::getInstance();
     $this->dbConnection = $dao->getConnection();
 }