HTML、 CSS、 JAVASCRIPT、 PHP、 MYSQL

 

PHP

CSS

ASP
HTML

JAVA SCRIPT

　　　　　

輔助資料

表單元件

常見的 Scripting 的物件

HTML 4.0 的基本事件

視窗介紹

　

　

其他

利用 Google 建構自己的搜尋引擎
小技巧

<script>
function extend(hider)
{
HideMenu = document.all[hider].style;
if (HideMenu.display == 'none')
HideMenu.display = "block";
else
HideMenu.display = "none";
}
</script>
　

<a href="javascript:extend('block1')">個人使用者</a>

<div id=block1 style="display: none">
xxx
</div>

分散對齊
<?php
include_once "c:/appserv/www/big5_func/big5_func.inc";
echo big5_strlen("測試OK");

// 自動分散對齊

$text = "大家好，很酷耶！";
$width = 560;
$textlen = strlen ( $text )/2;
$fontsize = 16;
$ls = Floor (($width - ($fontsize*$textlen) ) / ($textlen-1) );
//echo $ls;
?>

<table width="<?php echo $width;?>" border=0 cellpadding="0" cellspacing="0">
<tr>
<td class="fs<?php echo $ls;?>"><?php echo $text;?></td>
</tr>
</table>

ODBC 實例
$sql = " SELECT * FROM stock1 WHERE stockqty != 0 AND stock1.code not LIKE '0000%' AND code LIKE 'D%' ";
$exec = odbc_exec( $conn, $sql );
while ($rows = odbc_fetch_object( $exec )) :
$name = $rows->name;
echo $name;
endwhile;

PHP 連結 Foxpro ODBC
<?php
set_time_limit (0);
$cfg_dsn = "Driver={Microsoft Visual FoxPro Driver};SourceType=dbf;sourcedb=d:\wisdom\;BackgroundFetch=yes";
$cfg_dsn_login = "";
$cfg_dsn_mdp = "";
$conn = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
?>

1.關閉捲軸
<body scroll=no>

2.關閉橫向捲軸
<body style="overflow-x: hidden; overflow-y: auto;">

3.關閉縱向捲軸
<body style="overflow-x: auto; overflow-y: hidden;">

4.也可以用以下寫法
<head>
<style type="text/css">
body {
overflow-x : hidden;
overflow-y : auto;
}
</style>
<head>
<body>

動態產生表單數量

<html>
<head>
</head>
<body>
檔案數<select size="1" name="D1">
<option selected value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<input type="button" value="確定" name="B2" onClick="change_it();"> </p>
<form name="form1" method="POST" enctype="multipart/form-data" action="">
<span id="s1">檔案1<input type="file" name="F1" size="20"><br></span>
<p><input type="submit" value="提交" name="B1"></p>
</form>
</body>
</html>
<script>
function change_it() {
var innerStr='';
var str1 = '檔案';
var str2 = '<input type="file" name="F';
var str3 = '" size="20"><br>';
for (var i=1;i<=document.all['D1'].value;i++)
innerStr = innerStr + str1 + i + str2 + i + str3;
document.all['s1'].innerHTML = innerStr;
}
</script>

樂透號碼產生器

<?php
for($i=1; $i<43; $i++) $bArr[$i]=FALSE;
$j=0;
echo "<table>";
echo "<tr>";
while($j<6) {
$rand_num=mt_rand(1,42);
if( !$bArr[$rand_num] ) {
$bArr[$rand_num]=TRUE;
//echo "<td><img src = 'image/". $rand_num.".png'width='20' height='20'>";
echo "<td>" . $rand_num . "</td>";
$j++;
}
}
echo "</tr>";
echo "</table>";
?>

自動分頁

$total_sql = 14; // 總共的數量
$start = 0; // 開始的
$page = 3; // 一頁的數量
while ( $start <= $total_sql ) :
$end = $start + $page - 1;
// 內容控制
echo $start.".".$end."<br>";
$start += $page;
endwhile;

思考依據

0,1,2
3,4,5
6,7,8
9,10,11
12

將該物件設定為透明背景

<iframe STYLE="filter: Chroma(color=ffffff)">

網頁表單預設輸入位置

<script> document.f.user.focus(); </script>

取得 MySql 最後 Auto_increment 的值

$sql = "SHOW TABLE STATUS LIKE 'custom' ";
$query = mysql_query($sql);
$row = mysql_fetch_object ( $query );
echo $row->Auto_increment;

正在瀏覽的網頁，顯示原始碼。(貼在網址上)

javascript:void(pd_winhdn=window.open());void(pd_winhdn.document.write("<textarea%20id=show%20cols=100%20rows=25></textarea>"));void(pd_winhdn.document.all.show.value=document.all.tags("HTML")[0].outerHTML);void(pd_winhdn.setActive());

