PHP Connection::connect方法代碼示例

 /**
  * @return null
  */
 public function setUp()
 {
     $this->runDbStartupTask();
     $connector = DbRegistry::getConnector('af-tester');
     $this->conn = $connector->getConnection();
     $this->conn->connect();
     $driver = $this->conn->getDriver();
     $this->stmtDriver = $driver->stmt_init();
     $this->stmt = new PreparedStmt($this->stmtDriver);
 }

 /**
  * connect()
  */
 public function connect($dsninfo, $flags = 0)
 {
     if (!($driver = Creole::getDriver($dsninfo['phptype']))) {
         throw new SQLException("No driver has been registered to handle connection type: {$type}");
     }
     $connectionClass = Creole::import($driver);
     $this->childConnection = new $connectionClass();
     $this->log("connect(): DSN: " . var_export($dsninfo, true) . ", FLAGS: " . var_export($flags, true));
     return $this->childConnection->connect($dsninfo, $flags);
 }

 public function testConnection()
 {
     $this->subject->disconnect();
     $result = $this->subject->connect();
     $this->assertTrue($result);
     // Try a reconnect
     $result = $this->subject->connect();
     $this->assertTrue($result);
     $result = $this->subject->isConnected();
     $this->assertTrue($result);
     $result = $this->subject->disconnect();
     $this->assertTrue($result);
     $result = $this->subject->isConnected();
     $this->assertFalse($result);
 }

 public function setNewSport($cz)
 {
     $db = parent::connect();
     $result = $db->prepare("INSERT INTO `sport`(`cz`) VALUES ( ? )");
     $result->execute(array($cz));
     return $db->lastInsertId();
 }

 public function getAllEntryForAuthor($author)
 {
     $result = parent::connect()->prepare("SELECT * FROM `entries` WHERE `author` = :id AND `active` = 1 ORDER BY `id` DESC");
     $result->execute(array(':id' => $author));
     $pageResult = $result->fetchAll();
     return $pageResult;
 }

 protected function setUp()
 {
     $host = getenv('TEST_BEANSTALKD_HOST');
     $port = getenv('TEST_BEANSTALKD_PORT');
     if (!$host || !$port) {
         $message = 'TEST_BEANSTALKD_HOST and/or TEST_BEANSTALKD_PORT env variables not defined.';
         $this->markTestSkipped($message);
     }
     $connection = new Connection($host, $port, false);
     if (!$connection->connect()) {
         $message = "Need a running beanstalkd server at {$host}:{$port}.";
         $this->markTestSkipped($message);
     }
     $this->subject = new Client($connection);
     // Clear all jobs on the server
     foreach ($this->subject->listTubes() as $tube) {
         $this->subject->useTube($tube);
         while ($job = $this->subject->peekReady()) {
             $this->subject->delete($job['id']);
         }
         while ($job = $this->subject->peekBuried()) {
             $this->subject->delete($job['id']);
         }
     }
     $this->subject->useTube('default');
 }

 public function setNewImg($name, $size, $user, $type)
 {
     $db = parent::connect();
     $timestamp = time();
     $result = $db->prepare("INSERT INTO `profile_image`(`name`, `timestamp`, `size`, `user`, `type`) VALUES (?, ?, ?, ?, ?)");
     $result->execute(array($name, $timestamp, $size, $user, $type));
 }

function posicionaApps($conf_apps)
{
    $colunas = explode('|', $conf_apps);
    foreach ($colunas as $chave => $coluna) {
        $apps = explode(',', $coluna);
        // Carrega estrutura HTML auxiliar
        if ($chave == 0) {
            require_once 'assets/htmls_auxiliares/html_box-esquerdo.php';
        }
        if ($chave == 1) {
            require_once 'assets/htmls_auxiliares/html_box-meio.php';
        }
        if ($chave == 2) {
            require_once 'assets/htmls_auxiliares/html_box-direito.php';
        }
        // Carrega cada app separadamente
        $connect = Connection::connect();
        foreach ($apps as $app) {
            if (!empty($app)) {
                require 'apps/' . $app . '.php';
            }
        }
        // Carrega estrutura HTML auxiliar
        if ($chave == 0) {
            require_once 'assets/htmls_auxiliares/html_fim_box-esquerdo.php';
        }
        if ($chave == 1) {
            require_once 'assets/htmls_auxiliares/html_fim_box-meio.php';
        }
        if ($chave == 2) {
            require_once 'assets/htmls_auxiliares/html_fim_box-direito.php';
        }
    }
}

 private function tryMethod($method, $args)
 {
     try {
         return call_user_func_array([$this->connection, $method], $args);
     } catch (\Exception $exception) {
         $e = $exception;
         while ($e->getPrevious() && !$e instanceof \PDOException) {
             $e = $e->getPrevious();
         }
         if ($e instanceof \PDOException && $e->errorInfo[1] == self::MYSQL_CONNECTION_TIMED_WAIT_CODE) {
             $this->connection->close();
             $this->connection->connect();
             $this->logger->notice('Connection to MySQL lost, reconnect okay.');
             return call_user_func_array([$this->connection, $method], $args);
         }
         if (false !== strpos($exception->getMessage(), 'MySQL server has gone away') || false !== strpos($exception->getMessage(), 'Error while sending QUERY packet') || false !== strpos($exception->getMessage(), 'errno=32 Broken pipe')) {
             $this->connection->close();
             $this->connection->connect();
             $this->logger->notice('Connection to MySQL lost, reconnect okay.');
             return call_user_func_array([$this->connection, $method], $args);
         }
         $this->logger->critical('Connection to MySQL lost, unable to reconnect.', ['exception' => $exception]);
         throw $e;
     }
 }

 function login($email, $password)
 {
     $mysqli = new Connection();
     $db = $mysqli->connect();
     //hash the password
     $password = hashPassword($password);
     //prepare the query
     $query = $db->prepare("SELECT id FROM users WHERE email = ? AND password = ? LIMIT 1") or die("error");
     $query->bind_param('ss', $email, $password);
     //excuting
     $query->execute();
     //store results
     $query->store_result();
     //bind results
     $query->bind_result($id);
     $query->fetch();
     //get the num rows
     if ($query->num_rows == 1) {
         $user_browser = $_SERVER['HTTP_USER_AGENT'];
         session_start();
         $_SESSION['login_string'] = array();
         $_SESSION['login_string']['browserInfo'] = hash('sha512', $user_browser);
         $_SESSION['login_string']['id'] = hash('sha512', $id);
         return TRUE;
     } else {
         return FALSE;
     }
     //close the query
     $db->close();
 }

 public function getDBContent($page)
 {
     $result = parent::connect()->prepare("SELECT * FROM `pages` WHERE `url_name` = :page LIMIT 1");
     $result->execute(array(':page' => $page));
     $pageResult = $result->fetch();
     return $pageResult;
 }

 public static function getConnection()
 {
     if (!isset(self::$connect)) {
         self::$connect = new Connection();
     }
     return self::$connect;
 }

 public static function run()
 {
     Connection::connect();
     Session::start();
     Router::run();
     Connection::disconnect();
 }

 public function getNahravkaAll()
 {
     $db = parent::connect();
     $result = $db->prepare("SELECT * FROM `nahravka` ORDER BY `id` DESC");
     $result->execute(array());
     $nahravka = $result->fetchAll();
     return $nahravka;
 }

 public function getEnroll($event)
 {
     $db = parent::connect();
     $result = $db->prepare("SELECT * FROM `enroll` WHERE event = ?");
     $result->execute(array($event));
     $event = $result->fetchAll();
     return $event;
 }