本文整理汇总了PHP中DatabaseHandler::createInsertQuery方法的典型用法代码示例。如果您正苦于以下问题：PHP DatabaseHandler::createInsertQuery方法的具体用法？PHP DatabaseHandler::createInsertQuery怎么用？PHP DatabaseHandler::createInsertQuery使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DatabaseHandler的用法示例。
在下文中一共展示了DatabaseHandler::createInsertQuery方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: addPolicyLimitations
/**
* Adds limitations to an existing policy.
*
* @param int $policyId
* @param array $limitations
*/
public function addPolicyLimitations($policyId, array $limitations)
{
foreach ($limitations as $identifier => $values) {
$query = $this->handler->createInsertQuery();
$query->insertInto($this->handler->quoteTable('ezpolicy_limitation'))->set($this->handler->quoteColumn('id'), $this->handler->getAutoIncrementValue('ezpolicy_limitation', 'id'))->set($this->handler->quoteColumn('identifier'), $query->bindValue($identifier))->set($this->handler->quoteColumn('policy_id'), $query->bindValue($policyId, null, \PDO::PARAM_INT));
$query->prepare()->execute();
$limitationId = $this->handler->lastInsertId($this->handler->getSequenceName('ezpolicy_limitation', 'id'));
foreach ($values as $value) {
$query = $this->handler->createInsertQuery();
$query->insertInto($this->handler->quoteTable('ezpolicy_limitation_value'))->set($this->handler->quoteColumn('id'), $this->handler->getAutoIncrementValue('ezpolicy_limitation_value', 'id'))->set($this->handler->quoteColumn('value'), $query->bindValue($value))->set($this->handler->quoteColumn('limitation_id'), $query->bindValue($limitationId, null, \PDO::PARAM_INT));
$query->prepare()->execute();
}
}
}