本文整理匯總了PHP中Illuminate\Database\DatabaseManager::statement方法的典型用法代碼示例。如果您正苦於以下問題：PHP DatabaseManager::statement方法的具體用法？PHP DatabaseManager::statement怎麽用？PHP DatabaseManager::statement使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Illuminate\Database\DatabaseManager的用法示例。
在下文中一共展示了DatabaseManager::statement方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: truncateTables
/**
* @param $tables
*/
private function truncateTables($tables)
{
$this->truncatedCount = 0;
foreach ($tables as $table) {
if (!in_array($table, $this->exclude)) {
$this->truncatedCount++;
$this->db->statement('SET FOREIGN_KEY_CHECKS=0;');
$this->db->statement("TRUNCATE TABLE {$table}");
$this->db->statement('SET FOREIGN_KEY_CHECKS=1;');
$this->info("Table {$table} successfully truncated.");
}
}
$this->info("Total table(s) truncated: {$this->truncatedCount}");
}示例2: deleteConversation
public function deleteConversation($conv_id, $user_id)
{
$this->db->statement('
UPDATE ' . $this->tablePrefix . 'messages_status mst
SET mst.status=' . self::DELETED . '
WHERE mst.user_id=?
AND mst.msg_id IN (
SELECT msg.id
FROM messages msg
WHERE msg.conv_id=?
)
', [$user_id, $conv_id]);
}示例3: store
/**
* Store an array
*
* @param array $values
* @return bool
*/
public function store(array $values)
{
foreach ($values as $key => $value) {
// Ensure proper type
$value = $this->forceTypes($value);
// Json to save
$jsonValue = json_encode($value);
// Update
$this->database->statement("INSERT INTO system_registries ( `key`, `value` ) VALUES ( ?, ? )\n\t\t\t\t\t\t\t\t\t\tON DUPLICATE KEY UPDATE `key` = ?, `value` = ?", array($key, $jsonValue, $key, $jsonValue));
$this->cache->add($key, $value);
}
//$this->cache->forever('torann.registry', $this->cache_storage);
return true;
}