thinkphp3.2.0 setInc method source code comprehensive analysis of php examples

jacklove
Release: 2023-04-02 06:06:01
Original
1917 people have browsed it

The editor below will share with you a comprehensive analysis of the source code of thinkphp3.2.0 setInc method, which has good reference value. I hope it will be helpful to everyone. Let’s follow the editor and take a look.

Let’s first take a look at the official example of setInc:

Requires a field and an auto-increment value (default is 1)

We use the following example to analyze step by step how its underlying implementation is implemented:

where(['id'=>1])->setInc('test_number',2); //每次添加2
    dump($tb_test->getLastSql());
    //string(67) "UPDATE `tb_test` SET `test_number`=test_number+2 WHERE ( `id` = 1 )"
  }
}
Copy after login

The first step is to find the source code of the setInc method:

Here I used phpstrom global search The method, found setInc is under proj\ThinkPHP\Library\Think\Model.class.php

/**
   * 字段值增长
   * @access public
   * @param string $field 字段名
   * @param integer $step 增长值
   * @return boolean
   */
  public function setInc($field,$step=1) {
    return $this->setField($field,array('exp',$field.'+'.$step));
  }
Copy after login

You can see that the setField method is used here , and then use exp custom expression to set $field = $field $step. At this point, we understand a little bit about the principle.

But the question comes again. How is setField implemented? Under the same file, find the setField method:

/**
   * 设置记录的某个字段值
   * 支持使用数据库字段和方法
   * @access public
   * @param string|array $field 字段名
   * @param string $value 字段值
   * @return boolean
   */
  public function setField($field,$value='') {
    if(is_array($field)) {
      $data      =  $field;
    }else{
      $data[$field]  =  $value;
    }
    return $this->save($data);
  }
Copy after login

Here we see the commonly used save method, here $data[ $field] = $value; In fact, it is $data['test_number'] = array("exp","test_number 2")

Then let’s look at the most commonly used save method:

##

/**
   * 保存数据
   * @access public
   * @param mixed $data 数据
   * @param array $options 表达式
   * @return boolean
   */
  public function save($data='',$options=array()) {
    if(empty($data)) {
      // 没有传递数据,获取当前数据对象的值
      if(!empty($this->data)) {
        $data      =  $this->data;
        // 重置数据
        $this->data   =  array();
      }else{
        $this->error  =  L('_DATA_TYPE_INVALID_');
        return false;
      }
    }
    // 数据处理
    $data    =  $this->_facade($data);
    // 分析表达式
    $options  =  $this->_parseOptions($options);
    $pk     =  $this->getPk();
    if(!isset($options['where']) ) {
      // 如果存在主键数据 则自动作为更新条件
      if(isset($data[$pk])) {
        $where[$pk]     =  $data[$pk];
        $options['where']  =  $where;
        unset($data[$pk]);
      }else{
        // 如果没有任何更新条件则不执行
        $this->error    =  L('_OPERATION_WRONG_');
        return false;
      }
    }
    if(is_array($options['where']) && isset($options['where'][$pk])){
      $pkValue  =  $options['where'][$pk];
    }    
    if(false === $this->_before_update($data,$options)) {
      return false;
    }    
    $result   =  $this->db->update($data,$options);
    if(false !== $result) {
      if(isset($pkValue)) $data[$pk]  = $pkValue;
      $this->_after_update($data,$options);
    }
    return $result;
  }
Copy after login

The most important thing is $options = $this->_parseOptions($options); and $result = $this-> ;db->update($data,$options); The former converts the parameters into a string array for splicing sql, and the latter calls update under proj\tptest\ThinkPHP\Library\Think\Db.class.php Method:

/**
   * 更新记录
   * @access public
   * @param mixed $data 数据
   * @param array $options 表达式
   * @return false | integer
   */
  public function update($data,$options) {
    $this->model =  $options['model'];
    $sql  = 'UPDATE '
      .$this->parseTable($options['table'])
      .$this->parseSet($data)
      .$this->parseWhere(!empty($options['where'])?$options['where']:'')
      .$this->parseOrder(!empty($options['order'])?$options['order']:'')
      .$this->parseLimit(!empty($options['limit'])?$options['limit']:'')
      .$this->parseLock(isset($options['lock'])?$options['lock']:false)
      .$this->parseComment(!empty($options['comment'])?$options['comment']:'');
    return $this->execute($sql,$this->parseBind(!empty($options['bind'])?$options['bind']:array()));
  }
Copy after login

In the end, we actually used the execute method of the driver class proj\ThinkPHP\Library\Think\Db\Driver\Mysql.class.php.

/**
   * 执行语句
   * @access public
   * @param string $str sql指令
   * @return integer|false
   */
  public function execute($str) {
    $this->initConnect(true);
    if ( !$this->_linkID ) return false;
    $this->queryStr = $str;
    //释放前次的查询结果
    if ( $this->queryID ) {  $this->free();  }
    N('db_write',1);
    // 记录开始执行时间
    G('queryStartTime');
    $result =  mysql_query($str, $this->_linkID) ;
    $this->debug();
    if ( false === $result) {
      $this->error();
      return false;
    } else {
      $this->numRows = mysql_affected_rows($this->_linkID);
      $this->lastInsID = mysql_insert_id($this->_linkID);
      return $this->numRows;
    }
  }
Copy after login

Finally, use the bottom mysql_query to execute the SQL statement.

So far, the source code of setInc has been roughly reviewed. I believe everyone has a better understanding of how setInc is executed.

The above comprehensive analysis of the source code of the thinkphp3.2.0 setInc method is all the content shared by the editor. I hope it can give you a reference, and I also hope that everyone will support the PHP Chinese website.

Related recommendations:

PHP Examples of using binary to save user status PHP skills

PHP Redis message queue to achieve high concurrency Examples of registrant statistics php examples

laravel ORM Only several methods of opening created_at summarize php examples

The above is the detailed content of thinkphp3.2.0 setInc method source code comprehensive analysis of php examples. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!