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/

```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/

https://codepen.io/vtno/pen/MXmpoy

php5.2+ ```php //$dir = delete folder $it = new RecursiveDirectoryIterator($dir, RecursiveDirectoryIterator::SKIP_DOTS); $files = new RecursiveIteratorIterator($it, RecursiveIteratorItera...

https://web-crunch.com/posts/vanilla-javascript-form-validation https://codepen.io/webcrunchblog/pen/ZEWwvZy