Yii Framework and Web Dev Newest Original Tutorial Lib

2019-06-14 18:41:21 0 Comments 11 Likes MySQL Boy.Lee

MySQL Reverse PK value

Say in MySQL Database, we have movie table with 1000 rows, id from 1 to 1000, now we want reverse the PK order set 1000 to 1, 1 to 1000, we can do it like this.

2019-06-06 09:44:32 0 Comments 0 Likes Mac os X Boy.Lee

Mac os X Zip Files with Password

On Mac os X system, we usually zip file with "right click files -> select command Compress 'xxx' ", but what if we need zip file with password to protect it? we can do it with a simple shell command, it's just piece of cake, let me show you how to do it!

2019-06-03 11:27:55 0 Comments 187 Likes PHP Boy.Lee

Fix PHP Error A non well formed numeric value encountered

When we need calculate time in PHP we will used microtime function, but you may get error "A non well formed numeric value encountered"，let's see why it happen

2019-05-22 22:26:34 0 Comments 0 Likes JavaScript Boy.Lee

Javascript module import command demo in ES6

in ES 6, Javascript module import in two ways, the dynamic import and the hardcode import

2019-05-20 14:21:53 0 Comments 2 Likes Yii 2.0 Boy.Lee

Yii 2 Migration create BigInt PK

Sometime we need create BigInt PK(Primary) coloum to replace the normal Int PK, in Yii 2.0's Migration tool, you can simple use the follow command to do the work.

2019-05-18 13:44:11 0 Comments 4 Likes Mac os X Boy.Lee

Command for iTerm2 use RSA private key file login SSH server on Mac os

If you got an RSA private key file and need use it to login SSH server on Mac os system, you can direct use the follow command, it's working for Mac's Terminal too.

2019-05-15 10:15:31 0 Comments 4 Likes Vue Boy.Lee

VueJS Ajax Request Auto Cancelled via Axios

I got a very interesting issue, when I publish my new SPA project iProject online, the ajax request will auto cancelled by randon. It's the first time I face that thing, so I spent a little time to do the research.

2019-05-14 09:26:57 0 Comments 2 Likes MySQL Boy.Lee

MySQL 5.7.26 Reset Root Password on Centos 6

MySQL 5.7.26 Reset Root Password on Centos 6, I lost my root password with a mysql error, so I have to reset it, the server is Centos 6 and mysql 5.7.26, follow are the steps

2018-01-08 21:05:11 0 Comments 136 Likes JavaScript Boy.Lee

JS Javascript string to number transform

transform string to number in Javascript

2017-11-23 21:51:10 0 Comments 13 Likes Yii 2.0 Boy.Lee

Yii 2.0 use andWhere() Do and or query

In Yii 2.0 Framework, use andWhere() function run DB(MySQL) Query like A = 1 or B = 1

2017-09-19 20:34:09 0 Comments 42 Likes Mac os X Boy.Lee

ShadowSocks-NG White List Mode

Run ShadowSocks-NG with White List Mode, will only effect with user rules, this topic show how to do it.

2017-08-24 18:26:57 0 Comments 0 Likes JavaScript Boy.Lee

Javascript array sort demo

2017-08-16 21:00:04 0 Comments 0 Likes JavaScript Boy.Lee

JavaScript Native Time Format Function

2017-07-24 09:54:08 0 Comments 2 Likes Yii 2.0 Boy.Lee

Yii 2.0 DetailView Set Width Demo Code

In Yii 2.0 DetailView, sometime too long content will break page width, this time need set max-width to limit line width to switch one line to more lines, this topic show how to fix it

2017-07-11 23:26:17 0 Comments 0 Likes JavaScript Boy.Lee

Javascript Array Copy Methods Suggestion

2017-07-03 10:14:19 0 Comments 6 Likes Yii 2.0 Boy.Lee

Yii 2.0 Left Join Search Code Demo

Yii 2.0 Framework Left Join Search Code Demo