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