本文整理匯總了PHP中DibiConnection::nativeQuery方法的典型用法代碼示例。如果您正苦於以下問題：PHP DibiConnection::nativeQuery方法的具體用法？PHP DibiConnection::nativeQuery怎麽用？PHP DibiConnection::nativeQuery使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DibiConnection的用法示例。
在下文中一共展示了DibiConnection::nativeQuery方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: createDatabase
/**
* @param string $username
* @param string $password
* @param string $databaseName
*/
public function createDatabase($username, $password, $databaseName)
{
//exit(var_dump('GRANT ALL PRIVILEGES ON '.$databaseName.'.* TO "'.$username.'"@"%" IDENTIFIED BY "'.$password.'" WITH GRANT OPTION'));
$this->connection->nativeQuery('GRANT ALL PRIVILEGES ON *.* TO "' . $username . '"@"%" IDENTIFIED BY "' . $password . '" WITH GRANT OPTION');
$this->connection->nativeQuery('CREATE DATABASE ' . $databaseName);
$this->connection->nativeQuery("GRANT ALL PRIVILEGES ON " . $databaseName . ".* TO '" . $username . "'@'%' IDENTIFIED BY '" . $password . "' WITH GRANT OPTION");
//TODO use $this->connection->driver->escape()
}示例2: getTotalCount
/**
* Returns the number of rows in a given data source.
* @return int
*/
public function getTotalCount()
{
if ($this->totalCount === NULL) {
$this->totalCount = (int) $this->connection->nativeQuery('SELECT COUNT(*) FROM ' . $this->sql)->fetchSingle();
}
return $this->totalCount;
}