PHP ConnectionFactory::getFactoryの例

コード例 #1

ファイル: Query.php プロジェクト: rbudhu/SPD

 public function __construct($table)
 {
     $this->myTable = strtolower($table);
     $this->butOnly = array();
     $this->butNot = array();
     $this->wheres = array();
     $this->sets = array();
     $this->orders = array();
     $this->columns = array();
     $this->tables = array();
     array_push($this->tables, $table);
     $this->conn = ConnectionFactory::getFactory()->getConnection();
 }

コード例 #2

ファイル: sessiongateway.class.php プロジェクト: jimmylorunning/auth

 function __construct($dbconfig)
 {
     $this->_dbhandle = ConnectionFactory::getFactory()->getConnection($dbconfig);
 }

コード例 #3

ファイル: users.php プロジェクト: urisk/cssServiceRequests

function getAssignedToOptions()
{
    $empno = '';
    if (isset($_SESSION['Empno'])) {
        $empno = $_SESSION['Empno'];
    }
    $role = '';
    if (isset($_SESSION['Role'])) {
        $role = $_SESSION['Role'];
    }
    $db = ConnectionFactory::getFactory()->getConnection();
    $statement = "select lbr.empno,lbr.name from (" . "    select Empno= Stnote_2" . "    from " . ConnectionFactory::FiscDB() . ".dbo.fmdfsrq" . "    where stnote_2 <> ''" . "    group by stnote_2" . ")srq," . ConnectionFactory::FiscDB() . ".dbo.tcdflbr lbr" . " where srq.empno = lbr.empno";
    $query = $db->prepare($statement);
    $query->execute();
    echo "<option value=\"\"></option>";
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
        if ($role == 'T' && $row['empno'] == $empno) {
            echo "<option value=\"" . $row['empno'] . "\" selected=\"selected\">" . $row['name'] . "</option>";
        } else {
            echo "<option value=\"" . $row['empno'] . "\"\\>" . $row['name'] . "</option>";
        }
    }
}

コード例 #4

ファイル: classgen.php プロジェクト: rbudhu/SPD

function tab($fh)
{
    fwrite($fh, "\t");
}
if (isset($_POST["generate"])) {
    $tableName = $_POST["tableName"];
    $className = $_POST["className"];
    $fh = fopen($className . ".php", "w");
    fwrite($fh, "<?php");
    br($fh);
    fwrite($fh, "class " . $className);
    br($fh);
    fwrite($fh, "{");
    br($fh);
    $fields = array();
    $conn = ConnectionFactory::getFactory()->getConnection();
    $query = "DESCRIBE " . $tableName;
    $stmt = $conn->prepare($query);
    $res = $stmt->execute();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $field = unUnderscorize($row["Field"]);
        array_push($fields, $field);
        tab($fh);
        fwrite($fh, "private \$" . $field . ";");
        br($fh);
    }
    br($fh);
    foreach ($fields as $field) {
        $f = ucwords($field);
        tab($fh);
        fwrite($fh, "public function get" . $f . "( )");