PHP Connection::getInstance方法代码示例

 /**
  * Method __construct
  * 
  * Cria as configurações padrão do objeto Model
  * 
  * @param string
  */
 public function __construct($table = null)
 {
     if ($table !== null) {
         $this->setTable($table);
     }
     $this->conn = Connection::getInstance();
 }

 public static function signup()
 {
     $dbh = Connection::getInstance()->connect();
     if (isset($_POST['email']) && !isset($_POST['username'])) {
         $email = $_POST['email'];
         if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
             echo "invalid";
         } else {
             $stmt = $dbh->prepare("SELECT id FROM users WHERE email=:email");
             $stmt->bindParam(':email', $email);
             $stmt->execute();
             $stmt = $stmt->fetch();
             if ($stmt) {
                 echo "exist";
             } else {
                 echo "ok";
             }
         }
     }
     if (isset($_POST['username']) && isset($_POST['email']) && isset($_POST['password'])) {
         $username = $_POST['username'];
         $email = $_POST['email'];
         $password = $_POST['password'];
         $stmt = $dbh->prepare("INSERT INTO users (username, email, password) VALUES (:username, :email, :password)");
         $stmt->bindParam(':username', $username);
         $stmt->bindParam(':email', $email);
         $stmt->bindParam(':password', $password);
         $stmt->execute();
     }
 }

 public static function delete($id)
 {
     $db = Connection::getInstance();
     $sql = "DELETE FROM sse_answer WHERE thread_id = :id";
     $statement = $db->prepare($sql);
     $statement->execute(array(':id' => $id));
 }

 public static function setIsdatepassed($isdatepassed)
 {
     $db = Connection::getInstance();
     $mysqli = $db->getConnection();
     $query = "update deadline set isdatepassed='{$isdatepassed}';";
     $result = $mysqli->query($query);
     return $result;
 }

 public function countPosts()
 {
     $conn = Connection::getInstance("read");
     $command = "SELECT COUNT(*) AS count \n\t\t\t\t\tFROM post_to_cats \n\t\t\t\t\tWHERE cat_id = {$this->id}";
     $r = $conn->execObject($command);
     $row = mysqli_fetch_assoc($r);
     return $row['count'];
 }

 public static function refundOrder($orderCode, $amount)
 {
     if (!empty($amount) && is_numeric($amount)) {
         $json = json_encode(array('refundAmount' => "{$amount}"));
     } else {
         $json = false;
     }
     Connection::getInstance()->sendRequest('orders/' . $orderCode . '/refund', $json, false);
 }

 public function delete($school_id)
 {
     $conn = Connection::getInstance("write");
     $command = "DELETE FROM newsletter\n\t\t\t\t\tWHERE news_id = {$this->id}\n\t\t\t\t\tAND school_id = {$school_id}";
     if ($conn->execDelete($command)) {
         return true;
     } else {
         return false;
     }
 }

 public static function editCategory6($category)
 {
     $db = Connection::getInstance();
     $mysqli = $db->getConnection();
     $nic = $category->getNic();
     $dateOfReturned = $category->getDateOfReturned();
     $periodAboardStay = $category->getPerioadAbroadStay();
     $reasonsForStay = $category->getReasonsForStay();
     $query = "update personComingFromAboard set dateOfReturned='{$dateOfReturned}',periodAboardStay='{$periodAboardStay}',reasonsForStay='{$reasonsForStay}' where NIC='{$nic}'";
     return $mysqli->query($query);
 }

 public static function delete($id)
 {
     $db = Connection::getInstance();
     // delete answer
     require_once ROOT . DS . 'application' . DS . 'model' . DS . 'class.answer.php';
     Answer::delete($id);
     // delete thread
     $sql = "DELETE FROM sse_thread WHERE thread_id = :id";
     $statement = $db->prepare($sql);
     $statement->execute(array(':id' => $id));
 }

 public static function findAll()
 {
     $database = Connection::getInstance();
     $results = $database->run('SELECT * FROM chapters');
     // Hydrate the objects
     $chapters = array();
     foreach ($results as $result) {
         $chapters[] = self::factory($result);
     }
     return $chapters;
 }

 /**
  * Initialize class
  *
  * @param string $host
  * @param string $username
  * @param string $passord
  * @param string $database
  * @return void
  */
 public function __construct($host, $username = NULL, $password = NULL, $database = NULL, $newconnection = true)
 {
     $this->traitConstructor();
     if (is_array($host)) {
         $credentials = $host;
     } else {
         $credentials = ['host' => $host, 'username' => $username, 'password' => $password, 'database' => $database];
     }
     $this->connection = $newconnection ? new Connection($credentials) : Connection::getInstance() ?: new Connection($credentials);
     $this->results = new Collection();
     $this->query("SET NAMES UTF8");
 }

 function DirectQuery($driver, $host = NULL, $dbname = NULL, $user = NULL, $pass = NULL)
 {
     if (Connection::validClass($driver)) {
         $this->conn =& $driver;
     } else {
         if (URL::validclass($driver)) {
             $this->conn =& Connection::getInstance($driver);
         } else {
             $this->conn =& Connection::getInstance($driver, $host, $dbname, $user, $pass);
         }
     }
 }

 /**
  * Library constructor
  * @param string $service_key
  *  Your worldpay service key
  * @param int $timeout
  *  Connection timeout length
  * */
 public function __construct($service_key = false, $timeout = false)
 {
     if ($service_key == false) {
         Error::throwError("key");
     }
     $this->connection = Connection::getInstance();
     $this->setServiceKey($service_key);
     if ($timeout !== false) {
         $this->setTimeout($timeout);
     }
     //
 }

function exportCSV($query, $headerArray, $filename)
{
    $conn = Connection::getInstance();
    $statement = $conn->db->prepare($query);
    $statement->setFetchMode(PDO::FETCH_ASSOC);
    $statement->execute();
    $csv = Writer::createFromFileObject(new SplTempFileObject());
    $csv->insertOne($headerArray);
    $csv->insertAll($statement);
    $csv->output($filename . '.csv');
    die;
}

 public static function editPPAchievement($achievement)
 {
     $db = Connection::getInstance();
     $mysqli = $db->getConnection();
     $schoolId = $achievement->getSchoolId();
     $nic = $achievement->getNIC();
     $achievementId = $achievement->getAchievementID();
     $type = $achievement->getType();
     $achievementDetail = $achievement->getAchievementDetail();
     $query = "update pastpupil_Achievement set type='{$type}', achievementDetail='{$achievementDetail}' where schoolId='{$schoolId}' and NIC='{$nic}' and  AchievementId='{$achievementId}'";
     return $mysqli->query($query);
 }