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/



Labels:

Comments

Post a Comment

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...
Post a Comment
Read more

Redis installation in Red Hat Linux

 In this post we will see step by step installation of Redis service in Redhat/CentOS operation system. To install Redis, run this command in terminal -dnf install redis This command will install the redis service in your machine. Verify installation -systemctl status redis -systemctl start redis -systemctl enable redis Note: Before start redis service set Linux Kernal overcommit memory to 1 by adding vm.overcommit_memory = 1 to /etc/sysctl.conf file. Why we should do that: As we know redis is in memory data store. It primarily uses RAM to store data. Redis and other processes use RAM memory. We set vm.overcommit_memory = 1 to make sure Kernal not overcommit the memory by allocating memory to new program which required more memory than available memory. In this scenario OOM (Out Of Memory) killer terminate the rest of processes. We also restricting Kernal not to terminate the important services running and also stop swapping redis and other importance service to device i/o device,...
Post a Comment
Read more

MySQL course to learn queries to manage DBMS.

1. Create Table CREATE TABLE statement allows you to create new table in database. The example code is given below.  create table profile( id int, name varchar(50), birth_date date, phone varchar(12), gender varchar(1) ); Code language: SQL (Structured Query Language) ( sql ) 2. Insert data in table INSERT INTO statement is use to insert new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (2, "Zaib", "1996-03-15", "9238975404", "M"); Code language: SQL (Structured Query Language) ( sql ) 3. Insert multiple records at-once INSERT INTO state is use to insert multiple new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (1, "Usamn ali", "1990-08-26", "9238785094", "M", 18, "Karachi"), (2, "Aisha", "1997-06-12", "9238974468", "F", 19, "Lahore"), ...
Post a Comment
Read more