使用GoogleDrive同步VSCode的snippets

VSCode的snippet位置
%USERPROFILE%\AppData\Romaing\Code\User\snippets\


進入snippet目錄
cd %USERPROFILE%\AppData\Romaing\Code\User

先將原本的snippets目錄改名
rename snippets snippets.old

再建立snippet的目錄連結
mklink /D "snippets" "D:\GoogleDrive\sync\vscode\snippets"

Debian 9 Install PHP 5.6 Debian9安裝php5.6筆記

apt-get --assume-yes install ca-certificates apt-transport-https
wget -q https://packages.sury.org/php/apt.gpg -O- | apt-key add -
echo "deb https://packages.sury.org/php/ stretch main" | tee /etc/apt/sources.list.d/php.list
apt-get update
apt-get --assume-yes install php5.6 php5.6-mysql


apt-get --assume-yes install apache2
apt-get --assume-yes install mysql-server

wget 錯誤:ERROR: The certificate of `url' is not trusted. 處理方式

使用wget抓檔時 如果是https，有時會出現如下錯誤：

ERROR: The certificate of `url' is not trusted.
ERROR: The certificate of `url' hasn't got a known issuer.

解決方式如下：
1.
#apt-get install ca-certificates

2.
#wget --no-check-certificate https://download/url

Sublime Text 3 在不同電腦間同步設定 使用Dropbox

MAC
假設Dropbox目錄在 ~/Dropbox/
建目錄 ~/Dropbox/sync/SublimeText/

到Sublime目錄
cd ~/Library/Application\ Support/Sublime\ Text\ 3/Packages/

把User目錄整個搬到~/Dropbox/sync/SublimeText/
mv User ~/Dropbox/sync/SublimeText/

建連結
ln -s ~/Dropbox/sync/SubilmeText/User


Windows
cd C:\Users\USERNAME\AppData\Roaming\Sublime Text 3\Packages
mklink /D "User" "\Dropbox\sync\SublimeText\User"

ASP.NET 連接Mysql 語法記錄

string ConnString = System.Configuration.ConfigurationManager.ConnectionStrings["MysqlConnectionString"].ToString();
string sql = "";

MySqlConnection conn = new MySqlConnection(ConnString);
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter da = new MySqlDataAdapter();

cmd.Connection = conn;

sql = "INSERT INTO table (var1,var2) VALUES (@v1,@v2);SELECT LAST_INSERT_ID()";
cmd.CommandText = sql;

da.SelectCommand = cmd;
da.SelectCommand.Parameters.AddWithValue("@v1", 1);
da.SelectCommand.Parameters.AddWithValue("@v2", "AA");

DataTable dt = new DataTable();
da.Fill(dt);

last_insert_id = dt.Rows[0][0].ToString();

CSS Flex 筆記

主軸,次軸

啟用: 父層設定 display:flex

justify-content: flex-start , center , flex-end
justify-content: space-around , space-between

資料流 橫:左到右  直:上到下

align-items(單行子物件) align-content(多行子物件)
align-items: flex-start , center , flex-end , stretch

flex-wrap:wrap;(換行) nowrap/wrap/wrap-reverse
flex-direction:row; //( row/column/row-reverse/column-reverse )
整合flex-direction,flex-wrap
flex-flow:row wrap;

align-self: flex-start;

延展比:flex-grow //剩下來的空間做分配
收縮比:flex-shrink //
基本比:flex-basis //控制主軸方向的長度

XAMPP MAC 更換Documentroot

mkdir /Users/vega/xampp

/Applications/XAMPP/etc/httpd.conf

DocumentRoot "/Users/vega/xampp"

...

/Applications/XAMPP/etc/extra/http-ssl.conf
DocumentRoot "/Users/vega/xampp/"