Yii 2.0 Left Join Search Code Demo

Yii 2.0 Framework Left Join Search Code Demo
2016-12-14 14:24:30 0 Comments Linux Boy.Lee

2017 Centos 6 Web Server iptables Classial Config Rules List

In LNMP(Centos 6+nginx+php-fpm+mysql) Web Server Produce Env, list and explain all useful iptables rules, you can direct pick need rule out and use it for your own iptables config,

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
2016-08-01 17:31:21 4 Comments Linux Boy.Lee

Centos Regular Auto-backup MySQL Database and send to email address

Centos use Cron do Regular Auto-Backup for MySQL database, and auto send email by Mutt
2016-04-19 15:15:00 0 Comments MySQL Boy.Lee

Format date field in MySQL statement

Use MySQL's date format function to format date in SQL statement
New YiiLib.com online

New YiiLib.com online

after about 1 month dev, the new Yiilib.com is online, just hope the new site can bring you some new feeliing

manage PK in Yii Framework's AR

The demo code for how to manage single or composite PK in Yii 1.0 Framework AR

use bindValue() build like statement in Yii 1.0 DAO

In Yii 1.0 DAO mode, use bindValue() build like statement
2012-01-02 16:54:13 0 Comments PHP Boy.Lee

phpMyAdmin #2002 Login Failure

After install phpMyAdmin, got #2002 error, it's because config wrong so MySQL server is not responding

Start,Restart,Stop Mysql Service in Mac Os X

Command for Start,Restart,Stop Mysql Service in Mac Os X
2011-11-04 15:19:24 0 Comments MySQL Boy.Lee

MySQL Error : system error: 61

the solution for fix MySQL Error system error: 61

Dynamic change Database connection parameter in Yii

use dynamic change idea let Yii::app()->db service multi-models in Yii 1.0 Framework

get a rand record from DB.Table

a very cool way to get a rand record from MySQL Table

Yii 1.0 Show SQL Statement in footer

in Yii 1.0 Framework Show SQL Statement in footer

MySQL Transaction in Yii 1.0

use MySQL Transaction in Yii 1.0 Framework
2011-04-06 14:37:09 0 Comments MySQL Boy.Lee

MySQL Schema optimize

MySQL Schema optimize suggestion