PHP dibi::insert方法代码示例

 /**
  * translates string with key $msg_id
  *
  * @param string $msg_id
  * @param int $count NOT USED YET, only for ITranslator needs
  * @return string translated string
  */
 public function translate($msg_id, $count = NULL)
 {
     if ($msg_id == "") {
         return NULL;
     }
     ///**************
     if (!isset($this->dictionary[$msg_id])) {
         dibi::insert(self::TABLE, array('msg_id' => $msg_id))->execute();
         $this->dictionary[$msg_id] = $msg_id;
         CacheTools::invalidate('dictionary');
     }
     /**	applying parameters **/
     $args = func_get_args();
     $argsCount = count($args);
     $requiredArgsCount = preg_match_all($this->paramsRegexp, $this->dictionary[$msg_id], $matches);
     if ($requiredArgsCount > $argsCount - 1) {
         throw new InvalidArgumentException("Insufficient number of arguments in translate function. Provided string '{$msg_id}'");
     }
     //        if ($argsCount > 1) {
     //	volane z Rules.php, aby sa mi to nesexovalo s '%label' a tym percentom a nemusel ho zdvojovat
     if ($argsCount > 1 && !is_null($args[1])) {
         //	vola sa to aj s parametrami z Rules.php napr. pre MIN_LENGTH a pod., treba zdvojit percento
         $msg_id = str_replace(array('%label', '%name', '%value'), array('%%label', '%%name', '%%value'), $this->dictionary[$msg_id]);
         //		dump($args);
         array_shift($args);
         //		dump($args);
         return vsprintf($msg_id, $args);
     } else {
         return $this->dictionary[$msg_id];
     }
     /**	applying parameters END **/
 }

 public function __set($name, $value)
 {
     if (!array_key_exists($name, $this->vars)) {
         dibi::insert("configs", array('name' => $name, 'value' => $value))->execute();
         return $this->vars[$name] = $value;
     } else {
         if ($this->vars[$name] == $value) {
             return $value;
         }
         dibi::update("configs", array('value' => $value))->where('name=%s', $name)->execute();
         return $this->vars[$name] = $value;
     }
 }

 /**
  * update user roles [delete & insert]
  *
  * @param int User id
  * @param int Role id
  */
 public function updateUserRoles($userId, $roles)
 {
     try {
         dibi::begin();
         dibi::delete(self::ACL_USERS_2_ROLES_TABLE)->where('user_id = %i', $userId)->execute();
         foreach ($roles as $role) {
             dibi::insert(self::ACL_USERS_2_ROLES_TABLE, array('user_id' => $userId, 'role_id' => $role))->execute();
         }
         dibi::commit();
     } catch (DibiDriverException $e) {
         dibi::rollback();
         throw $e;
     }
 }

 function insertIntoDatabase($id, $name, $region)
 {
     $codename = strtolower(preg_replace('/\\s+/', '', $name));
     // player name
     $row = array("codename" => $codename, "id" => $id, "region" => $region, "last_updated" => NULL);
     $table = "group";
     dibi::insert($table, $row)->on('DUPLICATE KEY UPDATE %a ', $row)->execute();
 }

 public static function insert($data, $log_type)
 {
     return dibi::insert(self::getTable($log_type), $data)->execute();
 }

<h1>Using Fluent Syntax | dibi</h1>

<?php 
require_once 'Nette/Debug.php';
require_once '../dibi/dibi.php';
date_default_timezone_set('Europe/Prague');
dibi::connect(array('driver' => 'sqlite', 'database' => 'data/sample.sdb'));
$id = 10;
$record = array('title' => 'Super product', 'price' => 318, 'active' => TRUE);
// SELECT ...
dibi::select('product_id')->as('id')->select('title')->from('products')->innerJoin('orders')->using('(product_id)')->innerJoin('customers USING (customer_id)')->orderBy('title')->test();
// -> SELECT [product_id] AS [id] , [title] FROM [products] INNER JOIN [orders]
//    USING (product_id) INNER JOIN customers USING (customer_id) ORDER BY [title]
// SELECT ...
echo dibi::select('title')->as('id')->from('products')->fetchSingle();
// -> Chair (as result of query: SELECT [title] AS [id] FROM [products])
// INSERT ...
dibi::insert('products', $record)->setFlag('IGNORE')->test();
// -> INSERT IGNORE INTO [products] ([title], [price], [active]) VALUES ('Super product', 318, 1)
// UPDATE ...
dibi::update('products', $record)->where('product_id = %d', $id)->test();
// -> UPDATE [products] SET [title]='Super product', [price]=318, [active]=1 WHERE product_id = 10
// DELETE ...
dibi::delete('products')->where('product_id = %d', $id)->test();
// -> DELETE FROM [products] WHERE product_id = 10
// custom commands
dibi::command()->update('products')->where('product_id = %d', $id)->set($record)->test();
// -> UPDATE [products] SET [title]='Super product', [price]=318, [active]=1 WHERE product_id = 10
dibi::command()->truncate('products')->test();
// -> TRUNCATE [products]

 public function insert(array $data)
 {
     return dibi::insert(':graweb:news', $data)->execute(dibi::IDENTIFIER);
 }

 /**
  * basic insert
  *
  * @param array $data
  * @return int insertedId()
  */
 public function insert(array $data)
 {
     return dibi::insert(static::TABLE, $data)->execute(dibi::IDENTIFIER);
 }

 static function insert($values)
 {
     $user_value['name'] = @$values['name'];
     $user_value['surname'] = @$values['surname'];
     //		$user_value['email'] = $values['email'];
     $user_value['login'] = $values['login'];
     $user_value['activate'] = $values['activate'];
     $user_value['password'] = self::getHash($values['password']);
     $user_value['fbuid'] = @$values['fbuid'];
     $user_value['google_id'] = @$values['google_id'];
     $user_value['newsletter'] = @$values['newsletter'];
     $user_value['discount'] = @$values['discount'];
     unset($values['name'], $values['surname'], $values['login'], $values['password'], $values['activate'], $values['fbuid'], $values['newsletter'], $values['discount']);
     dibi::begin();
     dibi::insert(TABLE_USERS, $user_value)->execute();
     $values['user_id'] = dibi::insertId();
     dibi::insert(TABLE_USERS_INFO, $values)->execute();
     dibi::commit();
     return $values['user_id'];
 }

 public function allowTemporaryLogin($userId, $email, $expirationTime = '+1 hour')
 {
     $token = Basic::randomizer(80);
     dibi::insert(self::TEMPORARY_LOGIN_TABLE, array('users_id' => $userId, 'email' => $email, 'token' => $token, 'expire' => dibi::datetime(strtotime($expirationTime))))->execute();
     return $token;
 }

 public function logAccess()
 {
     return dibi::insert('analytics', array('ua' => $this->ua, 'ip' => $this->ip, 'sid' => $this->sid, 'referer' => $this->referer, 'page' => $this->page))->execute();
 }

 function addToDatabase($name, $value)
 {
     dibi::insert($name, $value)->on('DUPLICATE KEY UPDATE %a ', $value)->execute();
 }