This article mainly introduces the method of batch inserting data using addAll() in the ThinkPHP3.2 framework, and analyzes thinkPHP's related implementation skills for single data insertion and batch data insertion operations in the form of examples. Friends in need can refer to the following
The example of this article describes the method of batch inserting data using addAll() in the ThinkPHP3.2 framework. Share it with everyone for your reference, the details are as follows: The
addAll()method of themodelclass inthinkphp can add data to the database at the same time.
// 批量添加数据 (only MySQL) $user = M('user'); //array('表字段'=>'值') $dataList[] = array('name'=>'thinkphp','email'=>'thinkphp@gamil.com'); $dataList[] = array('name'=>'onethink','email'=>'onethink@gamil.com'); $insertOkInfo = $user->addAll($dataList);
The following is the insertion method of a single piece of data
$user = M('demo'); $data['name'] = 'xiaoming'; $data['sex'] = '1'; $data['age'] = '23'; // 使用add()方法将数据写入数据库 // 返回 Id $insertId = $user->add($data);
There is also a practical methodfilter()
, this method is to filter the field content into text.
The following example:
Convertthinkphpinto "thinkphp"
//name字段有html标签 $data['name'] = 'thinkphp'; $data['sex'] = '1'; $User = M('demo'); // 写入数据库的时候会把name字段的值thinkphp转化为“thinkphp” $User->data($data)->filter('strip_tags')->add();
Related articles:
thinkPHP’s sample code for simply calling functions and class library methods
thinkPHP Database Add, Delete, Modify and Check Operation Method Examples Detailed Explanation
The above is the detailed content of ThinkPHP3.2 framework uses addAll() to batch insert data.. For more information, please follow other related articles on the PHP Chinese website!