本文整理汇总了PHP中DbManager::prepare方法的典型用法代码示例。如果您正苦于以下问题：PHP DbManager::prepare方法的具体用法？PHP DbManager::prepare怎么用？PHP DbManager::prepare使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbManager的用法示例。
在下文中一共展示了DbManager::prepare方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testGetMappedLicenseRefView
public function testGetMappedLicenseRefView()
{
$this->testDb = new TestPgDb();
$this->testDb->createPlainTables(array('license_ref', 'license_map'));
$this->dbManager = $this->testDb->getDbManager();
$this->dbManager->queryOnce("CREATE TABLE license_candidate (group_fk integer) INHERITS (license_ref)");
$this->dbManager->insertTableRow('license_map', array('license_map_pk' => 0, 'rf_fk' => 2, 'rf_parent' => 1, 'usage' => LicenseMap::CONCLUSION));
$this->dbManager->insertTableRow('license_ref', array('rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'));
$this->dbManager->insertTableRow('license_ref', array('rf_pk' => 2, 'rf_shortname' => 'Two', 'rf_fullname' => 'Two-2'));
$this->dbManager->insertTableRow('license_candidate', array('rf_pk' => 3, 'rf_shortname' => 'Three', 'rf_fullname' => 'Three-3', 'group_fk' => $this->groupId));
$this->assertCountBefore = \Hamcrest\MatcherAssert::getCount();
$view = LicenseMap::getMappedLicenseRefView(LicenseMap::CONCLUSION);
$stmt = __METHOD__;
$this->dbManager->prepare($stmt, $view);
$res = $this->dbManager->execute($stmt);
$map = $this->dbManager->fetchAll($res);
$this->dbManager->freeResult($res);
assertThat($map, is(arrayWithSize(2)));
$expected = array(array('rf_origin' => 1, 'rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'), array('rf_origin' => 2, 'rf_pk' => 1, 'rf_shortname' => 'One', 'rf_fullname' => 'One-1'));
assertThat($map, containsInAnyOrder($expected));
}示例2: query
/**
* Queries db for models by given criteria
*
* @param array $criteria
* @param string $include
* @param int $limit
* @return array
*/
public static function query($criteria, $include = null, $limit = null)
{
$query = sprintf('SELECT * FROM %s %s %s ORDER BY %s %s', self::__getTableName(), !empty($criteria) ? 'WHERE' : '', join(' AND ', array_map(function ($k) {
return sprintf('%s = :%s', $k, $k);
}, array_keys($criteria))), static::$ordering, $limit ? 'LIMIT ' . $limit : '');
$stmt = DbManager::prepare($query);
$stmt->execute($criteria);
return array_map(function ($row) use($include) {
return new static($row, $include);
}, $stmt->fetchAll());
}