function output_csv($myfile,$q_id){
setlocale(LC_ALL, "zh_TW.BIG5");//設定編碼為BIG5
$dir="questionary/files/";//此為小弟預設的資料夾
$source=$dir.$myfile;
if(!$fp=fopen($source,"r")){
echo "ERROR";
exit;
}else{
$size=filesize($source)+1;
$row=0;
while($temp=fgetcsv($fp,$size,",")){
if($row>0){
$str=$str.$temp[1].",";
}else if($row==$size-1){
$str=$str.$temp[1];
}
$row=$row+1;
}
fclose($fp);
}
}
 |
@echo off
title 清除kavo及同類型變種 XP版 (2008/08/09更新)
set A=C D E F G H I J K L M N O P Q R S T U V W X Y Z
set T=這個資料夾是用來防止病毒寫入的「請勿刪除！」怪貓...
echo 開始解除kavo木馬病毒，請按下任意鍵...
echo 請按任意鍵繼續.........
pause >nul 2>nul
rem 刪除個磁碟中的autorun.inf的自動執行檔，並建立同名的資料夾，用以防止病毒寫入，屬性改成「唯讀、隱藏、系統」
for %%x in (%A%) do (
if exist %%x:\autorun.inf attrib -r -s -h -a %%x:\autorun.inf >nul 2>nul
del %%x:\autorun.inf /q /f >nul 2>nul
if not exist %%x:\AUTORUN.INF md %%x:\AUTORUN.INF >nul 2>nul
attrib +r +s +h %%x:\AUTORUN.INF >nul 2>nul
echo %T%> %%x:\AUTORUN.INF\README.TXT
cls)
rem 病毒感染用的檔案刪除完成
echo.
rem 關閉正在使用病毒檔的程式(工作列會消失一陣子)
start /wait taskkill /f /im explorer.exe
start /wait taskkill /f /im wuauclt.exe
echo.
rem 刪除登錄檔中KAVO病毒的起動值
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run" /v "jvsoft" /f >nul 2>nul
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run" /v "tasoft" /f >nul 2>nul
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run" /v "kava" /f >nul 2>nul
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run" /v "tava" /f >nul 2>nul
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run" /v "tasa" /f >nul 2>nul
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run" /v "mnsa" /f >nul 2>nul
echo.
rem 將被鎖定的隱藏檢視功能開啟(登錄檔)
reg.exe add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Advanced\Folder\Hidden\SHOWALL" /v "CheckedValue" /t REG_DWORD /d 00000001 /f >nul 2>nul
reg.exe add "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced" /v "Hidden" /t REG_DWORD /d 00000001 /f >nul 2>nul
reg.exe add "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced" /v "ShowSuperHidden" /t REG_DWORD /d 00000001 /f >nul 2>nul
reg.exe add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\ShellExecuteHooks" /v "{AEB6717E-7E19-11d0-97EE-00C04FD91972}" >nul 2>nul
rem 已修復無法開啟檢視隱藏檔的功能，有需要請到資料夾中的資料夾選項去開啟檢視隱藏的功能，不需要就別開
echo.
rem 刪除kavo的病毒主程式及建立防毒用的資料夾
echo.
for %%z in (
J3EWRO.EXE
JWEDSFDO0.DLL
KAVO.EXE
KAVO0.DLL
KAVO1.DLL
KAVO2.DLL
TAVO.EXE
TAVO0.DLL
JVVO.EXE
JVVO0.DLL
KXVO.EXE
KXVO0.DLL
KXVO1.DLL
) do (
attrib -s -h -r "%windir%\system32\%%z" >nul 2>nul
echo.
echo.
del "%windir%\system32\%%z" >nul 2>nul
if not exist "%windir%\system32\%%z" md "%windir%\system32\%%z" >nul 2>nul
attrib +s +h +r "%windir%\system32\%%z"
echo %T% > "%windir%\system32\%%z\README.TXT")
cls
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<title>ck_mail</title>
</head>
<body>
<form method="POST" action="" name="TEST" onsubmit="return ck_mail(document.TEST.T1.value)">
<input type="text" name="T1" size="20"></p>
<p><input type="submit" value="提交" name="B1"><input type="reset" value="重新設定" name="B2"></p>
</form>
</body>
</html>
function ck_mail(mail){
var tag=true;
var message="";
if(mail!=""){
mouse=mail.indexOf('@');
dot=mail.indexOf('.');
if(mouse==-1 | dot==-1){
message="E-mail格式有錯";
alert(message);
tag=false;
}
}else{
message="請輸入E-mail!";
alert(message);
tag=false;
}
return tag;
}
<img src="http://chart.apis.google.com/chart?cht=p3&chd=t:50,30,20&chs=250x100&chl=GoodBadBetween">
$ps="";
while(strlen($ps)<9){
switch(rand(1,3)){
case 1:
$ps=$ps.chr(rand(65,90));
break;
case 2:
$ps=$ps.chr(rand(97,122));
break;
case 3:
$ps=$ps.chr(rand(48,57));
break;
}
}
<?
//顯示月曆開始
if ($_POST['addY']){
$addY=$_POST['addY'];
}else{
$addY=date(Y);
}
if ($_POST['addM']){
$addM=$_POST['addM'];
}else{
$addM=date(m);
}
$t=date(t,mktime(0,0,0,$addM,1,$addY));
$w=date(w,mktime(0,0,0,$addM,1,$addY));
$F=date(F,mktime(0,0,0,$addM,1,$addY));
echo "<table align=center border=0><tr align=center><td><font size=5 color=999999><b>";
echo $yearYM=$F." ".$addY;
echo "</b></td></tr><tr align=center><td> </td></tr></table>";
echo "<table align=center border=0>";
echo "<tr align=center height=40>
<td><font color=red><b>Sun</b></td>
<td><b>Mon</b></td>
<td><b>Tue</b></td>
<td><b>Wed</b></td>
<td><b>Thu</b></td>
<td><b>Fri</b></td>
<td><font color=green><b>Sat</b></td>
</tr>";
if ($w > 1) {
echo "<tr>";
for ($i=1; $i<=$w-1; $i++) {
echo "<td align=center width=40></td>";
}
}
for ($i=$w; $i<=$w+$t; $i++) { //$w+$t=35
//一週七天
if ($i%7==1){
echo "<tr><td align=center width=40>";
}else{
echo "<td align=center width=40>";
}
if ($i-$w > 0) {
echo "<font size=5><b>";
//echo $i-$w;
echo "<a href=".($i-$w).">".($i-$w)."</a>";
echo "</b></font>";
}else{
echo " ";
}
if ($i%7==0){
echo "</td></tr>";
}else{
echo "</td>";
}
}
if ($i%7==0) {
echo "<td width=40> </td>";
}elseif ($i%7==1) {
echo "";
}elseif (($i%7)>0) {
for ($j=$i; $j<=$i+7; $j++) {
if (($j%7)==0) {
echo "<td width=40> </td>";
break;
}else{
echo "<td width=40> </td>";
}
}
echo "</tr>";
}
echo "</table>";
//顯示月曆結束
?>
<form method=post name=form1 id=form1 enctype="multipart/form-data" action="" onsubmit="submitbutton();">
<table align=center border=0><tr align=center><td><font size=5 color=999999>
<tr><td align=right></td><td><b>顯示月份 :</b>
<input size=4 type="text" name="addY" value="<?echo $addY?>"><b>年</b>
<b>
<select name="addM" size="1">
<?php
for ($temp=1;$temp<=12;$temp++){
if ($temp==$addM){
?>
<option selected><?php echo $temp;?></option>
<?php }else{?>
<option><?php echo $temp;?></option>
<?php }
}
?>
</select>
月</b> </td>
</tr>
<tr><td align=center colspan=2>
<input type="submit" name="submitbtn" value="顯示">
</td></tr>
</table>
<p>最下面的表單部分，您也可以改成下拉式表單
或是根本不用表單，直接做成下拉式連結就更方便
包括視覺效果您也可以自己改變
就像是這樣 http://www.tenway.com.tw/memberList/ (左邊會員登入的下面)
上面的程式碼做出來的效果就像這樣
http://works.sdcs.com.tw/Imgck/makeCalendar4.php </p>
<p> </p>
<form name="form1" method="post" action="">
</form>
<p> </p>
| ASCII碼 | 鍵盤 | ASCII 碼 | 鍵盤 | ASCII 碼 | 鍵盤 | ASCII 碼 | 鍵盤 |
| 27 | ESC | 32 | SPACE | 33 | ! | 34 | " |
| 35 | # | 36 | $ | 37 | % | 38 | & |
| 39 | ' | 40 | ( | 41 | ) | 42 | * |
| 43 | + | 44 | ' | 45 | - | 46 | . |
| 47 | / | 48 | 0 | 49 | 1 | 50 | 2 |
| 51 | 3 | 52 | 4 | 53 | 5 | 54 | 6 |
| 55 | 7 | 56 | 8 | 57 | 9 | 58 | : |
| 59 | ; | 60 | < | 61 | = | 62 | > |
| 63 | ? | 64 | @ | 65 | A | 66 | B |
| 67 | C | 68 | D | 69 | E | 70 | F |
| 71 | G | 72 | H | 73 | I | 74 | J |
| 75 | K | 76 | L | 77 | M | 78 | N |
| 79 | O | 80 | P | 81 | Q | 82 | R |
| 83 | S | 84 | T | 85 | U | 86 | V |
| 87 | W | 88 | X | 89 | Y | 90 | Z |
| 91 | [ | 92 | \ | 93 | ] | 94 | ^ |
| 95 | _ | 96 | ` | 97 | a | 98 | b |
| 99 | c | 100 | d | 101 | e | 102 | f |
| 103 | g | 104 | h | 105 | i | 106 | j |
| 107 | k | 108 | l | 109 | m | 110 | n |
| 111 | o | 112 | p | 113 | q | 114 | r |
| 115 | s | 116 | t | 117 | u | 118 | v |
| 119 | w | 120 | x | 121 | y | 122 | z |
| 123 | { | 124 | | | 125 | } | 126 | ~ |
資料來源:http://www.geo.ntnu.edu.tw/faculty/hchou/class/ntptc/gis/ascii_table.htm
一般在寫ASP.NET時,若DataBase是MS-SQL,那麼一般有兩
種版本-Express/Enterprise,而這兩種版本的連結語法
是不一樣的:
Express
Express連結時,是以"資料庫檔案"的方式在連接
strdbcon = "DataSource=.\SQLEXPRESS;AttachDbFilename=DataDirectory\資料庫檔名.mdf;Integrated Security=True;User Instance=True";
Enterprise
Exterprise連結時,因其不支援"資料庫檔案"的方式,所
以必須以"SQL Server"的方式連結
public SqlConnection conn = new SqlConnection("Data Source=網域名稱;AttachDbFilename=資料庫實體路徑;Integrated Security=True");
public SqlCommand cmd;
public SqlDataReader dr;
如果今天有如下的一個Table:
<table border="0" cellspacing="1" style="border-collapse: collapse" bordercolor="#111111" width="98%" id="AutoNumber11">
<tr>
<td width="100%"> </td>
<td width="100%"> </td>
</tr>
<?php
$i=1;
$r=mysql_query("select * from q$q_id");
while($row=mysql_fetch_object($r)){
?>
<tr>
<td width="100%" colspan="2" bgcolor="#E6E6FF"><div align="left"><font size="2"><?php echo $i.". ".$row->option_title; ?></font></div></td>
</tr>
<?php
switch($row->qtype){
case '0':
?>
<tr>
<?php
$temp=explode(",",$row->option_body);
for($j=0;$j<sizeof($temp)-1;$j++){
?>
<td width="100%" colspan="2">
<div align="left">
<input type="radio" value="<?php echo $j+1; ?>" name="q<?php echo $i; ?>[<?php echo $i; ?>]">
<?php echo $temp[$j]; ?></div></td>
</tr>
<?php
}
break;
case '1':
$temp=explode(",",$row->option_body);
for($j=0;$j<sizeof($temp)-1;$j++){
?>
<tr>
<td colspan="2"><label>
<div align="left">
<input name="q<?php echo $i; ?>[<?php echo $j+1; ?>]" type="checkbox" id="q<?php echo $i; ?>[<?php echo $j+1; ?>]" value="<?php echo $j+1; ?>">
<?php echo $temp[$j]; ?> </div>
</label></td>
</tr>
<?php
}
break;
case '2':
?>
<tr>
<td colspan="2"><label>
<div align="left">
<textarea name="q<?php echo $i; ?>[<?php echo $i; ?>]" cols="30" rows="6" id="q<?php echo $i; ?>[<?php echo $i; ?>]"></textarea>
</div>
</label></td>
</tr>
<?
break;
}
$i=$i+1;
}
?>
<tr>
<td width="100%" colspan="2"> </td>
</tr>
<tr>
<td width="100%" colspan="2" bgcolor="#99CCFF"> </td>
</tr>
<tr>
<td width="100%" colspan="2">
<p align="right"><font size="2"><a href="./?action=answer&q_id=<?php echo $q_id?>#top">TOP↑</a></font></td>
</tr>
</table>
for($i=1;$i<=$_POST["qmax"];$i++){
$q=$_POST["q".$i];
for(reset($q);$k=key($q);next($q)){
echo "{$q[$k]}".",";
}
echo "<br>";
}
<style type="text/css">
<!-- table,td {table-layout:fixed;word-wrap:break-word;word-break:break-all} -->
</style>
style="table-layout:fixed;word-wrap:break-word;word-break:break-all"
<table style="TABLE-LAYOUT: fixed; WORD-BREAK: break-all; WORD-WRAP: break-word" width="150">
一般在寫ASP.NET時,總是會有一些部份的功能是要自己寫的,如果是要連DataBase那就要定義一些sqlconnection之類的東西,如果有很多的Page都要用到,那麼就會有一堆一樣的東西,若那天要移到別台SERVER或PC上時,一定又是一頁一頁的改,若把那些東西都寫在某一個File中,要用的時候在"建立"(new),並且引用,這樣一來不是方便多了!
先建立一個"類別"
For VB
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Public Class Class1
Public str As String = "Data Source=CUTE;Initial Catalog=C:\INETPUB\WWWROOT\PRACTICE\APP_DATA\STUDY.MDF;Integrated Security=True"
Public sqlcon As SqlConnection = New SqlConnection(str)
Public strsql As String
Public cmd As SqlCommand
End Class
For C#
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
///
/// Class1 的摘要描述
///
public class Class1
{
public OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\questionary\\App_Data\\qu_an.mdb");
public OleDbCommand cmd;
public OleDbDataReader dr;
public void constr()
{
}
}
<link href="http://你的網頁空間網址/SyntaxHighlighter.css" rel="stylesheet" type="text/css">
<script class="javascript" src="http://你的網頁空間網址/shCore.js"></script>
<script class="javascript" src="http://你的網頁空間網/shBrushCSharp.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushPhp.js"></script>
<script class="javascript" src="http://你的網頁空間網/shBrushJScript.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushJava.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushVb.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushSql.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushXml.js"></script>
<script class="javascript" src="http://你的網頁空間網/shBrushDelphi.js"></script>
<script class="javascript" src="http://你的網頁空間網/shBrushPython.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushRuby.js"></script> <script class="javascript" src="http://你的網頁空間網址/shBrushCss.js"></script>
<script class="javascript" src="http://你的網頁空間網址/shBrushCpp.js"></script>
<script class="javascript">
//<![CDATA[
dp.SyntaxHighlighter.ClipboardSwf = 'Scripts/clipboard.swf';
dp.SyntaxHighlighter.HighlightAll('code');
//]]>
</script>
<textarea name='code' class='language'>
程式碼
</textarea>
or
<pre name='code' class='language'>
程式碼
</pre>
其中 languages 部分，目前所支援有：
C++、C#、CSS、Delphi、Java、Java Script、PHP、Python、Ruby、Sql、VB、XML/HTML 等等。
請參考以下列表，將指定的語言之 Aliases 置換到 languages 的位置上。
Language Aliases
C++ cpp, c, c++
C# c#, c-sharp, csharp
CSS css
Delphi delphi, pascal
Java java
Java Script js, jscript, javascript
PHP php
Python py, python
Ruby rb, ruby, rails, ror
Sql sql
VB vb, vb.net
XML/HTML xml, html, xhtml, xslt
ps.建議若在<pre>...</pre>區塊中有"<"和">"時要將"<"轉成"& l t ;",">"轉成"& g t ;",這樣才不會錯(把空格去掉)
資料來源:
http://sharedderrick.blogspot.com/2007/12/blogger-syntaxhighlighter.html
http://yehhou.blogspot.com/2007/06/blogger-dpsyntaxhighlighter.html
