Javascript获取url地址中的get参数

 function getQueryValue(key) {
     var query = decodeURIComponent(window.location.search.substring(1));
     var items = query.split("&");
     for (var i = 0; i < items.length; i++) {
          var pair = items[i].split("=");
          if (pair[0] === key) return pair[1]
     }
     return false;
 }

网页通过Javascript调用发送短信请求
iOS
window.location.href = 'sms:' + smsServerNumber.replace(' ', '') + '&body=' + smsCode;
Android
window.location.href = 'sms:' + smsServerNumber.replace(' ', '') + '?body=' + smsCode;

Discuz手机版链接PC不能访问处理，修改文件./source/class/discuz/discuz_application.php第755行左右，将dheader("Location:misc.php?mod=mobile");注释掉

解决"Error detected while processing /root/.vimrc:"
修改Linux默认编辑器 vim /root/.bashrc添加:export EDITOR=/usr/bin/vim

YII2获取当前SQL语句
$query->createCommand()->getRawSql();

MySQL : explain sql

分卷压缩gz

tar zcf - 2017.log |split -d -b 100m - logs.tar.gz. 

生成文件: logs.tar.gz.00 logs.tar.gz.01

解压gz分卷

cat logs.tar.gz* | tar zx

wget 下载整站

wget -r -p -np -k site:url

Git pull 强制覆盖本地文件

git fetch --all  
git reset --hard origin/master 
git pull

设置不同的事务隔离级别

set session transaction isolation level read uncommitted;
set session transaction isolation level read committed;
set session transaction isolation level repeatable read;
set session transaction isolation level serializable;