Laravel: Check database for duplicate slugs and generate incrementing slug name (repeat-name-2, repeat-name-3). Found via: https://codereview.stackexchange.com/questions/162254/append-a-incrementing-number-to-a-slug-username

incrementing-slugs.php

<?php
  protected function create(array $data)
  {
      $slug = str_slug($data['first_name'] . '.' . $data['last_name']);
      $next = 2;

      // Loop until we can query for the slug and it returns false
      while (User::where('slug', '=', $slug)->first()) {
          $slug = $slug . '-' . $next;
          $next++;
      }

      return User::create([
                  'first_name' => $data['first_name'],
                  'last_name' => $data['last_name'],
                  'slug' => $slug,
                  'email' => $data['email'],
                  'password' => bcrypt($data['password']),
      ]);
  }
  ?>

Hi Ryosuke, in this example, you can use an auxiliary variable to get the expected result. :)

line 4: $slug = $slugBase = str_slug($data['first_name'] . '.' . $data['last_name']);
line 9: $slug = $slugBase . '-' . $next;