碎片

  • https://bbbootstrap.com/snippets/custom-radio-button-91048657

  • ```bash 3 WARNINGS in child compilations (Use 'stats.children: true' resp. '--stats-children' for more details) ``` ```bash npm install autoprefixer@10.4.5 --save-exact ``` The color-adjust shortha...

  • Laravel 8.6 jetstream 2.4 剛好適用無衝突

  • Keyword Surfer SEO Minion Gmass Detailed SEO Google Search Console Bing Webmaster Tools Merkle Screaming Frog Ahrefs Answer The Public Koray Interview Ubersuggest Rank Math Keyword Hero

  • https://laravel-excel.com/

  • https://alternativeto.net/

  • https://sli.dev/

  • 以expo為主入手

  • ```php $img = "https://xxxxx.com/1234.png"; //普通save $file = Image::make($img)->save('public/bar.png'); //等比例剪裁 $file = Image::make($img)->fit(300, 200, function ($constraint) { $constraint->up...

  • vector可編輯/轉色 此網站有部分免費的vector可供下載 https://www.vecteezy.com/free-vector/letter-u?license-free=true

  • ```php $count = User::whereRaw('DATE(created_at) =? ', '2022-05-16')->count(); or $count = User::whereDate('created_at', '=', date($date))->count(); ```

  • ```php $chats = Message::with('sender','recipient') ->where('toId',$id) ->whereRaw('id IN (select MAX(id) FROM messages GROUP BY fromId)') ->orderBy('createdAt','desc') ->paginate(10) ```

  • ```php public function index() { $row = User::all(); return response()->json($row); } ```

  • 有朋友合作項目有需要,在此分享給他 https://flatpickr.js.org/options/ 同時這套flatpickr的確不錯,雖然界面不是我喜歡,但能脫離jQuery的確不錯 甚至連github 也有15k star

  • https://laracasts.com/discuss/channels/laravel/laravel-get-visitors-ip-location-and-city

  • http://tabulator.info/ 可以試用一下 demo ref:http://rubick.left4code.com/page/side-menu/dark/tabulator

  • ```mysql SELECT * FROM `notifications` WHERE JSON_EXTRACT(data, "$.user_name") = 'sky' ``` demo data `notifications.data` ```json {"id": "1", "user_name ": "sky"} {"id": "2", "user_name ": "Joe...

  • 一定要小心使用 ```php use Illuminate\Support\Facades\DB; //...... DB::unprepared(); ``` These are all prepared statement to prevent SQL injection into database. However you might needed to run query...

  • https://output.jsbin.com/xepererege/ ```javascript // Nested demo var nestedSortables = [].slice.call(document.querySelectorAll('.nested-sortable')); // Loop through each nested sortable element for...

  • https://jsfiddle.net/6au1onme/1/