本文整理匯總了PHP中Illuminate\Database\Connection::selectOne方法的典型用法代碼示例。如果您正苦於以下問題：PHP Connection::selectOne方法的具體用法？PHP Connection::selectOne怎麽用？PHP Connection::selectOne使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Illuminate\Database\Connection的用法示例。
在下文中一共展示了Connection::selectOne方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: findMask
/**
* {@inheritdoc}
*/
public function findMask(RequesterInterface $requester, ResourceInterface $resource)
{
$oldFetchMode = $this->connection->getFetchMode();
$this->connection->setFetchMode(\PDO::FETCH_COLUMN);
if (null === ($mask = $this->connection->selectOne('SELECT mask FROM ' . $this->getAclSchema()->getPermissionsTableName() . ' WHERE requester = :requester AND resource = :resource', ['requester' => $requester->getAclRequesterIdentifier(), 'resource' => $resource->getAclResourceIdentifier()]))) {
$this->connection->setFetchMode($oldFetchMode);
throw new MaskNotFoundException();
}
$this->connection->setFetchMode($oldFetchMode);
return (int) $mask;
}示例2: lastInsertId
/**
* function to get oracle sequence last inserted id
*
* @param string $name
* @return integer
*/
public function lastInsertId($name)
{
// check if a valid name and sequence exists
if (!$name or !$this->exists($name)) {
return 0;
}
return $this->connection->selectOne("select {$name}.currval as id from dual")->id;
}示例3: getPrimaryKey
/**
* get table's primary key
*
* @param string $table
* @return string
*/
public function getPrimaryKey($table)
{
if (!$table) {
return '';
}
$data = $this->connection->selectOne("\n SELECT cols.column_name\n FROM all_constraints cons, all_cons_columns cols\n WHERE cols.table_name = upper('{$table}')\n AND cons.constraint_type = 'P'\n AND cons.constraint_name = cols.constraint_name\n AND cons.owner = cols.owner\n AND cols.position = 1\n AND cons.owner = (select user from dual)\n ORDER BY cols.table_name, cols.position\n ");
if (count($data)) {
return $data->column_name;
}
return '';
}