'產生流水號
sn = Year(Now) & Right("0" & Month(Now), 2) & Right("0" & Day(Now), 2)
db.SelectCommand = "Select top 1 [mcid] from [membercard] where [mcid] like '" & sn & "%' order by [mcid] Desc"
dv = db.Select(New DataSourceSelectArguments)
If dv.Count > 0 Then
sn = sn & Right(dv.Item(0).Item("mcid") + 1, 3) '若有資料，流水號為最後一筆流水號加1
Else
sn = sn & "001" '若無資料，流水號從001開始 (每日流水號重編)
End If
timer = self.setTimeout("location.reload(true)",30000); //30秒更新
timer = self.setTimeout("history.go(0)",30000); //30秒更新
header("refresh:30"); //30秒後頁面重整
System.Threading.Thread.Sleep(2000); //等待2秒
Response.Rederict(url);
javascript:var oScript=document.createElement('script');oScript.src='http://csu.dorun.cc/doremi/hahablogger.js';void(document.body.appendChild(oScript));
這裡放您要呈現的內容
adWidth = 160;//廣告寬度
nowX = 1000;//目前位置(left)
nowY = 100;//目前位置(top)
fad_style = document.getElementById('iRFloating').style;
function fadIni()
{
innerWidth = document.body.clientWidth;
innerHeight = document.body.clientHeight;
edge = (innerWidth-1000)/2;
if( edge > adWidth )
{
posX = edge + 1000;
}
else
{
posX = innerWidth-adWidth;
}
posY = 100;
}
function fadRefresh()
{
offsetX = posX + document.body.scrollLeft - nowX;
offsetY = posY + document.body.scrollTop - nowY;
nowX += offsetX / 5;
nowY += offsetY / 5;
fad_style.left = nowX;
fad_style.top = nowY;
floatID = setTimeout('fadRefresh()', 20 );//Refresh時間
}
function fadStart()
{
fadIni();
window.onresize=fadIni;
fadRefresh();
}
fadStart();
$len = 30;
echo strlen($news_title)<=$len ? $news_title : (substr($news_title,0,$len).chr(0)."....");
?>
function csubstr($text, $limit) {
$s = ';
for($i=0;$i< $limit-3;$i++) {
$s .= ord($text[$i])>127 ? $text[$i].$text[++$i].$text[++$i] : $text[$i];
}
$s = $s."...";
return $s;
}
function ChgTitle($news_title)
{
$length = 30;
if (strlen($news_title)＞$length) {
$temp = 0;
for($i=0; $i＜$length; $i++)
if (ord($news_title[$i]) ＞ 128) $temp++;
if ($temp%2 == 0)
$news_title = substr($news_title,0,$length)."...";
else
$news_title = substr($news_title,0,$length+1)."...";
}
return $news_title;
}
$tw = 118; $th = 169; $tx = 0; $ty = 0;
$pic = ImageCreateTrueColor($tw,$th);
$img = ImageCreateFromJPEG($uploadpath.$rnd_filen.$file_type);
$sw = ImageSX($img);
$sh = ImageSY($img);
ImageCopyResized ($pic,$img,$tx,$ty,0,0,$tw,$th,$sw,$sh);
ImageJPEG($pic,"../../activity/sw/preview/".$rnd_filen.$file_type);
ImageDestroy($img);
ImageDestroy($pic);
$file = "ftp://ftpsv.cwb.gov.tw/pub/forecast/W002.txt";
$html = "";
$fo = fopen($file, "r");
while (!feof($fo)) {
$i++;
$temp=fgets($fo);
if ($i <= 7)
{
$html[$i]=$temp;
}
else
{
$di = $i-10;
//下面這部份是我全形與半形間的轉換，沒用到的可自行刪除
$vv1 = str_replace(" ","",substr($temp,2,4));
$vv2 = str_replace(" ","",substr($temp,16,21));
$str = str_replace(" ","",substr($temp,44,21));
$str = str_replace('－','-',$str);
$str = str_replace('１','1',$str);
$str = str_replace('２','2',$str);
$str = str_replace('３','3',$str);
$str = str_replace('４','4',$str);
$str = str_replace('５','5',$str);
$str = str_replace('６','6',$str);
$str = str_replace('７','7',$str);
$str = str_replace('８','8',$str);
$str = str_replace('９','9',$str);
$str = str_replace('０','0',$str);
$data[$di] = array('d1'=>$vv1,'d2'=>$vv2,'d3'=>$str);
}
}
echo $data[1]['d1']."
";
echo $data[1]['d2']."
";
echo $data[1]['d3'];
fclose($fo);
/*1-台北地區
2-桃園地區
3-新竹地區
4-苗栗地區
5-台中地區
6-彰化地區
7-南投地區
8-雲林地區
9-嘉義地區
10-台南地區
11-高雄地區
12-屏東地區
13-恆春半島
14-宜蘭地區
15-花蓮地區
16-台東地區
17-澎湖地區
18-金門地區
19-馬祖地區*/
testCookie =navigator.cookieEnabled
if (testCookie){
alert("你的瀏覽器設定支援 Cookie")
}else{
alert("你的瀏覽器設定不支援 Cookie")
}
window.open(URL,target,style)
//URL 網頁網址
//target 視窗名稱
//style 樣式設定
window.open ('page.html', 'newwindow', 'height=100, width=400, top=0, left=0, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=n o, status=no')
function openBrWindow(theURL,winName,features) {
window.open(theURL,winName,features);
}
onclick="openBrWindow('xx.html','','width=700,height=700')"
$MWDboard = mysql_query("SET NAMES big5;");
$MWDboard = mysql_query("SET CHARACTER_SET_CLIENT=big5;");
$MWDboard = mysql_query("SET CHARACTER_SET_RESULTS=big5;");
$MWDboard = mysql_query($query_MWDboard, $Mwebdata) or die(mysql_error());
點我下載
$file = $_GET[file]; //接受get參數
$file_name = "ring (".$file.").mp3"; //組成檔名
$file_path = "/tw/com/kiss/php/new_hp/ring/"; //相對路徑
$file_size = filesize($file_path); //傳回文件大小
header("Content-Type:text/html;charset=utf-8"); //header宣告
header("Content-Disposition: attachment; filename=\"$file_name\"");
readfile($file_path.$file_name); //讀檔
?>
$hostname_Mwebdata = "XXX.XXX.XXX.XXX";
$database_Mwebdata = "test";
$username_Mwebdata = "root";
$password_Mwebdata = "test";
$Mwebdata = mysql_connect($hostname_Mwebdata, $username_Mwebdata, $password_Mwebdata) or trigger_error(mysql_error(),E_USER_ERROR);
?>
mysql_select_db($database_Mwebdata, $Mwebdata);
$query_MWDboard = "SELECT * FROM member WHERE sw =1"; //下SQL條件
$MWDboard = mysql_query($query_MWDboard, $Mwebdata) or die(mysql_error());
$row_MWDboard = mysql_fetch_assoc($MWDboard);
$totalRows_MWDboard = mysql_num_rows($MWDboard); //搜尋筆數
//假設有資料就可以echo出來看看了
if($totalRows_MWDboard>0){
echo $row_MWDboard["name"];
}
?>
//先建立一些錯誤排除
class CONN_MYSQL
{
var $Host;
var $User;
var $Pass;
var $DBName;
function Connect()
{
if(!@mysql_connect($this->Host,$this->User,$this->Pass))
{
echo("\nERROR : FAIL TO CONNECT
\n");
echo("\n很抱歉，目前系統忙碌中，請在 5 ~ 10 秒後按 F5 重新整理網頁！
\n");
exit();
}
$this->Select($this->DBName);
}
function Select($DBName)
{
if(!@mysql_select_db($DBName))
{
echo("\nERROR : FAIL TO SELECT
\n");
exit();
}
}
function Execute($SqlStr)
{
$TS = @mysql_query($SqlStr);
if(!$TS)
{
echo("\nERROR : FAIL TO EXECUTE
\n");
exit();
}
return $TS;
}
function Execute2($SqlStr)
{
$TS = @mysql_query($SqlStr);
return $TS;
}
function Fetch($TS)
{
$RS = @mysql_fetch_array($TS);
if(!isset($RS))
{
echo("\nERROR : FAIL TO FETCH
\n");
exit();
}
return $RS;
}
function RowsNum($TS)
{
$RSNum = @mysql_num_rows($TS);
if(!isset($RSNum))
{
echo("\nERROR : FAIL TO COUNT
\n");
exit();
}
return $RSNum;
}
function GoTo($TS,$SeekNum)
{
@mysql_data_seek($TS,$SeekNum);
}
}
//再建立連線Function
class CONN_PHP extends CONN_MYSQL
{
function CONN_PHP()
{
$this->Host = "xxx.xxx.xxx.xxx";
$this->User = "root";
$this->Pass = "test";
$this->DBName = "test";
$this->Connect();
}
};
?>
$CONN = new CONN_PHP();
$CONN->Select("test"); //選擇資料庫
$SQL = " SELECT * FROM member WHERE sw = 1"; //下SQL條件
$TS = $CONN->Execute($SQL);
$Record = $CONN->RowsNum($TS); //搜尋筆數
//假設有資料就可以echo出來看看了
if ($Record>0){
echo $RS["name"];
}
?>
Fetch($TS)) { //利用迴圈列出每一筆資料 ?>
if (($_POST['Mm_Cname']=='') || ($_POST['Mm_Loginpwd']=='') || ($_POST['Mm_Sex']=='') || ($_POST['Mm_Addr']==''))
{
echo "";
exit;
}
}
if (!empty($_POST['UserInputPassCode'])) {
if ($_POST['SystemPassCode'] != $_POST['UserInputPassCode'])
{
echo "";
exit;
}
}
if ($_POST['Mm_Loginpwd'] != $_POST['Rty_Loginpwd'])
{
echo "";
exit;
}
if (preg_match('/.*@yahoo.com.tw/', $_POST['Mm_Email']))
{
echo "";
exit;
}
if (!empty($_POST['Mm_Email']))
{
// 使用正規表示法比對使用者輸入的字串是否符合要求
if (!ereg("^[0-9a-z._-]+@+[0-9a-z.-]+.[0-9a-z]{2,4}$",$_POST['Mm_Email']))
{
echo "";
exit;
}
}
if (!empty($_POST['Mm_Loginpwd']))
{
// 使用正規表示法比對使用者輸入的字串是否符合要求
if (!ereg("[0-9a-z]",$_POST['Mm_Loginpwd']))
{
echo "";
exit;
}
}
if (!empty($_POST['Mm_Email']))
{
// 判斷E-mail帳號是否已經註冊過 ...
$diffsqlstr="SELECT * FROM member WHERE Mm_Email=\"".$_POST['Mm_Email']."\"";
$Resultdiff=mysql_num_rows(mysql_db_query($cfgDB_NAME,$diffsqlstr));
if ($Resultdiff != 0)
{
echo "";
exit;
}
}
str = "中文字";
if (/[\x00-\xff]/g.test(str)) alert("含有非中文字");
else alert("全是中文字");
mysql_select_db($database_Mwebdata, $Mwebdata);
$query_MWDboard = "select * from member where epaper=1";
$MWDboard = mysql_query($query_MWDboard, $Mwebdata) or die(mysql_error());
$totalRows_MWDboard = mysql_num_rows($MWDboard);
$f= fopen("member.lst","w"); //打開 member.lst ,若不存在則自動建立
do{ //將所搜尋出來的e-mail寫入member.lst
fwrite($f,$row_MWDboard["Mm_Email"]);
fwrite($f,"\r\n");
} while ($row_MWDboard = mysql_fetch_assoc($MWDboard));
fclose($f);
function contains_newlines($str_to_test) {
if(preg_match("/(%0A|%0D|\\n+|\\r+)/i", $str_to_test) != 0) {
echo "你輸入的字串可能含有 injection 漏洞攻擊，請重新檢查!!";
exit;
}
}
$str = "doremi's home";
$escaped_str = mysql_escape_string($str);
printf ("%s\n", $escaped_str);
輸出:
doremi\'s home
