軟體工程
PHP 在 MySQL 的悲觀鎖寫法
例如我們要更新某一筆資料，使用悲觀鎖寫法 不囉唆，開始提供 PHP 範例寫法： // 查出單筆的資料 $sqlA = "SELECT * FROM your_table_name1 WHERE u_id = " . $obj->id . " FOR UPDATE "; // $obj->id 是我自定義的變數 //
read more
例如我們要更新某一筆資料，使用悲觀鎖寫法 不囉唆，開始提供 PHP 範例寫法： // 查出單筆的資料 $sqlA = "SELECT * FROM your_table_name1 WHERE u_id = " . $obj->id . " FOR UPDATE "; // $obj->id 是我自定義的變數 //
read more有時因為營運上的需求，會需要在資料庫先行大量新增、更新或刪除某些資料，在迴圈外寫下 bind_param()，而不是在迴圈內每個執行回合裡寫下
read moreI use many plugin with VIM to boost development when I writing and debugging programs, which are written through PHP and Ruby languages. Also there are few plugin for SASS, RSpec and Javascript. Below are configurations for my VIM editor and Vundle. There must some corresponded software be installed in the computer first and then these settings will work. nnoremap means normal mode in VIM. Usage of <silent> tag is
read more最近遇到使用 PHP 函式庫的 array_uintersect() ，去找出兩陣列有相同的元素，不過執行結果不如預期。目前仍未找到解法，希望藉寫下紀錄，提醒自己以後找到解法再回來補上。
read more
Howard Lee is a Staff Software Engineer based in Taipei, specializing in frontend architecture, CI/CD, and production-quality engineering for enterprise web applications. With 13+ years of software development experience, Howard has worked across B2B SaaS, IoT energy-management platforms, online travel marketplaces, and Android applications. His work focuses on modernizing large frontend systems, improving delivery quality, and building reliable product workflows with automated testing, observability, and practical cloud/platform integration. Core Expertise Frontend architecture: Angular 5 to 19 modernization, TypeScript, JavaScript, React, Next.
Know More