本文整理汇总了PHP中app\Project::getDB方法的典型用法代码示例。如果您正苦于以下问题:PHP Project::getDB方法的具体用法?PHP Project::getDB怎么用?PHP Project::getDB使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\Project
的用法示例。
在下文中一共展示了Project::getDB方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: searchAction
public function searchAction()
{
$this->setTitle('Cautare Produse - Auto Parts Supply');
$query = isset($_GET['query']) ? $_GET['query'] : null;
$products = array();
$error = '';
if ($query) {
$sql = 'SELECT * FROM ' . ProductEntity::getTable() . " WHERE name LIKE '%" . $query . "%'";
$statement = Project::getDB()->prepare($sql);
if ($statement->execute()) {
$products = $statement->fetchAll(\PDO::FETCH_CLASS, 'App\\Entity\\ProductEntity');
}
if (count($products) == 0) {
$error = 'Nu sunt produse pentru criterile cautarii.';
}
} else {
$error = 'Parametri cautarii nu sunt corecti.';
}
$this->renderTemplate('product/search.php', array('products' => $products, 'error' => $error));
}
示例2: deleteMultipleById
public function deleteMultipleById($entityClassName, array $ids)
{
$ids = implode(', ', $ids);
$sql = 'DELETE FROM ' . $this->getTable($entityClassName) . ' WHERE id in (' . $ids . ')';
$db = Project::getDB();
$stm = $db->prepare($sql);
if ($stm->execute()) {
return true;
}
return false;
}