要更新數(shù)據(jù)庫中的記錄，首先檢索目標(biāo)記錄，再修改屬性並保存。 1. 使用find()、where() 等方法獲取模型實(shí)例；2. 修改模型屬性值；3. 調(diào)用save() 方法保存更改；4. 對(duì)於條件批量更新，可使用查詢構(gòu)造器的update() 方法；5. 注意事件和時(shí)間戳的觸發(fā)情況，並確保字段在$fillable 中或進(jìn)行適當(dāng)驗(yàn)證。整個(gè)過程簡(jiǎn)單靈活，但需謹(jǐn)慎處理輸入與邏輯依賴。

Updating existing records in a database using Eloquent is straightforward once you understand the flow. The key is to retrieve the record, modify its attributes, and then save the changes.

Find the Record You Want to Update

Before updating anything, you need to fetch the specific record from the database. This is usually done using methods like find() , where() , or other query constraints.

For example:

 $user = User::find(1);

This gets the user with an ID of 1. If you're not sure if the record exists, consider using findOrFail() which will throw an exception if nothing is found.

Sometimes you might want to use a condition instead, like:

 $user = User::where('email', 'test@example.com')->first();

Make sure that your query actually returns a model instance before trying to update it.

Modify and Save the Model

Once you have the model instance, you can change any of its properties just like you would with a regular PHP object.

For example:

 $user->name = 'New Name';
$user->email = 'newemail@example.com';
$user->save();

Calling save() on the model persists the changes back to the database. It's important to remember that this only updates the specific fields you've changed — Eloquent doesn't overwrite unrelated columns unless told to do so (eg, by using touch() or mass assignment).

• Make sure the fields you're updating are listed in the $fillable array in your model.
• Timestamps ( updated_at ) are automatically updated when you call save() .

If you're updating multiple rows at once based on a condition without needing to process each model individually, you can also use:

 User::where('active', false)->update(['name' => 'Inactive User']);

Just keep in mind that this method doesn't fire model events or update timestamps unless you handle that manually.

Handle Mass Updates Carefully

When you want to update multiple fields at once using an array, Eloquent allows this too:

 $user->update([
    'name' => 'Jane Doe',
    'email' => 'jane@example.com'
]);

This is essentially a shortcut for setting multiple attributes and calling save() .

However:

• Be cautious with mass updates if validation or access control is involved.
• Always validate input data before passing it into update() .
• Use policies or form requests if you're accepting user input directly.

Also, note that update() can be used directly on a query builder instance:

 User::where('role', 'guest')->update(['role' => 'member']);

Again, this won't trigger model events, so consider that when designing logic that depends on them.

That's basically how you update records using Eloquent. Get the record, make your changes, and save. Whether you're updating one record or many, Eloquent gives you flexible tools to get the job done — just pay attention to when events and timestamps are triggered.

以上是如何使用雄辯更新數(shù)據(jù)庫中的現(xiàn)有記錄？的詳細(xì)內(nèi)容。更多資訊請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！