Check if exist and create

Question

I try generate and save uncial slug for title in DB.

                $feed->friendlyUrl()->make([
                'url' => str_slug($feed->name),
                'action' => "feeds/{$feed->id}",
                'complicated' => false,
                'page_type_id' => PageType::TYPE_INDIVIDUAL_FEED_PAGE,
            ]);

How check if such field in url exist? And if exist save:

'url' => str_slug($feed->name,"-1"),

I think:

  if (FriendlyUrl::whereUrl(str_slug($feed->name))){
            $feed->friendlyUrl()->make([
                'url' => str_slug($feed->name),
                'action' => "feeds/{$feed->id}",
                'complicated' => false,
                'page_type_id' => PageType::TYPE_INDIVIDUAL_FEED_PAGE,
            ]);} else {
                $feed->friendlyUrl()->make([
                    'url' => str_slug($feed->name),
                    'action' => "feeds/{$feed->id}-1",
                    'complicated' => false,
                    'page_type_id' => PageType::TYPE_INDIVIDUAL_FEED_PAGE, 
            };
            break;

But it not clean and what if such url - str_slug($feed->name,"-1") already exists?

Please check - https://stackoverflow.com/questions/18839941/insert-a-new-record-if-not-exist-and-update-if-exist-laravel-eloquent — Sachin Vairagi, Dec 07 '17 at 14:28

score 1 · Answer 1 · answered Dec 07 '17 at 14:33

You can use this :

$friendlyUrl = friendlyUrl::firstOrNew(
    ['url' => str_slug($feed->name,"-1")], [
                'action' => "feeds/{$feed->id}",
                'complicated' => false,
                'page_type_id' => PageType::TYPE_INDIVIDUAL_FEED_PAGE,]
);

$friendlyUrl->save();

score 1 · Answer 2 · answered Dec 07 '17 at 14:46

Unique slug for title

public static function boot()
           {
               parent::boot();

           static::creating(function($model) {
               $model->slug = str_slug($model->ToBeSluggified);// change the ToBeSluggiefied

               $latestSlug =
                   static::whereRaw("slug = '$model->slug' or slug LIKE '$model->slug-%'")
                       ->latest('id')
                       ->value('slug');
               if ($latestSlug) {
                   $pieces = explode('-', $latestSlug);

                   $number = intval(end($pieces));

                   $model->slug .= '-' . ($number + 1);
               }
           });
       }

score 0 · Answer 3 · answered Dec 07 '17 at 14:32

Try this -

$FriendlyUrl = FriendlyUrl::firstOrNew(array('url' => str_slug($feed->name)));
$FriendlyUrl->action = "feeds/{$feed->id}";
$FriendlyUrl->complicated = false;
$FriendlyUrl->page_type_id = PageType::TYPE_INDIVIDUAL_FEED_PAGE;
$FriendlyUrl->save();

Reference - Insert a new record if not exist and update if exist, laravel eloquent

Check if exist and create

3 Answers3