PHP dbConnect類代碼示例

 /**
  * constructor
  **/
 function __construct()
 {
     require_once dirname(__FILE__) . '/dbConnect.php';
     //Open DB connection
     $db = new dbConnect();
     $this->conn = $db->connect();
 }

 function __construct()
 {
     require_once 'dbConnect.php';
     // opening db connection
     $db = new dbConnect();
     $this->conn = $db->connect();
 }

 function __construct()
 {
     require_once dirname(__FILE__) . '/dbConnect.php';
     $db = new dbConnect();
     //Connect to database
     $this->con = $db->connect();
     //Select "friends" collection, already defined in config.php
     $this->col = new MongoCollection($this->con, DB_COLLECTION);
 }

 function createTable($name, $query)
 {
     $db = new dbConnect();
     global $conn;
     $result = mysqli_query($db->connect(), "create table if not exists {$name}({$query})");
     if (!$result) {
         die('failed to connect [' . $conn->connect_error . ']');
     }
     echo "Table '{$name}' created already.<br>";
 }

function doWork()
{
    try {
        $dbh = dbConnect::getInstance()->dbh;
    } catch (PDOException $e) {
        print "Error!: " . $e->getMessage() . "<br/>";
        die;
    }
    if (empty($_POST["isDelete"])) {
        $sql = "insert into material (material_type, description) values ";
        $sql .= "(:material_type, :description) ";
        $sql .= "on duplicate key update description = :description ";
        $stmt = $dbh->prepare($sql);
        $stmt->bindValue(":material_type", $_POST["txtMaterialType"]);
        $stmt->bindValue(":description", $_POST["txtDescription"]);
    } else {
        $sql = "delete from material where material_type = :material_type ";
        $stmt = $dbh->prepare($sql);
        $stmt->bindValue(":material_type", $_POST["isDelete"]);
    }
    if ($stmt->execute()) {
        header("Content-Type: application/json");
        echo json_encode(array("result" => "success"));
    } else {
        header("Content-Type: application/json");
        echo json_encode($stmt->errorInfo());
    }
}

 public function __construct($id)
 {
     $this->pdo = dbConnect::getInstance();
     $this->id = $id;
     $query = $this->pdo->query("SELECT * FROM shipy_user WHERE id = '" . $this->id . "' ");
     $this->row = $query->fetch(PDO::FETCH_ASSOC);
 }

 function login($uname, $password, $checked)
 {
     $db = dbConnect::getInstance();
     $mysqli = $db->getConnection();
     $query = "SELECT * FROM users_tb WHERE mail= '" . $uname . "' AND pass = '" . md5($password) . "'";
     $res = $mysqli->query($query);
     if (mysqli_num_rows($res) > 0) {
         $row = mysqli_fetch_array($res);
         if ($row['type'] != "3") {
             $_SESSION['cafeteriaSystem'] = $row['id'];
             $_SESSION['type'] = $row['type'];
             $_SESSION['name'] = $row['name'];
             $_SESSION['pic'] = $row['pic_path'];
             //echo $_SESSION['php'];
             if ($checked == "1") {
                 setcookie("cafeteriaSystem", $row['id'], time() + 3600);
                 //echo $_COOKIE['php'];
             }
             if ($row['type'] == "1") {
                 header("location:orders.php");
             } else {
                 header("location:index.php");
             }
             return TRUE;
         }
     } else {
         return false;
     }
 }

