![]() ![]() In case it returns false, an error message with status 400 will be responded.įinally, if the user got correctly updated, we render the updated user as a response. Otherwise, it would be necessary to use a try/catch block and the number of lines would be pretty much the same.Īs in the previous example, we have a conditional where we are calling $user->update() with the data that we want to update. To make the most out of this change, we need to know how to automate the handling of the exception thrown by the findOrFail(). ![]() This function has a special behavior where an exception gets thrown in case the data for the given ID didn't get found. Here we are checking if the name: Niketan Vaahi is present in the table, if not the record with details given in the second param will be inserted.Enter fullscreen mode Exit fullscreen modeĪt the first line, we are querying a user by its ID using the findOrFail() function. ![]() Using updateOrInsert() with DB Facade to insert. The output of the above code is +-+-+-+-+-+-+-+ In the above case, it will search in the table for the key/values pairs given in the first params, if there is a matching record the same will be updated or the insert will take place. Using it you can try all the SQL queries. DB Facade is a query builder tool used in Laravel. To make use of the DB facade you need to use the class: use Illuminate\Support\Facades\DB or just use DB. Using updateOrInsert() with DB Facade to update. In the above example, we are trying to update the age of 50 for the name Rehan. We tried to insert a value since it did not exist, let us now try the example to update the record in the table. | id | name | email | created_at | updated_at | address | age | Since there is no match for the name:Arbaaz in the student table the value is inserted in the table. The first value in the array is used to search in the table if it exists, and if not it will insert the value or it will update for the match of the first parameters in the array. The syntax for updateOrCreate() is as follows − $flight = Model::updateOrCreate( This method will take care of either inserting the record if it does not exist or it will update the record if it already exists. ![]() We are going to make use of the method updateOrCreate() to insert or update the item inside the student table. | 8 | Priya Singh | | NULL | NULL | test123 | 20 | | 7 | Viraj Desai | | NULL | NULL | test | 18 | | 6 | Ashvik Khanna | | NULL | NULL | oooo | 16 | | 5 | Nidhi Agarwal | | NULL | NULL | abcd | 20 | | 4 | Rehan | | NULL | NULL | abcd | 15 | | 3 | Rehan Khan | | NULL | NULL | testing | 20 | | id | name | email | created_at | updated_at | address| age| Assume we have created a table named students using the CREATE statement as shown below − CREATE TABLE students (Īssume we have populated the above table with the following data − +-+-+-+-+-+-+-+ ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |