This is featured post 1 title
Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.
This is featured post 2 title
Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.
This is featured post 3 title
Replace these every slider sentences with your featured post descriptions.Go to Blogger edit html and find these sentences.Now replace these with your own descriptions.This theme is Bloggerized by Lasantha - Premiumbloggertemplates.com.
2014年9月30日 星期二
上午9:53
禹傑
put_gry.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
// -- 抓參數 --
date_default_timezone_set('Asia/Taipei');//時間函式
$varName = ""; if (isset($_POST["name"]) ){ $varName =$_POST["name"];}
//echo "Name=" .$varName ."<br>";
$varAct = ""; if (isset($_POST["act"]) ){ $varAct =$_POST["act"];}
$varPwd = ""; if (isset($_POST["pwd"]) ){ $varPwd =$_POST["pwd"];}
$varSex = ""; if (isset($_POST["sex"]) ){ $varSex =$_POST["sex"];}
$varBlood = ""; if (isset($_POST["blood"]) ){ $varBlood =implode(",",$_POST["blood"]);}
$varAge = ""; if (isset($_POST["age"]) ){ $varAge =$_POST["age"];}
//echo " age = ".$varAge ."<br>";
$varMail = ""; if (isset($_POST["mail"]) ){ $varMail =$_POST["mail"];}
$varFavor = ""; if (isset($_POST["favor"]) ){ $varFavor =implode(",",$_POST["favor"]);}
$varTel = ""; if (isset($_POST["tel"]) ){ $varTel =$_POST["tel"];}
$varPhe = ""; if (isset($_POST["phe"]) ){ $varPhe =$_POST["phe"];}
$varIcon = ""; if (isset($_POST["icon"]) ){ $varIcon =$_POST["icon"];}
$varSite = ""; if (isset($_POST["site"]) ){ $varSite =$_POST["site"];}
$varBoard = ""; if (isset($_POST["board"]) ){ $varBoard =$_POST["board"];}
$varDates = ""; if (isset($_POST["dates"]) ){ $varDates =$_POST["dates"];}
$varIP = ""; if (isset($_POST["ip"]) ){ $varIP =$_POST["ip"];}
$varAddr = ""; if (isset($_POST["addr"]) ){ $varAddr =$_POST["addr"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from puts where 1=1 "; // 準備要查詢的SQL指令
if ( strlen($varName)>0 ){ $sql.= " and name like '%" .$varName. "%' ";}
if ( strlen($varAct)>0 ){ $sql.= " and act like '%" .$varAct. "%' ";}
if ( strlen($varPwd)>0 ){ $sql.= " and pwd like '%" .$varPwd. "%' ";}
if ( strlen($varSex)>0 ){ $sql.= " and sex = '" .$varSex. "' ";}
if ( strlen($varAge)>0 ){ $sql.= " and age = " .$varAge. " ";}
if ( strlen($varBlood)>0 ){ $sql.= " and blood like '%" .$varBlood. "%' ";}
if ( strlen($varFavor)>0 ){
$sql .= " and ";
for($i=0; $i < count($_POST["favor"]); $i++){
$sql .= " favor like '%" . $_POST["favor"][$i] . "%' and ";
}
$sql = substr($sql, 0, strlen($sql)-5);
}
if ( strlen($varSite)>0 ){ $sql.= " and site like '%" .$varSite. "%' ";}
if ( strlen($varBoard)>0 ){ $sql.= " and board like '%" .$varBoard. "%' ";}
if ( strlen($varDates)>0 ){ $sql.= " and dates like '%" .$varDates. "%' ";}
if ( strlen($varIP)>0 ){ $sql.= " and ip like '%" .$varIP. "%' ";}
if ( strlen($varAddr)>0 ){ $sql.= " and addr like '%" .$varAddr. "%' ";}
$sql.= " order by id ";
//echo "sql =". $sql . "<br>";
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
//echo " total = " . $totalRow_Recordset1. "<br>";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<style>
</style>
<script>
</script>
</head>
<body>
<form method="post" name="form1" action="">
<table border="1">
<tr>
<td colspan="2">查詢表</td>
</tr>
<tr>
<td>名字</td>
<td><input type="text" name="name" value=""></td>
</tr>
<tr>
<td>帳號</td>
<td><input type="text" name="act" value=""></td>
</tr>
<tr>
<td>密碼</td>
<td><input type="password" name="pwd" value=""></td>
</tr>
<tr>
<td>性別</td>
<td>
<input type="radio" name="sex" value="0">
<input type="radio" name="sex" value="1">
</td>
</tr>
<tr>
<td>血型</td>
<td>
A型<input type="radio" name="blood[]" id="blood[]" value="0" <?php if( strpos($varBlood, "0")!==false ){ echo "checked";} ?>>
B型<input type="radio" name="blood[]" id="blood[]" value="1" <?php if( strpos($varBlood, "1")!==false ){ echo "checked";} ?>>
AB型<input type="radio" name="blood[]" id="blood[]" value="2" <?php if( strpos($varBlood, "2")!==false ){ echo "checked";} ?>>
O型<input type="radio" name="blood[]" id="blood[]" value="3" <?php if( strpos($varBlood, "3")!==false ){ echo "checked";} ?>>
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select name="age" id="age" class="inputbox_size">
<option value="" >請選擇</option>
<?php for($i=18;$i<=80;$i++){?>
<?php
$age = "";
if ( $varAge == strval($i) ){
$age = "selected";
};
?>
<option value="<?php echo $i;?>" <?php echo $age;?> ><?php echo $i;?>歲</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>喜好</td>
<td>
<?php //echo " Favor = ".$varFavor ."<br>";?>
運動<input type="checkbox" name="favor[]" id="favor[]" value="0" <?php if( strpos($varFavor, "0")!==false ){ echo "checked";} ?>>
音樂<input type="checkbox" name="favor[]" id="favor[]" value="1" <?php if( strpos($varFavor, "1")!==false ){ echo "checked";} ?>>
美食<input type="checkbox" name="favor[]" id="favor[]" value="2" <?php if( strpos($varFavor, "2")!==false ){ echo "checked";} ?>>
旅遊<input type="checkbox" name="favor[]" id="favor[]" value="3" <?php if( strpos($varFavor, "3")!==false ){ echo "checked";} ?>>
電影<input type="checkbox" name="favor[]" id="favor[]" value="4" <?php if( strpos($varFavor, "4")!==false ){ echo "checked";} ?>>
派對<input type="checkbox" name="favor[]" id="favor[]" value="5" <?php if( strpos($varFavor, "5")!==false ){ echo "checked";} ?>>
</td>
</tr>
<tr>
<td>所在地</td>
<td>
<input type="text" name="site" value="">
</td>
</tr>
<tr>
<td>留言板</td>
<td><input type="text" name="board" value=""></td>
</tr>
<tr>
<td>日期</td>
<td><input type="text" name="dates" value=""></td>
</tr>
<tr>
<td>位址</td>
<td><input type="text" name="ip" value=""></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="addr" value=""></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="查詢"></td>
</tr>
</table>
<input type="hidden" nema="mm_form" value="form1">
</form>
<table border="1">
<tr>
<td>
<input type="button" name="btn_ins" value="ins"
onclick="location.href='put_ins.php';">
</td>
<!--
<td>
<a href="put_ins.php?id=<?php echo $row_Recordset1["id"];?>">新增</a>
</td>
-->
<td colspan="18">查詢頁</td>
</tr>
<tr>
<td>名字</td>
<td>帳號</td>
<td>密碼</td>
<td>性別</td>
<td>血型</td>
<td>年紀</td>
<td>郵件</td>
<td>喜好</td>
<td>電話</td>
<td>手機</td>
<td>圖示</td>
<td>所在地</td>
<td>備註</td>
<td>日期</td>
<td>位址</td>
<td>地址</td>
<td>修改</td>
<td>刪除</td>
</tr>
<?php if( $totalRow_Recordset1>0 ){?>
<?php do{ ?>
<tr>
<td><?php echo $row_Recordset1["name"];?></td>
<td><?php echo $row_Recordset1["act"];?></td>
<td><?php echo $row_Recordset1["pwd"];?></td>
<td><?php echo $row_Recordset1["sex"];?></td>
<td><?php echo $row_Recordset1["blood"];?></td>
<td><?php echo $row_Recordset1["age"];?></td>
<td><?php echo $row_Recordset1["mail"];?></td>
<td><?php echo $row_Recordset1["favor"];?></td>
<td><?php echo $row_Recordset1["tel"];?></td>
<td><?php echo $row_Recordset1["phe"];?></td>
<td><img src="../images/upload/<?php echo $row_Recordset1["icon"];?>" width="100" height="100" border="0" /></a></td>
<td><?php echo $row_Recordset1["site"];?></td>
<td><?php echo $row_Recordset1["board"];?></td>
<td><?php echo $row_Recordset1["dates"];?></td>
<td><?php echo $row_Recordset1["ip"];?></td>
<td><?php echo $row_Recordset1["addr"];?></td>
<td><input type="button" name="btn_ins" value="修改" onclick="location.href='put_upd.php?id=<?php echo $row_Recordset1["id"];?>';" style="height:100%;"> </td>
<!--<td><a href="put_upd.php?id=<?php echo $row_Recordset1["id"];?>">修改</a></td>-->
<td><input type="button" name="btn_ins" value="刪除" onclick="location.href='put_upd.php?id=<?php echo $row_Recordset1["id"];?>';" style="height:100%;"> </td>
<!--<td><a href="put_del.php?id=<?php echo $row_Recordset1["id"];?>">刪除</a></td>-->
</tr>
<?php }while( $row_Recordset1 = mysql_fetch_assoc($Recordset1) );?>
<?php }else{ ?>
<tr>
<td colspan="20">目前尚無資料</td>
</tr>
<?php } ?>
</table>
</body>
</html>
put_ins.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
// -- 抓參數 --
date_default_timezone_set('Asia/Taipei');//時間函式
// 檔案處理區 ( "../../../../upload/news")
function isUploadFile($tmpFileName, $varIcon){
$isUpload = false;
if ( copy($tmpFileName, $varIcon) ){ // 更改檔名前置動作
$isUpload = true;
}
unlink($tmpFileName); // 清除暫存檔案
return $isUpload;
}
// 取得檔名
function getDateTimeFileName( $Picname ){
$temp = explode(".",$Picname);
return date("ymdHis") . "." . $temp[1];
}
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form=$_POST["mm_form"];}
//echo " mm_form =" . $varMM_form."<br>";
$varID = ""; if (isset($_GET["id"]) ){ $varID =$_GET["id"];}
//echo "id=" .$varID ."<br>";
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
if( $varMM_form == "form1"){
// 上傳圖片的程式
// 1.接file型態圖片檔案的資料，放到暫存檔案上
// 2.拷貝暫存檔案到images\upload目錄下
// 3.刪除暫存檔案
$oldFileName = $_FILES["icon"]["name"]; //--讀取參數
$tmpFileName = $_FILES["icon"]["tmp_name"];
$fileType = $_FILES["icon"]["type"];
$fileSize = $_FILES["icon"]["size"];
//$newFileName = getDateTimeFileName($oldFileName);
//$newFileName = $oldFileName; // "a.txt"; // 以原檔名存
$varIcon=mb_convert_encoding($_FILES["icon"]["name"],"big5","utf8"); // 以原檔名存
//echo "原始=" . $_FILES["picname"]["name"]. "<Br>";
//echo "轉碼=" . $newFileName . "<Br>";
//exit();
$path = "../images/upload"; // images/upload/
if ( chdir($path) ){ // 是否有切換目錄成功
//echo "tmp=" . $tmpFileName . "<br>";
//echo "new=" . $newFileName . "<Br>";
if ( isUploadFile($tmpFileName, $varIcon) ){ // 上傳成功
$msg .= "檔名=" . $oldFileName . "\<br>";
$msg .= "大小=". ceil($fileSize / 1024) . " KB\<br>";
$msg .= "\<br> 成功上傳了 <br>";
} else {
$msg.= "\<br> 上傳失敗，有可能您上傳的檔案太大了，";
$msg.= "不合規定，如有任何問題，請洽系統設計服務人員";
}
} else {
$msg.= "上傳檔案到指定的目錄 失敗\<br>";
}
$varName = ""; if (isset($_POST["name"]) ){ $varName =$_POST["name"];}
$varAct = ""; if (isset($_POST["act"]) ){ $varAct =$_POST["act"];}
$varPwd = ""; if (isset($_POST["pwd"]) ){ $varPwd =$_POST["pwd"];}
$varSex = ""; if (isset($_POST["sex"]) ){ $varSex = implode(",", $_POST["sex"]); }
$varBlood = ""; if (isset($_POST["blood"]) ){ $varBlood =implode(",", $_POST["blood"]);}
$varAge = ""; if (isset($_POST["age"]) ){ $varAge =$_POST["age"];}
$varMail = ""; if (isset($_POST["mail"]) ){ $varMail =$_POST["mail"];}
$varFavor = ""; if (isset($_POST["favor"]) ){ $varFavor =implode(",",$_POST["favor"]);}
$varTel = ""; if (isset($_POST["tel"]) ){ $varTel =$_POST["tel"];}
$varPhe = ""; if (isset($_POST["phe"]) ){ $varPhe =$_POST["phe"];}
$varIcon = ""; if (isset($_POST["icon"]) ){ $varIcon =$_POST["icon"];}
$varSite = ""; if (isset($_POST["site"]) ){ $varSite =$_POST["site"];}
$varBoard = ""; if (isset($_POST["board"]) ){ $varBoard =$_POST["board"];}
$varDates = ""; if (isset($_POST["dates"]) ){ $varDates =$_POST["dates"];}
$varIP = ""; if (isset($_POST["ip"]) ){ $varIP =$_POST["ip"];}
$varAddr = ""; if (isset($_POST["addr"]) ){ $varAddr =$_POST["addr"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$ins = " insert into puts ( ";
$ins.= "name, act, pwd, "; //3
$ins.= "sex, blood, age, "; //6
$ins.= " mail, favor, tel, "; //9
$ins.= " phe, icon, site,"; //12
$ins.= " board, dates, ip,"; //15
$ins.= " addr, "; //16
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )value( ";
$ins.= " '" . $varName . "', "; //1
$ins.= " '" . $varAct . "', "; //2
$ins.= " '" . $varPwd . "', "; //3
$ins.= " " . $varSex . ", "; //4
$ins.= " '" . $varBlood . "', "; //5
$ins.= " " . $varAge . ", "; //6
$ins.= " '" . $varMail . "', "; //7
$ins.= " '" . $varFavor . "', "; //8
$ins.= " " . $varTel . ", "; //9
$ins.= " " . $varPhe . ", "; //10
$ins.= " '" . $varIcon . "', "; //11
$ins.= " '" . $varSite . "', "; //12
$ins.= " '" . $varBoard . "', "; //13
$ins.= " '" . date("Y/m/d H/i/s") . "', "; //14
$ins.= " '" . $_SERVER["REMOTE_ADDR"] . "', "; //15
$ins.= " '" . $varAddr . "', "; //16
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " ) "; // 準備要查詢的SQL指令
//echo "ins =". $ins . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($ins, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
header(sprintf("Location: %s", "put_gry.php" ));
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
$(function(){
$('#form1').submit(function() {
var s = "";
if ( $("input[name='name']").val().length==0 ){
s += " 沒輸入名字 <br> ";
}
if ( $("input[name='act']").val().length==0 ){
s += " 沒輸入帳號 <br> ";
}
if ( $("input[name='pwd']").val().length==0 ){
s += " 沒輸入密碼 <br> ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入性別 <br> ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入血型 <br> ";
}
if ( $("select option:checked").val().length==0 ){
s += " 沒輸入年紀 <br> ";
}
if ( $("input[name='mail']").val().length==0 ){
s += " 沒輸入郵件 <br> ";
} else {
if ( $("input[name='mail']").val().indexOf("@")==-1 ){
s += " 郵件格式錯誤 <br> ";
}
}
if( $("input[type=checkbox][name='favor']:checked").length==0 ){
s += " 沒輸入喜好 <br> ";
}
if ( $("input[name='tel']").val().length==0 ){
s += " 沒輸入電話 <br> ";
}
if ( $("input[name='phe']").val().length==0 ){
s += " 沒輸入手機 <br> ";
}
if ( $("input[name='icon']").val().length==0 ){
s += " 沒上傳圖片 <br> ";
}
if ( $("input[name='site']").val().length==0 ){
s += " 沒輸入所在地 <br> ";
}
if ( $("textarea[name='board']").val().length==0 ){
s += " 沒輸入備註 <br> ";
}
if ( $("input[name='addr']").val().length==0 ){
s += " 沒輸入地址 <br> ";
}
//$( "#dialog" ).dialog();
if ( s.length >0 ){
//alert(s);
$( "#dialog" ).html(s);
$( "#dialog" ).attr("title", "資訊");
$( "#dialog" ).dialog();
return false;
}
});
});
-->
</script>
</head>
<body>
<div id="dialog" title="基本訊息"></div>
<form method="post" name="form1" id="form1" action="" enctype="multipart/form-data">
<table border="1">
<tr>
<td colspan="3">新增表</td>
</tr>
<tr>
<td>名字</td>
<td>
<input type="text" name="name" id="name" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>帳號</td>
<td>
<input type="text" name="act" id="act" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>密碼</td>
<td>
<input type="password" name="pwd" id="pwd" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>性別</td>
<td>
女<input type="radio" name="sex[]" id="sex[]" value="0">
男<input type="radio" name="sex[]" id="sex[]" value="1">
</td>
</tr>
<tr>
<td>血型</td>
<td>
A型<input type="radio" name="blood[]" id="blood[]" value="0">
B型<input type="radio" name="blood[]" id="blood[]" value="1">
AB型<input type="radio" name="blood[]" id="blood[]" value="2">
O型<input type="radio" name="blood[]" id="blood[]" value="3">
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select name="age" id="age" class="inputbox_size">
<option value="">請選擇</option>
<?php for($i=18;$i<=80;$i++){?>
<option value="<?php echo $i;?>"><?php echo $i;?>歲</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>郵件</td>
<td>
<input type="text" name="mail" id="mail" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>喜好</td>
<td>
運動<input type="checkbox" name="favor[]" id="favor[]" value="0">
音樂<input type="checkbox" name="favor[]" id="favor[]" value="1">
美食<input type="checkbox" name="favor[]" id="favor[]" value="2">
旅遊<input type="checkbox" name="favor[]" id="favor[]" value="3">
電影<input type="checkbox" name="favor[]" id="favor[]" value="4">
派對<input type="checkbox" name="favor[]" id="favor[]" value="5">
</td>
</tr>
<tr>
<td>電話</td>
<td>
<input type="text" name="tel" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>手機</td>
<td>
<input type="text" name="phe" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>圖示</td>
<td>
<input type="file" name="icon" value="">
</td>
</tr>
<tr>
<td>所在地</td>
<td><input type="text" name="site" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>備註</td>
<td>
<textarea name="board" id="board" style="width:350px; height:200px;overflow:auto;" class="inputbox_size"></textarea>
<!--<input type="text" name="board" value="">-->
</td>
</tr>
<!--
<tr>
<td>日期</td>
<td>
<input type="text" name="dates" value="">
</td>
</tr>
<tr>
<td>位址</td>
<td>
<input type="text" name="ip" value="">
</td>
</tr>
-->
<tr>
<td>地址</td>
<td>
<input type="text" name="addr" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td><input type="submit" value="新增"></td>
</tr>
</table>
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
put_upd.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
// -- 抓參數 --
date_default_timezone_set('Asia/Taipei');//時間函式
// 檔案處理區 ( "../../../../upload/news")
function isUploadFile($tmpFileName, $varIcon){
$isUpload = false;
if ( copy($tmpFileName, $varIcon) ){ // 更改檔名前置動作
$isUpload = true;
}
unlink($tmpFileName); // 清除暫存檔案
return $isUpload;
}
// 取得檔名
function getDateTimeFileName( $Picname ){
$temp = explode(".",$Picname);
return date("ymdHis") . "." . $temp[1];
}
$varID = ""; if (isset($_GET["id"]) ){ $varID =$_GET["id"];}
//echo "id=" .$varID ."<br>";
$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";
if( $varMM_form == "form1"){
// 上傳圖片的程式
// 1.接file型態圖片檔案的資料，放到暫存檔案上
// 2.拷貝暫存檔案到images\upload目錄下
// 3.刪除暫存檔案
$oldFileName = $_FILES["icon"]["name"]; //--讀取參數
$tmpFileName = $_FILES["icon"]["tmp_name"];
$fileType = $_FILES["icon"]["type"];
$fileSize = $_FILES["icon"]["size"];
//$varIcon = getDateTimeFileName($oldFileName);
//$varIcon = $oldFileName; // "a.txt"; // 以原檔名存
$varIcon=mb_convert_encoding($_FILES["icon"]["name"],"big5","utf8"); // 以原檔名存
//echo "原始=" . $_FILES["picname"]["name"]. "<Br>";
//echo "轉碼=" . $varIcon . "<Br>";
//exit();
$path = "../images/upload"; // images/upload/
if ( chdir($path) ){ // 是否有切換目錄成功
//echo "tmp=" . $tmpFileName . "<br>";
//echo "new=" . $varIcon . "<Br>";
if ( isUploadFile($tmpFileName, $varIcon) ){ // 上傳成功
$msg .= "檔名=" . $oldFileName . "\\n";
$msg .= "大小=". ceil($fileSize / 1024) . " KB\\n";
$msg .= "\\n 成功上傳了 <br>";
} else {
$msg.= "\\n 上傳失敗，有可能您上傳的檔案太大了，";
$msg.= "不合規定，如有任何問題，請洽系統設計服務人員";
}
} else {
$msg.= "上傳檔案到指定的目錄 失敗\\n";
}
//echo "a". "<br>";
$varName = ""; if (isset($_POST["name"]) ){ $varName =$_POST["name"];}
$varAct = ""; if (isset($_POST["act"]) ){ $varAct =$_POST["act"];}
$varPwd = ""; if (isset($_POST["pwd"]) ){ $varPwd =$_POST["pwd"];}
$varSex = ""; if (isset($_POST["sex"]) ){ $varSex = $_POST["sex"];}
$varBlood = ""; if (isset($_POST["blood"]) ){ $varBlood =$_POST["blood"];}
$varAge = ""; if (isset($_POST["age"]) ){ $varAge =$_POST["age"];}
$varMail = ""; if (isset($_POST["mail"]) ){ $varMail =$_POST["mail"];}
$varFavor = ""; if (isset($_POST["favor"]) ){ $varFavor =implode(",",$_POST["favor"]);}
$varTel = ""; if (isset($_POST["tel"]) ){ $varTel =$_POST["tel"];}
$varPhe = ""; if (isset($_POST["phe"]) ){ $varPhe =$_POST["phe"];}
//$varIcon = ""; if (isset($_POST["icon"]) ){ $varIcon =$_POST["icon"];}
$varSite = ""; if (isset($_POST["site"]) ){ $varSite =$_POST["site"];}
$varBoard = ""; if (isset($_POST["board"]) ){ $varBoard =$_POST["board"];}
$varDates = ""; if (isset($_POST["dates"]) ){ $varDates =$_POST["dates"];}
$varIP = ""; if (isset($_POST["ip"]) ){ $varIP =$_POST["ip"];}
//echo " IP = " .$varIP. "<br>";
$varAddr = ""; if (isset($_POST["addr"]) ){ $varAddr =$_POST["addr"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$update=" update puts set ";
$update.=" name = '".$varName."' , ";
$update.=" act = '".$varAct."' , ";
$update.=" pwd = '".$varPwd."' , ";
$update.=" sex = '".$varSex."' , ";
$update.=" blood = '".$varBlood."' , ";
$update.=" age = ".$varAge." , ";
$update.=" mail = '".$varMail."' , ";
$update.=" favor = '".$varFavor."' , ";
$update.=" tel = ".$varTel." , ";
$update.=" phe = '".$varPhe."' , ";
$update.=" icon = '".$varIcon."' , ";
$update.=" site = '".$varSite."' , ";
$update.=" board = '".$varBoard."' , ";
$update.=" dates = '".$varDates."' , ";
$update.=" ip = '".$varIP."' , ";
$update.=" addr = '".$varAddr."' , ";
$update = substr($update, 0 , strlen($ins) -2);
$update.=" where 1=1 ";
$update.=" and id= ".$varID." ";
//echo " update = ".$update."<br>";
//exit();
$Recordset1 = mysql_query($update, $allianz) or die(mysql_error()); // 執行查詢語法
header(sprintf("Location: %s", "put_gry.php" ));
}
//echo "b". "<br>";
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from puts where 1=1 "; // 準備要查詢的SQL指令
if ( strlen($varID)>0 ){
$sql .= " and id= " . $varID . " ";
}
//echo "sql =". $sql . "<br>";
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<style>
.inputbox_size{
width:100%;
}
</style>
<script>
<!--
$(function(){
$('#form1').submit(function() {
var s = "";
if ( $("input[name='name']").val().length==0 ){
s += " 沒輸入名字 \n ";
}
if ( $("input[name='act']").val().length==0 ){
s += " 沒輸入帳號 \n ";
}
if ( $("input[name='pwd']").val().length==0 ){
s += " 沒輸入密碼 \n ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入性別 \n ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入血型 \n ";
}
if ( $("select option:checked").val().length==0 ){
s += " 沒輸入年紀 \n ";
}
if ( $("input[name='mail']").val().length==0 ){
s += " 沒輸入郵件 \n ";
} else {
if ( $("input[name='mail']").val().indexOf("@")==-1 ){
s += " 郵件格式錯誤 \n ";
}
}
if( $("input[type=checkbox][name='favor']:checked").length==0 ){
s += " 沒輸入興趣 \n ";
}
if ( $("input[name='tel']").val().length==0 ){
s += " 沒輸入電話 \n ";
}
if ( $("input[name='phe']").val().length==0 ){
s += " 沒輸入手機 \n ";
}
if ( $("input[name='icon']").val().length==0 ){
s += " 沒上傳圖片 \n ";
}
if ( $("input[name='site']").val().length==0 ){
s += " 沒輸入所在地 \n ";
}
if ( $("textarea[name='board']").val().length==0 ){
s += " 沒輸入備註 \n ";
}
if ( $("input[name='addr']").val().length==0 ){
s += " 沒輸入地址 \n ";
}
if ( s.length >0 ){
alert(s);
$( "#dialog" ).html(s);
$( "#dialog" ).attr("title", "資訊");
$( "#dialog" ).dialog();
return false;
}
});
$( "#dates" ).datepicker({ dateFormat: 'yy/mm/dd' });
});
-->
</script>
</head>
<body>
<div id="dialog" title="基本訊息"></div>
<form method="post" name="form1" id="form1" action="" enctype="multipart/form-data">
<table border="1">
<tr>
<td colspan="3">修改表</td>
</tr>
<tr>
<td>名字</td>
<td>
<input type="text" name="name" value="<?php echo $row_Recordset1["name"];?>" class="inputbox_size">
</td>
</tr>
<tr>
<td>帳號</td>
<td>
<input type="text" name="act" value="<?php echo $row_Recordset1["act"];?>" class="inputbox_size">
</td>
</tr>
<tr>
<td>密碼</td>
<td>
<input type="password" name="pwd" value="<?php echo $row_Recordset1["pwd"];?>" class="inputbox_size">
</td>
</tr>
<tr>
<td>性別</td>
<td>
女生<input type="radio" id="sex" name="sex" value="0"
<?php if ( $row_Recordset1["sex"]=="0"){echo "checked=\"checked\""; }?> >
男生<input type="radio" id="sex" name="sex" value="1"
<?php if ( $row_Recordset1["sex"]=="1"){echo "checked=\"checked\""; }?> >
</td>
</tr>
<tr>
<td>血型</td>
<td>
<!--<input type="text" name="blood" value="">-->
A型<input type="radio" name="blood" value="0"
<?php if ( $row_Recordset1["blood"]=="0"){echo "checked"; }?> >
B型<input type="radio" name="blood" value="1"
<?php if ( $row_Recordset1["blood"]=="1"){echo "checked"; }?> >
AB型<input type="radio" name="blood" value="2"
<?php if ( $row_Recordset1["blood"]=="2"){echo "checked"; }?> >
O型<input type="radio" name="blood" value="3"
<?php if ( $row_Recordset1["blood"]=="3"){echo "checked"; }?> >
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select id="age" name="age" >
<option value="">請選擇</option>
<?php for($i=18;$i<=80;$i++){?>
<option value="<?php echo $i;?>" <?php if ( $row_Recordset1["age"]== $i){echo "selected"; }?>><?php echo $i;?>歲</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>郵件</td>
<td>
<input type="text" name="mail" class="inputbox_size"
value="<?php echo $row_Recordset1["mail"];?>">
</td>
</tr>
<tr>
<td>喜好</td>
<td>
<!--<input type="text" name="favor" value="<?php echo $row_Recordset1["favor"];?>">-->
<?php $iFavor = 0; ?>
運動<input type="checkbox" name="favor[]" value="0"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
音樂<input type="checkbox" name="favor[]" value="1"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
美食<input type="checkbox" name="favor[]" value="2"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
旅遊<input type="checkbox" name="favor[]" value="3"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
電影<input type="checkbox" name="favor[]" value="4"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
派對<input type="checkbox" name="favor[]" value="5"
<?php if( strpos( $row_Recordset1["favor"], strval($iFavor++) )!==false){ echo "checked";}?>>
</td>
</tr>
<tr>
<td>電話</td>
<td>
<input type="text" name="tel" class="inputbox_size" value="<?php echo $row_Recordset1["tel"];?>">
</td>
</tr>
<tr>
<td>手機</td>
<td>
<input type="text" name="phe" class="inputbox_size" value="<?php echo $row_Recordset1["phe"];?>">
</td>
</tr>
<tr>
<td>圖示</td>
<td>
<input type="file" name="icon" class="inputbox_size" value="<?php echo $row_Recordset1["icon"];?> ">
</td>
</tr>
<tr>
<td>所在地</td>
<td><input type="text" name="site" class="inputbox_size" value="<?php echo $row_Recordset1["site"];?>">
</td>
</tr>
<tr>
<td>備註</td>
<td>
<input type="text" name="board" class="inputbox_size" value="<?php echo $row_Recordset1["board"];?>">
</td>
</tr>
<tr>
<td>日期</td>
<td>
<input type="hidden" name="dates" id="dates" class="inputbox_size" value="" ><?php echo date("Y/m/d");?>
</td>
</tr>
<tr>
<td>位址</td>
<td>
<input type="hidden" name="ip" class="inputbox_size" value="" ><?php echo $_SERVER["REMOTE_ADDR"];?>
</td>
</tr>
<tr>
<td>地址</td>
<td>
<input type="text" name="addr" class="inputbox_size" value="<?php echo $row_Recordset1["addr"];?>">
</td>
</tr>
<tr>
<td>
<input type="submit" value="修改">
</td>
</tr>
</table>
<input type="hidden" name="mm_form" value="form1">
</form>
</body>
</html>
put_del.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
$varID = ""; if (isset($_GET["id"]) ){ $varID =$_GET["id"];}
$del = "delete from puts where 1=1 and id= ".$varID." "; // 準備 新增或修改或刪除的SQL語法
//echo "del=" . $delete . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
header(sprintf("Location: %s","put_gry.php" ) );
?>
訂閱：
文章
(
Atom
)
