Skip to main content

Touch Many-to-Many Parent and sync methods in laravel

 Touch method

1) Most of the time user update data in the child table but also wants to update the user (parent) table updated_at field.

For that, you don't need to update it manually by querying it.

Use the touch method on the model object inside controller. This method will only update the updated_at field to the current date/time.

$user->touch();

2) You could also update field automatically, lets say where there is new comment on post and you also want to update post table updated_at feild at the same time than what you need to do

Inside Comment Model

define belongtomany relationship to post model class and also specify a protected variable

protected $touches = ['post'];
//post is realtional method

Sync() Method

This method is use to add multiple id's of data into pivot table with many to many relationship.

This method remove existing id's and add new id's.

If you want existing id's remian in the pivot table than you will use this code.

$book->authors()->syncWithoutDetaching([1, 2, 3]);

Useful links

https://blog.quickadminpanel.com/laravel-belongstomany-add-extra-fields-to-pivot-table/

https://laravel.com/docs/9.x/eloquent-relationships#many-to-many-polymorphic-relations

https://www.amitmerchant.com/attach-detach-sync-laravel/



Comments

Popular posts from this blog

Install MariaDB Latest Version 11.4 in Red Hat Version 9

 This this post i will show you step by step the installation process of mariaDB in red hat version 9. Step1 Run the command to pull the latest updated packages on applications installed in your system. -dnf update If you get Kernal update than reboot the system -reboot Step2 Go to official mariaDB site Make mariadb repository in /etc/yum.repos.d Place the configuration in this file # MariaDB 11.4 RedHatEnterpriseLinux repository list - created 2024-09-24 11:12 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB # rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details. # baseurl = https://rpm.mariadb.org/11.4/rhel/$releasever/$basearch baseurl = https://mirrors.aliyun.com/mariadb/yum/11.4/rhel/$releasever/$basearch # gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB gpgkey = https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB gpgcheck = 1 Now install the mariaDB with its dependencies package...

Car Company website Proposal Document.

 Car Company Website Proposal Document. What this website offers and give value to company and its customers. This site will showcase the products (vehicles) with simple and sleek design. It will show high impact vehicles images. The specification of vehicle which user can easily understand and make comparisons.  Features of this website both Front-End and Back-End side. Front-End Features 1. Landing page of website 1.1 This page will display classy look of the web design by showcasing different vehicle high resolution images. 1.2 Overview of all Services the company offering to their valuable customers 1.3 Testimonials Client feedback on your services and satisfaction with vehicle which build long term value to company and customer relationship. 1.4 Window Pop-up for showing  sales and events or any news. 2. Pages on this website 2.1 Services Page This page will demonstrate number of Maintenance Services of vehicles this company offers. Now there are two types of service...

React js Commands

Navigation   1. Install React Router Dom npm install react-router-dom npm install react-router-dom@6