SecFilterEngine Off
SecFilterScanPOST Off
<script src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js'></script> <script src='http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js'></script> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>參考如下：
$("textarea#showMerchandiseContent").html('654');
$("textarea#ExampleMessage").val(result.exampleMessage);
属性:
Common -- 一般属性
cols -- 多行输入域的列数
rows -- 多行输入域的行数
accesskey -- 表单的快捷键访问方式
disabled -- 输入域无法获得焦点,无法选择,以灰色显示,在表单中不起任何作用
readonly -- 输入域可以选择,但是无法修改
tabindex -- 输入域,使用"tab"键的遍历顺序
可以在線上瀏覽圖片了。
呼叫頁面(php)範例
if($("#update_submit").prop("disabled")==false)
$("#update_submit").prop("disabled",true)
function KeyPress(objTR){
//只允許錄入數據字符 0-9 和小數點
// var objTR = document.document.password;
var txtval= objTR.value;
var key = event.keyCode;
//alert(key);
if((key < 48||key > 57) && (key < 96 || key >105)&&(key != 46 && key !=8 && key !=17 && key !=9)){
objTR.value = '';
alert('Pleas enter number digits');
}
}
var swfu;
window.onload = function () {
var settings_object = {
upload_url : "http://www.swfupload.org/upload.php",
flash_url : "http://www.swfupload.org/swfupload.swf",
file_size_limit : "20 MB",
button_placeholder_id : "spanSWFUploadButton"
};
swfu = new SWFUpload(settings_object);
};
// The uploadStart event handler. This function variable is assigned to upload_start_handler in the settings object
var myCustomUploadStartEventHandler = function (file) {
var continue_with_upload;
if (file.name === "the sky is blue") {
continue_with_upload = true;
} else {
continue_with_upload = false;
}
return continue_with_upload;
};
// The uploadSuccess event handler. This function variable is assigned to upload_success_handler in the settings object
var myCustomUploadSuccessEventHandler = function (file, server_data, receivedResponse) {
alert("The file " + file.name + " has been delivered to the server. The server responded with " + server_data); }; // Create the SWFUpload Object
var swfu = new SWFUpload({
upload_url : "http://www.swfupload.org/upload.php",
flash_url : "http://www.swfupload.org/swfupload.swf",
file_size_limit : "200 MB",
upload_start_handler : myCustomUploadStartEventHandler,
upload_success_handler : myCustomUploadSuccessEventHandler }
);
mysql> SELECT * FROM table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
TO_DAYS(date)
mysql> SELECT TO_DAYS(950501);
-> 728779
mysql> SELECT TO_DAYS('1997-10-07');
-> 729669
mysql> select DAYOFWEEK('1998-02-03');
-> 3
mysql> select DAYOFYEAR('1998-02-03');
-> 34
((unix_timestamp(NOW())- unix_timestamp(`startTime`)) <'86400')
select unix_timestamp('2008-08-08'); -- 1218124800
限制：一個ip一天只記錄一次點擊物品
$sql="select count(*) as c from web_log where DATE(now())=DATE(time) and commodity_sn='$sn' and ip='$address'";
$serachWebLogData=lazy_get_line($sql);
if(! $serachWebLogData['c']>=1){
//如果沒有資料就可以做插入
$sql="insert....";
if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip=$_SERVER['HTTP_CLIENT_IP'];
else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
else
$ip=$_SERVER['REMOTE_ADDR'];
browser()
function browser(){
$browsers = array("firefox", "msie", "opera", "chrome", "safari",
"mozilla", "seamonkey","konqueror", "netscape",
"gecko", "navigator", "mosaic", "lynx", "amaya",
"omniweb", "avant", "camino", "flock", "aol");
$agent=strtolower($_SERVER["HTTP_USER_AGENT"]);
//echo $browser;
foreach($browsers as $browser){
if (preg_match("#($browser)[/ ]?([0-9.]*)#", $agent, $match)){
$browser_version=$match[1].$match[2];
break ;
}
}
$mobileAgents = array(
"iphone",
"ipad",
"android",
"mini",
"mobi",
"portable",
"playstation",
"palm",
"hiptop",
"avantgo",
"plucker",
"xiino",
"blazer",
"eclair",
"froyo");
$OSName=array('nt 5.1'=>"XP",'nt 5.0'=>'2000','nt 5.1'=>'XP','nt 5.2'=>"Windows Server 2003",'nt 6.0'=>'vista、2008','nt 6.1'=>'Win7,Server 2008 R2','nt 6.2'=>'Windows8');
if(eregi('nt 5.1',$agent)){
$browser_os=$OSName['nt 5.1'];
}else if(eregi('nt 5.0',$agent)){
$browser_os=$OSName['nt 5.0'];
}else if(eregi('nt 5.1',$agent)){
$browser_os=$OSName['nt 5.1'];
}else if(eregi('nt 5.2',$agent)){
$browser_os=$OSName['nt 5.2'];
}else if(eregi('nt 6.0',$browser)){
$browser_os=$OSName['nt 6.0'];
}else if(eregi('nt 6.1',$agent)){
$browser_os=$OSName['nt 6.1'];
}else if(eregi('nt 6.2',$agent)){
$browser_os=$OSName['nt 6.2'];
}else{
foreach($mobileAgents as $check) {
if(stripos($agent, $check)) {
$browser_os=$check;
break;
}
}
}
return $browser_version."[{$browser_os}]";
}
// 建立 PHPMailer 物件及設定 SMTP 登入資訊
require("../phpMailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->IsSMTP(); // send via SMTP
$mail->Host = "remote.smtp.server"; // SMTP servers
$mail->SMTPAuth = true; // turn on SMTP authentication
$mail->Username = "me@localhost"; // SMTP username
$mail->Password = "123456"; // SMTP password
$mail->From = "myemail@localhost";
$mail->FromName = "My Name";
// 執行 $mail->AddAddress() 加入收件者，可以多個收件者
$mail->AddAddress("to@email.com","Josh Adams");
$mail->AddAddress("to2@email.com"); // optional name
$mail->AddReplyTo("jyu@aemtechnology.com","AEM");
$mail->WordWrap = 50; // set word wrap
// 執行 $mail->AddAttachment() 加入附件，可以多個附件
$mail->AddAttachment("path_to/file"); // attachment
$mail->AddAttachment("path_to_file2", "INF");
// 電郵內容，以下為發送 HTML 格式的郵件
$mail->IsHTML(true); // send as HTML
$mail->Subject = "testing email";
$mail->Body = "This is the HTML body";
$mail->AltBody = "This is the text-only body";
if(!$mail->Send())
{
echo "Message was not sent ";
echo "Mailer Error: " . $mail->ErrorInfo;
exit;
}
echo "Message has been sent";
$mail = new PHPMailer(); // defaults to using php "mail()"
$mail->CharSet = "utf-8";
$mail->From = 'admin@XX.XX.X.X';
$mail->FromName = 'AXX';
$subject = " system email test";
$mail->Subject = $subject;
$data_user[0]['id']='xx@xx.xxxx';
$data_user[0]['name']='Bau';
$sql="";
$body = "Dear,
please reply to testing email.";
$data=lazy_get_data($sql);
foreach($data as $value){
$body.=$value['empID'].'gg'.$value['empEmail']."
";
}
//$mail->SingleTo=TRUE; #個人理解，如果cc有多個接收mail只會顯示一個人的
$mail->ClearAddresses(); #由於內文不一樣，$mail->AddAddress 的陣列讓寄信人只寄一個，避免寄給很多人。
// optional, comment out and test
$body = eregi_replace("[\]",'',$body);
$mail->MsgHTML($body);
$mail->Encoding = "base64";
foreach($data_user as $value){
$mail->AddAddress($value['id'], $value['name']);
$mail->IsSMTP();
$mail->SMTPAuth = false;
//$mail->Port = 25;
//需使用SMTP驗證
//ou$mail->SMTPSecure = "ssl";
// 利用SSL連線到伺服器
$mail->Host = "mail.global.frontbridge.com";
//當然啦，信件寄送主機就是GMAIL
//$mail->Port = 465;
//指定SMTP port
//$mail->Username = "";
//MAIL帳號
//$mail->Password = "";
if($debug=='1'){
echo "";
echo $mail->Subject."";
echo $to."[{$to_name}]";
echo $body;
}elseif($debug=='0'){
if(!$mail->Send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
echo $to;
exit;
} else {
//echo "Message sent!";
sleep(3);
}
}
}
$body=""
$array=array("a"=>"卡卡","b"=>"黃金");
unset($array);
if(isset($array)){
print_r($array);
}else{
echo '沒有變數';
}
unset($a);
unset($b);
等於
unset($a,$b);
SELECT COUNT(column_name) FROM table_name
SELECT COUNT(*) FROM table_name
| O_Id | OrderDate | Price | 顧客 |
| 1 | 20011/11/12 | 100 | ans |
| 2 | 20011/11/12 | 100 | dce |
| 3 | 20011/11/14 | 100 | abc |
| 4 | 20011/11/15 | 100 | ans |
SELECT COUNT(顧客) AS CustomerNilsen FROM Orders
WHERE 顧客='ans'