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/"

Javascript 強制轉換至https網址

if (location.protocol != 'https:'){
location.replace( 'https:' + window.location.href.substring(window.location.protocol.length) );
}

Grocery_crud CKEditor 客製化功能選單

Grocerycrud CKEditor客製化功能選單，留下常用的功能選單

/assets/grocery_crud/js/jquery_plusins/config/jquery.ckeditor.config.js
$(function(){
$( 'textarea.texteditor' ).ckeditor({toolbar:'MyBasic'});
$( 'textarea.mini-texteditor' ).ckeditor({toolbar:'MyBasic',width:700});
});

/assets/grocery_crud/texteditor/config.js
CKEDITOR.editorConfig = function( config )
{
CKEDITOR.config.toolbar_MyBasic =
[
[ 'Source','ShowBlocks','Maximize','Cut','Copy','Paste','PasteText','PasteFromWord','-','Undo','Redo','Bold','Italic','Underline','Strike','Subscript','Superscript','-','RemoveFormat'],
'/',
['Image','Table','HorizontalRule','Link','Unlink','Anchor'],
'/',
['Styles','Format','Font','FontSize','TextColor','BGColor' ]
];
};