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 |