Backend Development
PHP Tutorial
Eloquent updates multiple records in batches (update if they exist, insert if they do not exist)
Eloquent updates multiple records in batches (update if they exist, insert if they do not exist)
Eloquent updates multiple records in batches (update if they exist, insert if they do not exist)
It is not a batch assignment of multiple fields in one record.
Similar to batch insert:
<code>DB::table('users')->insert(array(
array('email' => 'aaa@example.com', 'name' => 'zhangsan', 'age'=> 0),
array('email' => 'bbb@example.com', 'name' => 'wangwu', 'age'=> 0),
...
));
</code>Is there any similar sentence:
<code>DB::table('users')->update( array(
array('email' => 'aaa@example.com', 'name' => 'zhangsan', 'age'=> 20),
array('email' => 'bbb@example.com', 'name' => 'wangwu', 'age'=> 25),
array('email' => 'ccc@example.com', 'name' => 'chenliu', 'age'=> 50),
...
) , 'email' );
</code>The functions implemented are:
1. When the query conditions exist, update the original data in batches;
<code>例： email='aaa@example.com'时， 'age'修改为 20, email='bbb@example.com'时， 'age'修改为 25, ... </code>
2. When the query conditions do not exist, insert data in batches.
<code>例： email='ccc@example.com'时， 'age'修改为 50, ... </code>
My code is:
<code>public function updateOrCreate (Request $request) {
$insert_array = [];
$datas = $request->all();
foreach ($datas as $key=> $data) {
$user = User::where('email', $data['email'])->first();
if (!$user) {
$insert_array[] = $data;
// 更新原数据
} else {
$user->email = $data['email'];
$user->age = $data['age'];
$user->save();
}
}
// 批量插入数据
User::insert($insert_array);
}
</code>The above code will cause performance problems when the number of updated data is more than a thousand!
Please advise, is there a better solution?
Please give me more advice.
Reply content:
Eloquent updates multiple records in batches (update if they exist, insert if they do not exist)
It is not a batch assignment of multiple fields in one record.
Similar to batch insert:
<code>DB::table('users')->insert(array(
array('email' => 'aaa@example.com', 'name' => 'zhangsan', 'age'=> 0),
array('email' => 'bbb@example.com', 'name' => 'wangwu', 'age'=> 0),
...
));
</code>Is there any similar sentence:
<code>DB::table('users')->update( array(
array('email' => 'aaa@example.com', 'name' => 'zhangsan', 'age'=> 20),
array('email' => 'bbb@example.com', 'name' => 'wangwu', 'age'=> 25),
array('email' => 'ccc@example.com', 'name' => 'chenliu', 'age'=> 50),
...
) , 'email' );
</code>The functions implemented are:
1. When the query conditions exist, update the original data in batches;
<code>例： email='aaa@example.com'时， 'age'修改为 20, email='bbb@example.com'时， 'age'修改为 25, ... </code>
2. When the query conditions do not exist, insert data in batches.
<code>例： email='ccc@example.com'时， 'age'修改为 50, ... </code>
My code is:
<code>public function updateOrCreate (Request $request) {
$insert_array = [];
$datas = $request->all();
foreach ($datas as $key=> $data) {
$user = User::where('email', $data['email'])->first();
if (!$user) {
$insert_array[] = $data;
// 更新原数据
} else {
$user->email = $data['email'];
$user->age = $data['age'];
$user->save();
}
}
// 批量插入数据
User::insert($insert_array);
}
</code>The above code will cause performance problems when the number of updated data is more than a thousand!
Please advise, is there a better solution?
Please give me more advice.
1. Change the query to a DB operation
2. Do not have a query operation in foreach
3. You can assemble all emails into one query statement, and the server will compare which record currently exists
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1423
52
1318
25
1269
29
1248
24
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
The Continued Use of PHP: Reasons for Its Endurance
Apr 19, 2025 am 12:23 AM
What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.
How to learn Laravel How to learn Laravel for free
Apr 18, 2025 pm 12:51 PM
Want to learn the Laravel framework, but suffer from no resources or economic pressure? This article provides you with free learning of Laravel, teaching you how to use resources such as online platforms, documents and community forums to lay a solid foundation for your PHP development journey from getting started to master.
Laravel user login function
Apr 18, 2025 pm 12:48 PM
Laravel provides a comprehensive Auth framework for implementing user login functions, including: Defining user models (Eloquent model), creating login forms (Blade template engine), writing login controllers (inheriting Auth\LoginController), verifying login requests (Auth::attempt) Redirecting after login is successful (redirect) considering security factors: hash passwords, anti-CSRF protection, rate limiting and security headers. In addition, the Auth framework also provides functions such as resetting passwords, registering and verifying emails. For details, please refer to the Laravel documentation: https://laravel.com/doc
Laravel framework installation method
Apr 18, 2025 pm 12:54 PM
Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.
How to view the version number of laravel? How to view the version number of laravel
Apr 18, 2025 pm 01:00 PM
The Laravel framework has built-in methods to easily view its version number to meet the different needs of developers. This article will explore these methods, including using the Composer command line tool, accessing .env files, or obtaining version information through PHP code. These methods are essential for maintaining and managing versioning of Laravel applications.
What versions of laravel are there? How to choose the version of laravel for beginners
Apr 18, 2025 pm 01:03 PM
In the Laravel framework version selection guide for beginners, this article dives into the version differences of Laravel, designed to assist beginners in making informed choices among many versions. We will focus on the key features of each release, compare their pros and cons, and provide useful advice to help beginners choose the most suitable version of Laravel based on their skill level and project requirements. For beginners, choosing a suitable version of Laravel is crucial because it can significantly impact their learning curve and overall development experience.
The difference between laravel and thinkphp
Apr 18, 2025 pm 01:09 PM
Laravel and ThinkPHP are both popular PHP frameworks and have their own advantages and disadvantages in development. This article will compare the two in depth, highlighting their architecture, features, and performance differences to help developers make informed choices based on their specific project needs.
