軟體工程
Laravel 5.5 ORM 的 ( cond1 and cond2) OR (cond3 and cond4) 寫法
假設兩個 Model : A, B, 一對一關係，例如 A has B, B belongs A，當要撈出 A 中有 B 且符合 在 B 的篩選欄位條件。A 是 Post 貼文, B 是 Comment 評論，A 和 B 的更新日期時間欄位都是
read more
假設兩個 Model : A, B, 一對一關係，例如 A has B, B belongs A，當要撈出 A 中有 B 且符合 在 B 的篩選欄位條件。A 是 Post 貼文, B 是 Comment 評論，A 和 B 的更新日期時間欄位都是
read moreRefer from link: http://laragems.com/post/a-quick-way-to-display-a-sql-query-in-tinker Please enter tinker command: php artisan tinker Type below code: DB::listen(function ($query) { dump($query->sql); dump($query->bindings); dump($query->time); }); And from above line on, every ORM manipulation you type will show what transformed SQL is.
read more
Howard Lee, Frontend-engineer with Typescript, JavaScript, HTML, CSS, Angular 19+, ReactJS, Next.js, GraphQL, Tanstack Query, Material-UI, Cypress, Postgres, Amazon Web Services, Google Cloud Platform Docker and TestCafe. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Team-management, form-filling, form-sharing, file-management, repair-management and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.
Know More