function doWork()
{
    try {
        $dbh = dbConnect::getInstance()->dbh;
    } catch (PDOException $e) {
        print "Error!: " . $e->getMessage() . "<br/>";
        die;
    }
    $sql = "update member set member_name = :member_name, address = :address, password = :password ";
    $sql .= ",province_id = :province_id, province_name = :province_name ";
    $sql .= ",amphur_id = :amphur_id, amphur_name = :amphur_name, ";
    $sql .= ",district_id = :district_id, district_name = :district_name ";
    $sql .= ",postcode = :postcode ";
    $sql .= "where email = :email";
    $stmt = $dbh->prepare($sql);
    $stmt->bindValue(":member_name", $_POST["txtName"]);
    $stmt->bindValue(":address", $_POST["txtAddress"]);
    $stmt->bindValue(":password", $_POST["txtPassword"]);
    $stmt->bindValue(":province_id", doExplode($_POST["cboProvince"])[0]);
    $stmt->bindValue(":province_name", doExplode($_POST["cboProvince"])[1]);
    $stmt->bindValue(":amphur_id", doExplode($_POST["cboAmphur"])[0]);
    $stmt->bindValue(":amphur_name", doExplode($_POST["cboAmphur"])[1]);
    $stmt->bindValue(":district_id", doExplode($_POST["cboDistrict"])[0]);
    $stmt->bindValue(":district_name", doExplode($_POST["cboDistrict"])[1]);
    $stmt->bindValue(":postcode", $_POST["txtPostCode"]);
    $stmt->bindValue(":email", $_POST["email"]);
    if ($stmt->execute()) {
        header("Content-Type: application/json");
        echo json_encode(array("result" => "success"));
    } else {
        header("Content-Type: application/json");
        echo json_encode($stmt->errorInfo());
    }
}

function deleteShirtSize()
{
    try {
        $dbh = dbConnect::getInstance()->dbh;
    } catch (PDOException $e) {
        echo "Error!: " . $e->getMessage() . "<br/>";
        die;
    }
    $sql = "delete from shirt_size where size_code = :size_code and gender = :gender ";
    $stmt = $dbh->prepare($sql);
    $stmt->bindValue(":size_code", $_POST["size_code"]);
    $stmt->bindValue(":gender", $_POST["gender"]);
    header("Content-Type: application/json");
    if ($stmt->execute()) {
        echo json_encode(array("result" => "success"));
    } else {
        //echo json_encode($stmt->errorInfo());
        $errorCode = $stmt->errorCode();
        if ($errorCode == '23000') {
            echo json_encode(array('result' => 'ไม่สามารถลบได้ เนื่องจากได้มีการใช้ข้อมูลนี้ไปแล้ว !!!'));
        } else {
            echo json_encode($stmt->errorInfo());
        }
    }
}

function mcacc_get_acc_list()
{
    $mc_db = dbConnect::getInstance();
    if (!is_user_logged_in()) {
        log("Neprisijunges vartotojas bando pasitikrinti savo acc ip: " . $_SERVER['REMOTE_ADDR']);
        return;
    }
}

 public static function newWord()
 {
     $newWordID = self::getRandomID();
     $sql = "SELECT * FROM word WHERE ID={$newWordID}";
     $result = dbConnect::runSQL($sql);
     $word = $result->fetch_assoc();
     $wordLetters = str_split($word['word']);
     $word['wordLetters'] = $wordLetters;
     return $word;
 }

 public function execute($sql)
 {
     $exe = mysql_query($sql, $this->_connAccess->getConnection());
     if (!$exe) {
         exit('Error : ' . mysql_error() . ':' . $sql);
     } else {
         return $exe;
         dbConnect::closeConnection();
     }
 }

 public static function getActiveCSS()
 {
     $db = dbConnect::getReadOnly();
     $query = "SELECT * FROM CSSTemplates WHERE ActiveState=1;";
     $results = mysqli_query($db, $query);
     $row = mysqli_fetch_assoc($results);
     $activeCSSTemplate = new self($row);
     dbConnect::closeConnection($db);
     return $activeCSSTemplate;
 }

 public static function getContentArea()
 {
     $db = dbConnect::getReadOnly();
     $query = "SELECT * FROM ContentAreas;";
     $results = mysqli_query($db, $query);
     while ($row = mysqli_fetch_assoc($results)) {
         $contentAreas[] = new self($row);
     }
     //end while
     dbConnect::closeConnection($db);
     return $contentAreas;
 }

 public static function getArticle($_area, $_page)
 {
     $db = dbConnect::getReadOnly();
     $query = "SELECT * FROM Articles WHERE (Page='{$_page}' OR AllPages=1) AND ContentArea = '{$_area}';";
     $result = mysqli_query($db, $query);
     while ($row = mysqli_fetch_assoc($result)) {
         $articleArray[] = new self($row);
     }
     //end while
     dbConnect::closeConnection($db);
     return $articleArray;
 }