讓滑鼠左右鍵無作用 (Internet Explorer 適用)

<body oncontextmenu="window.event.returnValue=false" ONDRAGSTART="window.event.returnValue=false" ONCONTEXTMENU="window.event.returnValue=false" onSelectStart="event.returnValue=false">

CSS 表格、表單線條設定

border-bottom: #959595 1px solid;
border-top: 0px solid;
border-left: 0px solid;
border-right: 0px solid;
padding-left: 3px;

<table width="600">
<tr>
<td></td>
<td style="border:1px solid gray">&nbsp;</td>
</tr>
</table>

讀取圖檔，自動調整網頁大小
<base href="http://stwt.com.tw/shop/">
<script language="javascript"><!--
var i=0;
function resize() {
if (navigator.appName == 'Netscape') i=40;
if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+60-i);
self.focus();
}
//-->
</script>
</head>
<body onload="resize();">
<img src="images/big/GME322R.jpg" border="0" alt="無線簡報雷射鼠" title=" 無線簡報雷射鼠 " width="513" height="271">

鎖住網頁
<body leftmargin=0 topmargin=0 onmousemove='HideMenu()' oncontextmenu="return false" ondragstart="return false" onselectstart ="return false" onselect="document.selection.empty()" oncopy="document.selection.empty()" onbeforecopy="return false" onmouseup="document.selection.empty()">

SELECT 設定群組
<SELECT>
<OPTGROUP ID="ford" LABEL="Ford">
<OPTION>Taurus</OPTION>
<OPTION>Escort</OPTION>
<OPTION>Focus</OPTION>
</OPTGROUP>
<OPTGROUP ID="opel" LABEL="Opel">
<OPTION>Astra</OPTION>
<OPTION>Corsa</OPTION>
<OPTION>Omega</OPTION>
</OPTGROUP>
</SELECT>

IE 圖片左右顛倒
<IMG SRC="choose.jpg" border=0 style=" filter:flipH()">

<style type="text/css">
<!--
input {
border:1px solid #000000;
background-color: #FF9DFF;
font-size: 9 pt
}
-->
</style>

<fieldset >
<legend>會員登入</legend>
帳號: <input name="textfield" type="text" size="8">
<br>密碼: <input name="textfield2" type="password" size="8">
<input type="submit" name="Submit" value="登入">
</fieldset>

<?php
$rest = substr("abcdef", 1); // returns "bcdef"
$rest = substr("abcdef", 1, 3); // returns "bcd"
$rest = substr("abcdef", 0, 4); // returns "abcd"
$rest = substr("abcdef", 0, 8); // returns "abcdef"

// Accessing via curly braces is another option
$string = 'abcdef';
echo $string{0}; // returns a
echo $string{3}; // returns d
?>

時間 + -

$addday = 60*60*24*15;
$now = time();
$now = $now + $addday;
$anhourago_date = date("Y-m-d H:i:s",$now);
echo $anhourago_date;

<td height="15" align="center" class="TD2" style="COLOR:white" onmouseout="this.style.color='white'" onmouseover="this.style.color='black'">IP:192.168.128.10 Time:2004/4/26 銝见? 02:01:06</td>

跳脫框架

加在 head 之前

<script language="JavaScript">
<!--
if(self != top) top.location.href = window.location.href;
//-->
</SCRIPT>

<style type="text/css">
<!--
input {
border:1px dotted #C0C0C0;
background-color: #D3DDE7;
font-size: 9 pt
}
-->
</style>

<A href="javascript:onClick=window.print()"> 列印此文件</A>

<acronym title="Taiwan Explorer Club">123456</acronym>

onmouseover="this.style.backgroundColor='#FF0000';" onmouseout="this.style.backgroundColor='#999999';"

apache + php + mysql 上傳大檔案的設定

MySQL (程式啟動設定)
max_allowed_packet

/usr/local/bin/safe_mysqld -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O record_buffer=1M -O max_allowed_packet=24M

PHP (php.ini)
post_max
memory_limit_size
upload_max_filesize

Known MIME Types

regedit

HKEY_CLASSES_ROOT\MIME\Database\Content Type\

text/richtext
text/html
audio/x-aiff
audio/basic
audio/wav
image/gif
image/jpeg
image/pjpeg
image/tiff
image/x-png
image/x-xbitmap
image/bmp
image/x-jg
image/x-emf
image/x-wmf
video/avi
video/mpeg
application/postscript
application/base64
application/macbinhex40
application/pdf
application/x-compressed
application/x-zip-compressed
application/x-gzip-compressed
application/java
application/x-msdownload

application/msword
application/vnd.ms-exce
application/vnd.visio