How to make Copy or Duplicate table row in laravel

Created at 16-Mar-2021 , By samar

How to make Copy or Duplicate table row in laravel

In this session, we will try our hand at solving the "How to make Copy or Duplicate table row in laravel".

  • Make Copy or Duplicate table row in laravel using replicate method

    --PATH app\Http\Controllers\<YourController.php>
    Post::find($id)->replicate()->save();
    

    This code snippet makes an exact copy or duplicate table row in laravel, and saves it into the database with unique id value (which is a primary id of table with auto increment) and it changes the created_at and updated_at field value with current timestamp value as per your table structure.

  • Clone model and modify existing data in laravel

    --PATH app\Http\Controllers\<YourController.php>
    $new_title = "This is a new title for post";
    $new_data = "Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes";
    
    $post = Post::find($id);
    $newPost = $post->replicate();
    $newPost->title = $new_title;
    $newPost->data = $new_data;
    $newPost->save();
    

    Clone model and modify existing data in laravel, If you want to make a copy of a row in a table and also change some column data before saving it to the database. You can change it by assigning a value to column using column name on a newly created model instance after replicate method. All the values of columns of the newly created post will be the same except the title and data or changed as per your table structure like id (which is a primary key with auto increment), created_at and updated_at fields (current timestamp).

  • Replicate model and it’s relationship

    --PATH app\Http\Controllers\<YourController.php>
    $post = Post::find($id);
    $newPost = $post->replicate();
    $newPost->push(); 
     
    foreach($post->tags as $tag)
    {
        $newPost->tags()->attach($tag);
    }
     
    foreach($post->categories as $category)
    {
        $newPost->categories()->attach($category);
    }
    

    If your post has categories and tags. You can copy it and save it to the database. You can use the attach() method on a models relation, to insert categories and tags on the pivot table to the newly created record. You have to get id of post which you want to make duplicate and assign to $id variable.

Back to code snippet queries related laravel

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Buy Me A Coffee

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.