ThinkPHP implements conversion of database query result data to corresponding types

不言
Release: 2023-03-30 14:52:01
Original
2362 people have browsed it

This article mainly introduces ThinkPHP's method of converting database query result data to the corresponding type, involving thinkPHP model class operations and related modification methods for source code files. Friends in need can refer to the examples of this article

Describes ThinkPHP's method of converting database query result data to the corresponding type. Share it with everyone for your reference, the details are as follows:

I recently used ThinkPHP3.2.3 for API development and found that all field value types returned by ThinkPHP3.x when querying the database are String. I didn't pay much attention to this when I was developing the web in the past, but now I find it difficult to develop using APIs. The data type is wrong, and the client cannot force-convert each field by itself.

After checking the information, I found that Model.class.php of ThinkPHP3.x provides the _parseType method to perform type conversion after querying, but we need to manually adjust it.

You need to write a Model base class yourself:

MBaseModel.class.php inherits from Model

use Think\Model;
class BaseModel extends Model
{
  protected function _after_select(&$resultSet, $options)
  {
    parent::_after_select($resultSet,$options);
    foreach ($resultSet as &$result) {
      $this->_after_find($result, $options);
    }
  }
  protected function _after_find(&$result, $options)
  {
    parent::_after_find($result,$options);
    foreach ($result as $field => $value) {
      $this->_parseType($result, $field);
    }
  }
}
Copy after login

Then all yourself The Model classes written all inherit from MBaseModel.

Note: The above two methods must be written into the subclass of Model.

Originally, this was done, but I found a low-level bug in the _parseType method of Model.class.php:

/**
* 数据类型检测
* @access protected
* @param mixed $data 数据
* @param string $key 字段名
* @return void
*/
protected function _parseType(&$data,$key) {
    if(!isset($this->options['bind'][':'.$key]) && isset($this->fields['_type'][$key])){
      $fieldType = strtolower($this->fields['_type'][$key]);
      if(false !== strpos($fieldType,'enum')){
        // 支持ENUM类型优先检测
      }elseif(false === strpos($fieldType,'bigint') && false !== strpos($fieldType,'int')) {
        $data[$key]  = intval($data[$key]);
      }elseif(false !== strpos($fieldType,'float') || false !== strpos($fieldType,'double')){
        $data[$key]  = floatval($data[$key]);
      }elseif(false !== strpos($fieldType,'bool')){
        $data[$key]  = (bool)$data[$key];
      }
    }
}
// 上面第13行修改为
}elseif(false !== strpos($fieldType,'bigint') || false !== strpos($fieldType,'int') || false !== strpos($fieldType,'tinyint')) {
Copy after login

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

thinkPHP database addition, deletion, modification and query operations

thinkPHP5 method of adding content to the database

thinkphp3.2.3 version database addition, deletion, modification and query implementation code

The above is the detailed content of ThinkPHP implements conversion of database query result data to corresponding types. For more information, please follow other related articles on the PHP Chinese website!

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