Howard Lee Cloud

By Howard Lee 25 June 2017

例如我們要更新某一筆資料，使用悲觀鎖寫法不囉唆，開始提供 PHP 範例寫法： // 查出單筆的資料 $sqlA = "SELECT * FROM your_table_name1 WHERE u_id = " . $obj->id . " FOR UPDATE "; // $obj->id 是我自定義的變數 //

軟體工程 php stmt 的 bind_param 在大量連續向資料庫操作可以只做一次, 以加速執行時間

By Howard Lee 25 June 2017

有時因為營運上的需求，會需要在資料庫先行大量新增、更新或刪除某些資料，在迴圈外寫下 bind_param()，而不是在迴圈內每個執行回合裡寫下

軟體工程加入 setTimeout 函式，解決追蹤使用狀況事件完成前被轉址功能轉走

By Howard Lee 03 May 2017

在嘗試埋設追蹤使用者操作情況事件時，常會遇到尚未完成紀錄使用者操作事件，就被網頁轉址程式碼轉走的情形。解決方法之一，是讓轉址程式碼一定要在追

軟體工程 Don’t refine coding style, debug/add functions simultaneously when you write codes with other people

By Howard Lee 10 April 2017

Don’t refine coding style and debugging/adding functions in same time when you co-working with others. For example, you may change a php file from no standard applied to be PSR2. This is because it’s hard to know through git or other common diff tools what code you have changed even though you just remove redundant spaces or identations. I recommend teams, whose consider refining your own code for reducing tech

軟體工程 Vim editor config for my php, ruby and rails environment

By Howard Lee 02 April 2017

I 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

軟體工程 PHP array_uintersect() 執行結果不如預期

By Howard Lee 17 January 2017

最近遇到使用 PHP 函式庫的 array_uintersect() ，去找出兩陣列有相同的元素，不過執行結果不如預期。目前仍未找到解法，希望藉寫下紀錄，提醒自己以後找到解法再回來補上。

About

Category

Tag

Social