開機自動執行

apt-get install sysv-rc

/etc/update-rc.d script.sh defaults 50

存取二個input欄位的值

function check(source,target)
{
var Input2 = document.getElementById(target);
input2.value = source.value;
}

選擇SELECT項目後，在另一個欄位填入對應值

[select name=example]
[option value="A"]A[/option]
[option value="B"]B[/option]

exarray = new Array();

exarray[0]="a";
exarray[1]="b";

function check()
{
 temp=exarray[document.form_name.example.selectedIndex]

 document.form_name.input_name.value;
}

PHP日期函數

date('Y-m-d') //0000-00-00
date('H:i:s') //00:00:00

netstat 統計連線狀態數量

netstat -n awk '/^tcp/{++S[$NF]} END {for(a in S) print a,S[a]}'
TIME_WAIT 6
ESTABLISHED 4
LAST_ACK 3

PHP之PDO於MYSQL之[新增][修改][刪除]

[新增]

$sql = "INSERT INTO table_name(col1,col2,......coln) VALUES($var1,$var2,......$varn)";

$result = $db->exec($sql);

[修改]

$sql = "UPDATE dbname SET col1='$var1',col2='$var2',......coln='$varn' WHERE ......";
$result = $db->prepare($sql);
$result->execute();

[刪除]

$sql = "DELETE FROM dbname WHERE id=".$id."";
$result = $db->exec($sql);

[$db->prepare另外用法]

$sql = "UPDATE table_name SET col1=? WHERE col2=? AND col3=?";
$result = $db->prepare($sql);
$result->execute(array($var1,$var2,$var3));