Posts
PHP MySQL Tips
Continuing from my earlier post on PHP performance, I thought I’d share a few Mysql tips that I’ve learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned.
Word searching
SELECT * FROM TABLE WHERE MATCH (`field`) AGAINST ('Keyword')
(Fastest)
Posts
標籤被放在<meta>標籤前面。當title為中文的 時(比如Blog名為中文或者文章標題為中文)，在IE下會出現顯示空白頁的問題。昨天<a href="http://dre-j.blogspot.com/">Dre·J</a>在群裡又問到這個問題，今天過來好好研究一下。</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/30/" class="link black dim">
注音 漢語拼音 preg_split 正規劃切割
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/30" callback="wp_plus_one_handler"></g:plusone>
</div>
<p>$Hupinyin = array(<br>
‘ㄅ’=>’b’,’ㄆ’=>’p’,’ㄇ’=>’m’,’ㄈ’=>’f’<br>
,’ㄉ’=>’d’,’ㄊ’=>’t’,’ㄋ’=>’n’,’ㄌ’=>’l’<br>
,’ㄍ’=>’g’,’ㄎ’=>’k’,’ㄏ’=>’h’<br>
,’ㄐ’=>’j’,’ㄑ’=>’q’,’ㄒ’=>’x’<br>
,’ㄓ’=>’zh’,’ㄔ’=>’ch’,’ㄕ’=>’sh’,’ㄖ’=>’r’<br>
,’ㄗ’=>’z’,’ㄘ’=>’c’,’ㄙ’=>’s’<br>
,’ㄚ’=>’a’,’ㄛ’=>’o’,’ㄜ’=>’e’,’ㄝ’=>’e’<br>
,’ㄞ’=>’ai’,’ㄟ’=>’ei’,’ㄠ’=>’ao’,’ㄡ’=>’ou’<br>
,’ㄢ’=>’an’,’ㄣ’=>’en’,’ㄤ’=>’ang’,’ㄥ’=>’eng’<br>
,’ㄦ’=>’er’<br>
,’ㄧ’=>’i’,’ㄨ’=>’u’,’ㄩ’=>’u’<br>
);<br>
$word = “ㄢ”;<br>
foreach ($Hupinyin as $k => $v) {<br>
if ($k == $word){<br>
echo “$word = $v <br />\n”;<br>
}<br>
}</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
<a href="https://blog.sd.idv.tw/tags/preg_split" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
preg_split
</a>
<a href="https://blog.sd.idv.tw/tags/%E6%BC%A2%E8%AA%9E%E6%8B%BC%E9%9F%B3" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
漢語拼音
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/29/" class="link black dim">
利用imagemagick來作縮圖
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/29" callback="wp_plus_one_handler"></g:plusone>
</div>
<?php
$w=”240″; //自行設定的縮圖寬度
$h=”320″; //自行設定的縮圖高度
if($\_FILES\[‘file’\]\[‘type’\]==”image/pjpeg” || $\_FILES\[‘file’\]\[‘type’\]==”image/gif” || $_FILES\[‘file’\]\[‘type’\]==”image/png”) {
if($_FILES\[‘file’\]\[‘type’\]==”image/pjpeg”) {
$filename=substr(rand(0,999999999999),1,7).”.gif”; //隨機取檔名..我的習慣啦 ^^||
}
if($_FILES\[‘file’\]\[‘type’\]==”image/gif”) {
$filename=substr(rand(0,999999999999),1,7).”.gif”;
}
if($_FILES\[‘file’\]\[‘type’\]==”image/png”) {
$filename=substr(rand(0,999999999999),1,7).”.png”;
}
$size=$w.”x”.$h;
copy($\_FILES\[‘file’\]\[‘tmp\_name’\],”/home/caisse/case/kf/data/file/b”.$filename); //將暫存檔copy至自己定義的目錄..因為小弟大小圖都想要 ^^
$big_image=”/home/caisse/case/kf/data/file/b”.$filename;
$small_image=”/home/caisse/case/kf/data/file/s”.$filename;
$exec\_str=”/usr/bin/convert ‘-geometry’ “.$size.” “.$big\_image.” “.$small_image; //注意”跟’唷
exec($exec_str);
} else {
echo “請上傳圖片”;
}
?>
<form action=”#” method=”post” enctype=”multipart/form-data” name=”form1″>
<input type=”file” name=”file”>
<input type=”submit” name=”Submit” value=”送出”>
</form>
<?php if($_FILES) { ?>
原始圖 <img src=”/data/file/b<?php echo $filename; ?>”> <br>
裁切後的圖 <img src=”/data/file/s<?php echo $filename; ?>”>
<?php } ?>
<div class="wp_plus_one_button" style="margin: 0 8px 8px 0; float:left; ">
<g:plusone href="https://blog.sd.idv.tw/archives/29" callback="wp_plus_one_handler"></g:plusone>
</div>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/imagemagick" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
imagemagick
</a>
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/28/" class="link black dim">
月曆
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/28" callback="wp_plus_one_handler"></g:plusone>
</div>
<p>STYLE TYPE=”text/css”><br>
a{text-decoration:none}<br>
<!–<br>
BODY {<br>
font-size: 12px;<br>
color:gray;<br>
text-decoration: none;<br>
font-family: Arial, Verdana, Helvetica, sans-serif;<br>
SCROLLBAR-FACE-COLOR: #fcfcd8;<br>
SCROLLBAR-HIGHLIGHT-COLOR: #fcfcd8;<br>
SCROLLBAR-SHADOW-COLOR: #fcd8b4;<br>
SCROLLBAR-3DLIGHT-COLOR: #fcd890;<br>
SCROLLBAR-ARROW-COLOR: #fcd800;<br>
SCROLLBAR-TRACK-COLOR: #fcfcd8;<br>
SCROLLBAR-DARKSHADOW-COLOR: #fcd8b4;<br>
SCROLLBAR-BASE-COLOR: #fcfcd8}<br>
A:link { font-size: 12px; color=#66ccff;}<br>
A:alink { font-size: 12px; color=#66ccff;}<br>
A:visited { font-size: 12px; color=#333333;}<br>
A:hover{ font-size: 12px; color=#fcd800; text-decoration: underline overline}<br>
TABLE {<br>
font-size: 12px<br>
}</p>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/27/" class="link black dim">
亂數取碼當成驗證碼的問題
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/27" callback="wp_plus_one_handler"></g:plusone>
</div>
<p class="msgcontent">
//此副程式的功能在於生成驗證碼圖片
</p>
<p>//重設亂數種子<br>
srand((double)microtime()*1000000);<br>
//產生一組6位數的數字<br>
$abc=substr(md5(uniqid(rand())),mt_rand(0,15),6);</p>
<p>//建立一個 80*30 畫素的圖形<br>
$img = imagecreate(80,30);</p>
<p>//設定顏色<br>
$white = imagecolorallocate($img,255,255,255);//設定背景顏色為白色<br>
$gray = ImageColorAllocate($img,150,150,150);//設定顏色為灰色</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/26/" class="link black dim">
如何秀出複數的排序條件資料
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/26" callback="wp_plus_one_handler"></g:plusone>
</div>
<p>SELECT * FROM Product ORDER BY SellDate DESC</p>
<p>因為資料的SellDate可能同時會有幾十筆都相同，我希望可以在篩選出這批資料後在更詳細的依照他們的編號去做排序…</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/mysql" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
mysql
</a>
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/25/" class="link black dim">
PHP GooGle PageRank程式
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/25" callback="wp_plus_one_handler"></g:plusone>
</div>
<?php
// Google PageRank Calculator function by ZeNiTRaM – version 0.1
// Licensed under the GPL License
// eMail me at zenitram [AT] dubmail.net
// Uses code from The Google Checksum Calculator, by Alex Stapleton, Andy Doctorow, Vijay “Cyberax” Bhatter, and a few others, licensed under the public domain (http://www.mobileread.com/forums/showpost.php?p=7769&postcount=87) and XMLize.php by Hans Anderson (http://www.hansanderson.com/php/xml/).
// Use: $pagerank = GetPagerank(“http://www.google.es”);
// GetPagerank returns a STRING with the Pagerank number directly from Google
// S P A N I S H———————————————————————————–
// Calculadora Google Pagerank por ZeNiTRaM – version 0.1
// Licenciado bajo la licencia GPL.
// Contacta conmigo en zenitram [AT] dubmail.net
// Usa codigo de The Google Checksum Calculator, por Alex Stapleton, Andy Doctorow, Vijay “Cyberax” Bhatter, y unos cuantos otros mas, licenciado bajo dominio publico (http://www.mobileread.com/forums/showpost.php?p=7769&postcount=87) y XMLize.php por Hans Anderson (http://www.hansanderson.com/php/xml/).
/*
Changelog
0.1: Started counting versions and tidied all the code. Maybe I will add some new functions to get more information from Google.
He empezado a contar versiones y limpiado un poco todo el codigo. Quizas añada nuevas funciones para conseguir mas informacion de Google.
*/
// Function GetPagerank
$a = GetPagerank(‘http://tw.yahoo.com/’);
echo $a;
function GetPagerank($urlo) {
define(‘GOOGLE_MAGIC’, 0xE6359A60);
$url = ‘info:’.$urlo;
$ch = GoogleCH(strord($url));
$chf = “6$ch”;
$file = file(“http://www.google.com/search?client=navclient-auto&ch=$chf&q=$url”);
$file_str = implode(“”, $file);
$xml = xmlize($file_str);
$pr = $xml\[“GSP”\]\[“#”\]\[“RES”\]\[0\]\[“#”\]\[“R”\]\[0\]\[“#”\]\[“RK”\]\[0\][“#”];
if(!$pr) $pr = 0;
return $pr;
}
//Starts code from XMLize.php
function xmlize($data, $WHITE=1) {
$data = trim($data);
$vals = $index = $array = array();
$parser = xml\_parser\_create();
xml\_parser\_set\_option($parser, XML\_OPTION\_CASE\_FOLDING, 0);
xml\_parser\_set\_option($parser, XML\_OPTION\_SKIP\_WHITE, $WHITE);
if ( !xml\_parse\_into_struct($parser, $data, $vals, $index) )
{
die(sprintf(“XML error: %s at line %d”,
xml\_error\_string(xml\_get\_error_code($parser)),
xml\_get\_current\_line\_number($parser)));
}
xml\_parser\_free($parser);
$i = 0;
$tagname = $vals\[$i\]\[‘tag’\];
if ( isset ($vals\[$i\]\[‘attributes’\] ) )
{
$array\[$tagname\]\[‘@’\] = $vals\[$i\]\[‘attributes’\];
} else {
$array\[$tagname\]\[‘@’\] = array();
}
$array\[$tagname\]\[“#”\] = xml_depth($vals, $i);
return $array;
}
/*
*
* You don’t need to do anything with this function, it’s called by
* xmlize. It’s a recursive function, calling itself as it goes deeper
* into the xml levels. If you make any improvements, please let me know.
*
*
*/
function xml_depth($vals, &$i) {
$children = array();
if ( isset($vals\[$i\]\[‘value’\]) )
{
array_push($children, $vals\[$i\]\[‘value’\]);
}
while (++$i < count($vals)) {
switch ($vals\[$i\]\[‘type’\]) {
case ‘open’:
if ( isset ( $vals\[$i\]\[‘tag’\] ) )
{
$tagname = $vals\[$i\]\[‘tag’\];
} else {
$tagname = ”;
}
if ( isset ( $children[$tagname] ) )
{
$size = sizeof($children[$tagname]);
} else {
$size = 0;
}
if ( isset ( $vals\[$i\]\[‘attributes’\] ) ) {
$children\[$tagname\]\[$size\]\[‘@’] = $vals[$i\]\[“attributes”\];
}
$children\[$tagname\]\[$size\][‘#’] = xml_depth($vals, $i);
break;
case ‘cdata’:
array_push($children, $vals\[$i\]\[‘value’\]);
break;
case ‘complete’:
$tagname = $vals\[$i\]\[‘tag’\];
if( isset ($children[$tagname]) )
{
$size = sizeof($children[$tagname]);
} else {
$size = 0;
}
if( isset ( $vals\[$i\]\[‘value’\] ) )
{
$children\[$tagname\]\[$size\]\[“#”] = $vals[$i\]\[‘value’\];
} else {
$children\[$tagname\]\[$size\][“#”] = ”;
}
if ( isset ($vals\[$i\]\[‘attributes’\]) ) {
$children\[$tagname\]\[$size\][‘@’]
= $vals\[$i\]\[‘attributes’\];
}
break;
case ‘close’:
return $children;
break;
}
}
return $children;
}
/* function by acebone@f2s.com, a HUGE help!
*
* this helps you understand the structure of the array xmlize() outputs
*
* usage:
* traverse\_xmlize($xml, ‘xml\_’);
* print ‘<pre>’ . implode(“”, $traverse_array . ‘</pre>’;
*
*
*/
function traverse_xmlize($array, $arrName = “array”, $level = 0) {
foreach($array as $key=>$val)
{
if ( is_array($val) )
{
traverse_xmlize($val, $arrName . “[” . $key . “]”, $level + 1);
} else {
$GLOBALS\[‘traverse_array’\]\[\] = ‘$’ . $arrName . ‘[‘ . $key . ‘] = “‘ . $val . “\”\n”;
}
}
return 1;
}
//Ends code from XMLize.php
//Starts code from The Google Checksum Calculator
//unsigned shift right
function zeroFill($a, $b)
{
$z = hexdec(80000000);
if ($z & $a)
{
$a = ($a>>1);
$a &= (~$z);
$a |= 0x40000000;
$a = ($a>>($b-1));
}
else
{
$a = ($a>>$b);
}
return $a;
}
function mix($a,$b,$c) {
$a -= $b; $a -= $c; $a ^= (zeroFill($c,13));
$b -= $c; $b -= $a; $b ^= ($a<<8);
$c -= $a; $c -= $b; $c ^= (zeroFill($b,13));
$a -= $b; $a -= $c; $a ^= (zeroFill($c,12));
$b -= $c; $b -= $a; $b ^= ($a<<16);
$c -= $a; $c -= $b; $c ^= (zeroFill($b,5));
$a -= $b; $a -= $c; $a ^= (zeroFill($c,3));
$b -= $c; $b -= $a; $b ^= ($a<<10);
$c -= $a; $c -= $b; $c ^= (zeroFill($b,15));
return array($a,$b,$c);
}
function GoogleCH($url, $length=null, $init=GOOGLE_MAGIC) {
if(is_null($length)) {
$length = sizeof($url);
}
$a = $b = 0x9E3779B9;
$c = $init;
$k = 0;
$len = $length;
while($len >= 12) {
$a += ($url[$k+0] +($url[$k+1]<<8) +($url[$k+2]<<16) +($url[$k+3]<<24));
$b += ($url[$k+4] +($url[$k+5]<<8) +($url[$k+6]<<16) +($url[$k+7]<<24));
$c += ($url[$k+8] +($url[$k+9]<<8) +($url[$k+10]<<16)+($url[$k+11]<<24));
$mix = mix($a,$b,$c);
$a = $mix[0]; $b = $mix[1]; $c = $mix[2];
$k += 12;
$len -= 12;
}
$c += $length;
switch($len) /\* all the case statements fall through \*/
{
case 11: $c+=($url[$k+10]<<24);
case 10: $c+=($url[$k+9]<<16);
case 9 : $c+=($url[$k+8]<<8);
/\* the first byte of c is reserved for the length \*/
case 8 : $b+=($url[$k+7]<<24);
case 7 : $b+=($url[$k+6]<<16);
case 6 : $b+=($url[$k+5]<<8);
case 5 : $b+=($url[$k+4]);
case 4 : $a+=($url[$k+3]<<24);
case 3 : $a+=($url[$k+2]<<16);
case 2 : $a+=($url[$k+1]<<8);
case 1 : $a+=($url[$k+0]);
/\* case 0: nothing left to add \*/
}
$mix = mix($a,$b,$c);
/\*——————————————– report the result \*/
return $mix[2];
}
//converts a string into an array of integers containing the numeric value of the char
function strord($string) {
for($i=0;$i<strlen($string);$i++) {
$result[$i] = ord($string{$i});
}
return $result;
}
//End code from The Google Checksum Calculator
?>
<div class="wp_plus_one_button" style="margin: 0 8px 8px 0; float:left; ">
<g:plusone href="https://blog.sd.idv.tw/archives/25" callback="wp_plus_one_handler"></g:plusone>
</div>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/google" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
GooGle
</a>
<a href="https://blog.sd.idv.tw/tags/pagerank" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PageRank
</a>
<a href="https://blog.sd.idv.tw/tags/php" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
PHP
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/24/" class="link black dim">
rsync + SSH 遠端備份排程
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/24" callback="wp_plus_one_handler"></g:plusone>
</div>
<p>[前言]<br>
RSYNC是Linux,UNIX系統下的數據鏡像及備份工具,具有可使本地和遠程兩台主機的文件,目錄之間,快速同步鏡 像,遠程數據備份等功能.在同步 過程中,可根據遠程服務器上的數據變動,相應的刪除或者更新本地機的數據,同步數據不用全部傳送,大大提高同步及備份文件的速度.同時在網絡安全方面,也 可以設置為SSH傳輸模式. 遠程主機(Rsync Server)可為RSYNC daemon模式,開啟之後將開放tcp4 873 port,等待本地主機(Rsync client)的連接,連接時遠程主機會進行認證,確認合法用戶進入,便開始進行資料傳輸,在第一次傳輸時會把整個資料都備份同步到本地主機上,在下一次 傳輸時,添加相應參數則可根據遠程主機的數據變動來相應調整同步操作. 本文只是 RSYNC 軟件的一個簡單應用操作文檔,主要是給初學者一個初步介紹。<br>
[目的]<br>
遠端異地備援<br>
以RSYNC 使用SSH 通訊協定 進行遠端異地備援.<br>
將遠端 目錄做備援<br>
[環境]<br>
Server:FREEBSD 6.2<br>
Client:FREEBSD 6.2</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/freebsd" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
FreeBSD
</a>
<a href="https://blog.sd.idv.tw/tags/rsync" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
rsync
</a>
<a href="https://blog.sd.idv.tw/tags/ssh" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
SSH
</a>
</div>
</div>
</div>
</div>
<div class="relative w-100 w-30-l mb4 bg-white">
<div class="relative w-100 mb4 bg-white nested-copy-line-height">
<div class="bg-white mb3 pa4 gray overflow-hidden">
<span class="f6 db">Posts</span>
<h1 class="f3 near-black mb2 mt0">
<a href="https://blog.sd.idv.tw/archives/23/" class="link black dim">
Freebsd 6.2 stable 之路
</a>
</h1>
<div class="nested-links lh-copy f5 mid-gray">
<div class="wp_plus_one_button" style="margin: 0 0 8px 8px; float:right; ">
<g:plusone href="https://blog.sd.idv.tw/archives/23" callback="wp_plus_one_handler"></g:plusone>
</div>
<p>安裝好 FreeBSD 6.2-RELEASE<br>
確認CVSUP 安裝好如沒有到/usr/ports/net/cvsup-without-gui<br>
去 make install clean<br>
cd /usr/share/examples/cvsup/<br>
將<br>
stable-supfile<br>
ports-supfile<br>
2個檔案 cp 到 /usr<br>
更改內容<br>
*default host=CHANGE_THIS.FreeBSD.org<br>
改成<br>
*default host=cvsup.tw.freebsd.org</p>
</div>
<div class="mt2">
<a href="https://blog.sd.idv.tw/tags/freebsd" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
FreeBSD
</a>
<a href="https://blog.sd.idv.tw/tags/stable" class="f7 link dim br-pill ba ph2 pv1 mb2 dib mr2 gray">
stable
</a>
</div>
</div>
</div>
</div>
</section>
<ul class="pagination pagination-default">
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/" aria-label="First" class="page-link" role="button"><span aria-hidden="true">««</span></a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/14/" aria-label="Previous" class="page-link" role="button"><span aria-hidden="true">«</span></a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/13/" aria-label="Page 13" class="page-link" role="button">13</a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/14/" aria-label="Page 14" class="page-link" role="button">14</a>
</li>
<li class="page-item active">
<a aria-current="page" aria-label="Page 15" class="page-link" role="button">15</a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/16/" aria-label="Page 16" class="page-link" role="button">16</a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/17/" aria-label="Page 17" class="page-link" role="button">17</a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/16/" aria-label="Next" class="page-link" role="button"><span aria-hidden="true">»</span></a>
</li>
<li class="page-item">
<a href="https://blog.sd.idv.tw/posts/page/17/" aria-label="Last" class="page-link" role="button"><span aria-hidden="true">»»</span></a>
</li>
</ul></article>
</main>
<footer class="bg-black bottom-0 w-100 pa3" role="contentinfo">
<div class="flex justify-between">
<a class="f4 fw4 hover-white no-underline white-70 dn dib-ns pv2 ph3" href="https://blog.sd.idv.tw/" >
© 2026 SDpower
</a>
<div>
<a href="https://twitter.com/SDpower_tw" target="_blank" class="link-transition twitter link dib z-999 pt3 pt0-l mr1" title="Twitter link" rel="noopener" aria-label="follow on Twitter——Opens in a new window">
<svg height="32px" style="enable-background:new 0 0 67 67;" version="1.1" viewBox="0 0 67 67" width="32px" xml:space="preserve" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><path d="M37.167,22.283c-2.619,0.953-4.274,3.411-4.086,6.101 l0.063,1.038l-1.048-0.127c-3.813-0.487-7.145-2.139-9.974-4.915l-1.383-1.377l-0.356,1.017c-0.754,2.267-0.272,4.661,1.299,6.271 c0.838,0.89,0.649,1.017-0.796,0.487c-0.503-0.169-0.943-0.296-0.985-0.233c-0.146,0.149,0.356,2.076,0.754,2.839 c0.545,1.06,1.655,2.097,2.871,2.712l1.027,0.487l-1.215,0.021c-1.173,0-1.215,0.021-1.089,0.467 c0.419,1.377,2.074,2.839,3.918,3.475l1.299,0.444l-1.131,0.678c-1.676,0.976-3.646,1.526-5.616,1.568 C19.775,43.256,19,43.341,19,43.405c0,0.211,2.557,1.397,4.044,1.864c4.463,1.377,9.765,0.783,13.746-1.568 c2.829-1.673,5.657-5,6.978-8.221c0.713-1.716,1.425-4.851,1.425-6.354c0-0.975,0.063-1.102,1.236-2.267 c0.692-0.678,1.341-1.419,1.467-1.631c0.21-0.403,0.188-0.403-0.88-0.043c-1.781,0.636-2.033,0.551-1.152-0.402 c0.649-0.678,1.425-1.907,1.425-2.267c0-0.063-0.314,0.042-0.671,0.233c-0.377,0.212-1.215,0.53-1.844,0.72l-1.131,0.361l-1.027-0.7 c-0.566-0.381-1.361-0.805-1.781-0.932C39.766,21.902,38.131,21.944,37.167,22.283z M33,64C16.432,64,3,50.569,3,34S16.432,4,33,4 s30,13.431,30,30S49.568,64,33,64z" style="fill-rule:evenodd;clip-rule:evenodd;fill:;"/></svg>
<span class="new-window"><svg height="8px" style="enable-background:new 0 0 1000 1000;" version="1.1" viewBox="0 0 1000 1000" width="8px" xml:space="preserve" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" >
<path d="M598 128h298v298h-86v-152l-418 418-60-60 418-418h-152v-86zM810 810v-298h86v298c0 46-40 86-86 86h-596c-48 0-86-40-86-86v-596c0-46 38-86 86-86h298v86h-298v596h596z" style="fill-rule:evenodd;clip-rule:evenodd;fill:;"/>
</svg>
</span></a>
<a href="https://github.com/SDpower" target="_blank" class="link-transition github link dib z-999 pt3 pt0-l mr1" title="Github link" rel="noopener" aria-label="follow on Github——Opens in a new window">
<svg height="32px" style="enable-background:new 0 0 512 512;" version="1.1" viewBox="0 0 512 512" width="32px" xml:space="preserve" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" >
<path d="M256,32C132.3,32,32,134.8,32,261.7c0,101.5,64.2,187.5,153.2,217.9c11.2,2.1,15.3-5,15.3-11.1 c0-5.5-0.2-19.9-0.3-39.1c-62.3,13.9-75.5-30.8-75.5-30.8c-10.2-26.5-24.9-33.6-24.9-33.6c-20.3-14.3,1.5-14,1.5-14 c22.5,1.6,34.3,23.7,34.3,23.7c20,35.1,52.4,25,65.2,19.1c2-14.8,7.8-25,14.2-30.7c-49.7-5.8-102-25.5-102-113.5 c0-25.1,8.7-45.6,23-61.6c-2.3-5.8-10-29.2,2.2-60.8c0,0,18.8-6.2,61.6,23.5c17.9-5.1,37-7.6,56.1-7.7c19,0.1,38.2,2.6,56.1,7.7 c42.8-29.7,61.5-23.5,61.5-23.5c12.2,31.6,4.5,55,2.2,60.8c14.3,16.1,23,36.6,23,61.6c0,88.2-52.4,107.6-102.3,113.3 c8,7.1,15.2,21.1,15.2,42.5c0,30.7-0.3,55.5-0.3,63c0,6.1,4,13.3,15.4,11C415.9,449.1,480,363.1,480,261.7 C480,134.8,379.7,32,256,32z"/>
</svg>
<span class="new-window"><svg height="8px" style="enable-background:new 0 0 1000 1000;" version="1.1" viewBox="0 0 1000 1000" width="8px" xml:space="preserve" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" >
<path d="M598 128h298v298h-86v-152l-418 418-60-60 418-418h-152v-86zM810 810v-298h86v298c0 46-40 86-86 86h-596c-48 0-86-40-86-86v-596c0-46 38-86 86-86h298v86h-298v596h596z" style="fill-rule:evenodd;clip-rule:evenodd;fill:;"/>
</svg>
</span></a>
</div>
</div>
</footer>
<script src="https://blog.sd.idv.tw/dist/js/app.3fc0f988d21662902933.js"></script>
</body>
</html>
IE中打開UTF-8編碼title為中文的網頁會顯示空白頁的問題
(忘了引用來源)
很久很久以前(大概2005年10月 ~2006年3月)，當時在blogger.com寫Blog。當時blogger.com有中文界面，對中文用戶也算是比較關心了，不過 blogger.com的所有模版裡都有一個問題，那就是