ThinkPHP3.2 framework uses addAll() to insert data in batches

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 the model class in thinkphp 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 method of inserting 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:

Convert<b>thinkphp</b> into "thinkphp"

//name字段有html标签
$data['name'] = '<b>thinkphp</b>';
$data['sex'] = '1';
$User = M('demo');
// 写入数据库的时候会把name字段的值<b>thinkphp</b>转化为“thinkphp”
$User->data($data)->filter('strip_tags')->add();

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:

Thinkphp5.0's method of automatically generating modules and directories

ThinkPHP framework implements session cross-domain issues

Perfect solution to the problem of inserting the same data in Thinkphp3.2

The above is the detailed content of ThinkPHP3.2 framework uses addAll() to insert data in batches. For more information, please follow other related articles on the PHP Chinese website!