Share Link via Laravel Raw Raw

Bookmark.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class Bookmark extends Model
{
    /**
     * @var array
     */
    protected  $fillable=['bm_url','category' ];

    /**
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */ 
    public function user()
    {
        return $this->belongsTo(User::class);
    }

    /**
     * @param $id
     * @return mixed
     */
    public static function getBookmark($id){
        return Bookmark::find($id);
    }

    /**
     * @return mixed
     */
    public static function getBookmarks(){
        return DB::table('bookmarks')->orderBy('id', 'desc')->get();
    }

    /**
     * @return mixed
     */  
public  static function getCategories(){
return       $categories=DB::table('bookmarks')->select ('category')->distinct()->get();    }

    /**
     * @param $category
     * @return mixed
     */
public  function  getCategoryBookmarks($category){
    $categoriess=DB::table('bookmarks')->where('category', $category)->get();
    return $categoriess;


}

}