本文整理汇总了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 '';
}