20141001 def 性別、留言板、驗證、喜好
20141001 def 性別、留言板、驗證、喜好
def_qry.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
$varnm = ""; if (isset($_POST["nm"]) ){ $varnm =$_POST["nm"];}
$varsexs = ""; if (isset($_POST["sexs"]) ){ $varsexs =$_POST["sexs"];}
$varages = ""; if (isset($_POST["ages"]) ){ $varages =$_POST["ages"];}
$varfavors = ""; if (isset($_POST["favors"]) ){ $varfavors =implode(",",$_POST["favors"]);}
$varmemo = ""; if (isset($_POST["memo"]) ){ $varmemo =$_POST["memo"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from def where 1=1 "; // 準備要查詢的SQL指令
if ( strlen($varnm)>0 ){ $sql.= " and nm like '%" .$varnm. "%' ";}
if ( strlen($varsexs)>0 ){ $sql.= " and sexs = '" .$varsexs. "' ";}
if ( strlen($varages)>0 ){ $sql.= " and ages = " .$varages. " ";}
if ( strlen($varfavors)>0 ){
$sql .= " and ";
for($i=0; $i < count($_POST["favors"]); $i++){
$sql .= " favors like '%" . $_POST["favors"][$i] . "%' and ";
}
$sql = substr($sql, 0, strlen($sql)-5);
}
if ( strlen($varmemo)>0 ){ $sql.= " and memo = '" .$varmemo. "' ";}
if ( strlen($varother)>0 ){ $sql.= " and other = '" .$varother. "' ";}
$varpic = ""; if (isset($_POST["pic"]) ){ $varpic =$_POST["pic"];}
$sql.= " order by id ";
//echo " sql = " . $sql . "<br>";
//exit
$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
?>
<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>名字</td>
<td><input type="text" name="nm" value="<?php echo $varnm;?>" ></td>
</tr>
<tr>
<td>性別</td>
<td align="center">
women<input type="radio" name="sexs" value="0" <?php if( strpos($varsexs, "0")!==false ){ echo "checked";} ?>>
men<input type="radio" name="sexs" value="1" <?php if( strpos($varsexs, "1")!==false ){ echo "checked";} ?>>
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select name="ages" id="ages" value="<?php echo $varages;?>" class="inputbox_size">
<option value="" >請選擇</option>
<?php for($i=18;$i<=80;$i++){?>
<?php
$ages = "";
if ( $varages == strval($i) ){
$ages = "selected";
};
?>
<option value="<?php echo $i;?>" <?php echo $ages;?> ><?php echo $i;?>歲</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>喜好</td>
<td>
<?php //echo " favors = ".$varfavors ."<br>";?>
運動<input type="checkbox" name="favors[]" id="favors[]" value="0" <?php if( strpos($varfavors, "0")!==false ){ echo "checked";} ?>>
音樂<input type="checkbox" name="favors[]" id="favors[]" value="1" <?php if( strpos($varfavors, "1")!==false ){ echo "checked";} ?>>
美食<input type="checkbox" name="favors[]" id="favors[]" value="2" <?php if( strpos($varfavors, "2")!==false ){ echo "checked";} ?>>
旅遊<input type="checkbox" name="favors[]" id="favors[]" value="3" <?php if( strpos($varfavors, "3")!==false ){ echo "checked";} ?>>
電影<input type="checkbox" name="favors[]" id="favors[]" value="4" <?php if( strpos($varfavors, "4")!==false ){ echo "checked";} ?>>
派對<input type="checkbox" name="favors[]" id="favors[]" value="5" <?php if( strpos($varfavors, "5")!==false ){ echo "checked";} ?>>
</td>
</tr>
<tr>
<td>留言板</td>
<td><input type="text" name="memo" value=""></td>
</tr>
<tr>
<td>其他</td>
<td><input type="text" name="other" value=""></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="查詢"></td>
</tr>
</table>
</form>
<table border="1">
<tr>
<td>
<input type="button" name="btn_ins" value="新增"
onclick="location.href='def_ins.php';">
</td>
<td>查詢頁</td>
</tr>
<tr>
<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["nm"];?></td>
<td><?php echo $row_Recordset1["sexs"];?></td>
<td><?php echo $row_Recordset1["ages"];?></td>
<td><?php echo $row_Recordset1["favors"];?></td>
<td><?php echo $row_Recordset1["memo"];?></td>
<td>
<?php if( strlen($row_Recordset1["pic"])>0 ){?>
<img src="../images/upload/<?php echo $row_Recordset1["pic"];?>" width="100" height="100" border="0" /></a>
<?php }else{ ?>
<img src="../images/upload/nopic.jpg" width="100" height="100" border="0" /></a>
<?php }?>
</td>
<td><?php echo $row_Recordset1["other"];?></td>
<td><input type="button" name="btn_upd" value="修改" onclick="location.href='def_upd.php?id=<?php echo $row_Recordset1["id"];?>';" style="height:100%;"></td>
<td><input type="button" name="btn_del" value="刪除" onclick="location.href='def_del.php?id=<?php echo $row_Recordset1["id"];?>';" style="height:100%;"></td>
</tr>
<?php }while( $row_Recordset1 = mysql_fetch_assoc($Recordset1) );?>
<?php }else{ ?>
<tr>
<td>目前尚無資料</td>
</tr>
<?php } ?>
</table>
</body>
</html>
def_ins.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
// 檔案處理區 ( "../../../../upload/news")
function isUploadFile($tmpFileName, $varpic){
$isUpload = false;
if ( copy($tmpFileName, $varpic) ){ // 更改檔名前置動作
$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 " form = " . $varmm_form . "<br>";
if( $varmm_form == "form1"){
// 上傳圖片的程式
// 1.接file型態圖片檔案的資料，放到暫存檔案上
// 2.拷貝暫存檔案到images\upload目錄下
// 3.刪除暫存檔案
$oldFileName = $_FILES["pic"]["name"]; //--讀取參數
$tmpFileName = $_FILES["pic"]["tmp_name"];
$fileType = $_FILES["pic"]["type"];
$fileSize = $_FILES["pic"]["size"];
//$newFileName = getDateTimeFileName($oldFileName);
//$newFileName = $oldFileName; // "a.txt"; // 以原檔名存
$varpic=mb_convert_encoding($_FILES["pic"]["name"],"big5","utf8"); // 以原檔名存
//echo $varpic;
//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, $varpic) ){ // 上傳成功
$msg .= "檔名=" . $oldFileName . "\<br>";
$msg .= "大小=". ceil($fileSize / 1024) . " KB\<br>";
$msg .= "\<br> 成功上傳了 <br>";
} else {
$msg.= "\<br> 上傳失敗，有可能您上傳的檔案太大了，";
$msg.= "不合規定，如有任何問題，請洽系統設計服務人員";
}
} else {
$msg.= "上傳檔案到指定的目錄 失敗\<br>";
}
//echo $msg;
//exit();
$varnm = ""; if (isset($_POST["nm"]) ){ $varnm =$_POST["nm"];}
$varsexs = ""; if (isset($_POST["sexs"]) ){ $varsexs = implode(",", $_POST["sexs"]); }
$varages = ""; if (isset($_POST["ages"]) ){ $varages =$_POST["ages"];}
$varfavors = ""; if (isset($_POST["favors"]) ){ $varfavors =implode(",",$_POST["favors"]);}
$varmemo = ""; if (isset($_POST["memo"]) ){ $varmemo =$_POST["memo"];}
$varother = ""; if (isset($_POST["other"]) ){ $varother =$_POST["other"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$ins = " insert into def ( ";
$ins.= " nm , sexs , ages , ";
$ins.= " favors , memo, pic, ";
$ins.= " other , ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )value(";
$ins.= " '".$varnm."' , ";
$ins.= " '".$varsexs."' , ";
$ins.= " ".$varages." , ";
$ins.= " '".$varfavors."' , ";
$ins.= " '".$varmemo."' , ";
$ins.= " '".$varpic."' , ";
$ins.= " '".$varother."' , ";
$ins = substr($ins, 0 , strlen($ins) -2);
$ins.= " )";
//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", "def_qry.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='nm']").val().length==0 ){
s += " 沒輸入名字 <br> ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入性別 <br> ";
}
if ( $("select option:checked").val().length==0 ){
s += " 沒輸入年紀 <br> ";
}
/* <input type="checkbox" name="favors[]" id="favors[]" value="0">*/
if( $("input[type=checkbox]:checked").length==0 ){
s += " 沒輸入喜好 <br> ";
}
if ( $("textarea[name='memo']").val().length==0 ){
s += " 沒輸入備註 <br> ";
}
if ( $("input[name='pic']").val().length==0 ){
s += " 沒上傳圖片 <br> ";
}
if ( $("input[name='other']").val().length==0 ){
s += " 沒輸入其他 <br> ";
}
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="nm" id="nm" value="" class="inputbox_size">
</td>
</tr>
<tr>
<td>性別</td>
<td>
女<input type="radio" name="sexs[]" id="sexs[]" value="0">
男<input type="radio" name="sexs[]" id="sexs[]" value="1">
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select name="ages" id="ages">
<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="checkbox" name="favors[]" id="favors[]" value="0">
音樂<input type="checkbox" name="favors[]" id="favors[]" value="1">
美食<input type="checkbox" name="favors[]" id="favors[]" value="2">
旅遊<input type="checkbox" name="favors[]" id="favors[]" value="3">
電影<input type="checkbox" name="favors[]" id="favors[]" value="4">
派對<input type="checkbox" name="favors[]" id="favors[]" value="5">
</td>
</tr>
<tr>
<td>留言板</td>
<td>
<textarea name="memo" id="memo" style="width:350px; height:200px;overflow:auto;" class="inputbox_size"></textarea>
</td>
</tr>
<tr>
<td>圖示</td>
<td>
<input type="file" name="pic" value="">
</td>
</tr>
<tr>
<td>其他</td>
<td>
<input type="text" name="other" id="other" 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>
def_upd.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
// 檔案處理區 ( "../../../../upload/news")
function isUploadFile($tmpFileName, $varpic){
$isUpload = false;
if ( copy($tmpFileName, $varpic) ){ // 更改檔名前置動作
$isUpload = true;
}
unlink($tmpFileName); // 清除暫存檔案
return $isUpload;
}
// 取得檔名
function getDateTimeFileName( $varpic ){
$temp = explode(".",$varpic);
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>";
//print_r($varmm_form);
//var_dump($varmm_form);
if( $varmm_form == "form1"){
// 上傳圖片的程式
// 1.接file型態圖片檔案的資料，放到暫存檔案上
// 2.拷貝暫存檔案到images\upload目錄下
// 3.刪除暫存檔案
$oldFileName = $_FILES["pic"]["name"]; //--讀取參數
$tmpFileName = $_FILES["pic"]["tmp_name"];
$tmpFileName = mb_convert_encoding($_FILES["pic"]["tmp_name"],"utf8","big5"); // 以原檔名存
$fileType = $_FILES["pic"]["type"];
$fileSize = $_FILES["pic"]["size"];
//$varIcon = getDateTimeFileName($oldFileName);
//$varIcon = $oldFileName; // "a.txt"; // 以原檔名存
//$varpic = mb_convert_encoding($_FILES["pic"]["name"],"big5","utf8"); // 以原檔名存
$varpic = $_FILES["pic"]["name"];
//echo $varpic;
//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, $varpic) ){ // 上傳成功
$msg .= "檔名=" . $oldFileName . "\\n";
$msg .= "大小=". ceil($fileSize / 1024) . " KB\\n";
$msg .= "\\n 成功上傳了 <br>";
} else {
$msg.= "\\n 上傳失敗，有可能您上傳的檔案太大了，";
$msg.= "不合規定，如有任何問題，請洽系統設計服務人員";
}
} else {
$msg.= "上傳檔案到指定的目錄 失敗\\n";
}
//echo $msg . "<br>";
$varnm = ""; if (isset($_POST["nm"]) ){ $varnm =$_POST["nm"];}
///echo " nm = " . $varnm . "<br>";
$varsexs = ""; if (isset($_POST["sexs"]) ){ $varsexs = $_POST["sexs"]; }
//echo " sexs = " . $varsexs . "<br>";
//print_r($varsexs);
$varages = ""; if (isset($_POST["ages"]) ){ $varages =$_POST["ages"];}
$varfavors = ""; if (isset($_POST["favors"]) ){ $varfavors =implode(",",$_POST["favors"]);}
$varmemo = ""; if (isset($_POST["memo"]) ){ $varmemo =$_POST["memo"];}
//$varpic = ""; if (isset($_POST["pic"]) ){ $varpic =$_POST["pic"];}
//echo " pic = " . $varpic . "<br>";
$varother = ""; if (isset($_POST["other"]) ){ $varother =$_POST["other"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$update=" update def set ";
$update.=" nm = '".$varnm."', ";
$update.=" sexs = ".$varsexs.", ";
$update.=" ages = ".$varages.", ";
$update.=" favors = '".$varfavors."', ";
$update.=" memo = '".$varmemo."', ";
$update.=" pic = '".$varpic."', ";
$update.=" other = '".$varother."', ";
$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()); // 執行查詢語法
//exit();
header(sprintf("Location: %s", "def_qry.php" ));
}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from def 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>
<!--
if (!String.prototype.trim) {
String.prototype.trim = function () {
return this.replace(/^\s+|\s+$/g, '');
};
}
$(function(){
$('#form1').submit(function() {
var s = "";
if ( $("input[name='nm']").val().length==0 ){
s += " 沒輸入名字 <br> ";
}
if( $("input[type=radio]:checked").length==0 ){
s += " 沒輸入性別 <br> ";
}
if ( $("select option:checked").val().length==0 ){
s += " 沒輸入年紀 <br> ";
}
if( $("input[type=checkbox]:checked").length==0 ){
s += " 沒輸入喜好 <br> ";
}
if ( $("textarea[name='memo']").val().trim().length==0 ){
s += " 沒輸入備註 <br> ";
}
if ( $("input[name='pic']").val().length==0 ){
s += " 沒上傳圖片 <br> ";
}
if ( $("input[name='other']").val().length==0 ){
s += " 沒輸入其他 <br> ";
}
if ( s.length >0 ){
//alert(s);
$( "#dialog" ).html(s);
$( "#dialog" ).attr("title", "資訊");
$( "#dialog" ).dialog();
return false;
}
}); // END OF $('#form1').submit(function() {
}); // $(function(){
-->
</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="nm" id="nm" value="<?php echo $row_Recordset1["nm"];?>" class="inputbox_size">
</td>
</tr>
<tr>
<td>性別</td>
<td>
女生<input type="radio" id="sexs" name="sexs" value="0"
<?php if ( $row_Recordset1["sexs"]=="0"){echo "checked=\"checked\""; }?> >
男生<input type="radio" id="sexs" name="sexs" value="1"
<?php if ( $row_Recordset1["sexs"]=="1"){echo "checked=\"checked\""; }?> >
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select id="ages" name="ages" >
<option value="">請選擇</option>
<?php for($i=18;$i<=80;$i++){?>
<option value="<?php echo $i;?>" <?php if ( $row_Recordset1["ages"]== $i){echo "selected"; }?>><?php echo $i;?>歲</option>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>喜好</td>
<td>
<!--<input type="text" name="favor" value="<?php echo $row_Recordset1["favor"];?>">-->
<?php $ifavors = 0; ?>
運動<input type="checkbox" name="favors[]" value="0" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?> >
音樂<input type="checkbox" name="favors[]" value="1" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?>>
美食<input type="checkbox" name="favors[]" value="2" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?>>
旅遊<input type="checkbox" name="favors[]" value="3" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?>>
電影<input type="checkbox" name="favors[]" value="4" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?>>
派對<input type="checkbox" name="favors[]" value="5" <?php if( strpos( $row_Recordset1["favors"], strval($ifavors++) )!==false){ echo "checked";}?>>
</td>
</tr>
<tr>
<td>留言板</td>
<td>
<textarea name="memo" id="memo" style="width:350px; height:200px;overflow:auto;" class="inputbox_size" >
<?php echo $row_Recordset1["memo"];?>
</textarea>
</td>
</tr>
<tr>
<td>圖示</td>
<td>
<input type="file" name="pic" class="inputbox_size" value="<?php echo $row_Recordset1["pic"];?> ">
</td>
</tr>
<tr>
<td>其他</td>
<td>
<input type="text" name="other" id="other" value="<?php echo $row_Recordset1["other"];?>" 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>
def_del.php
<?php require_once('../Connections/allianz.php'); ?>
<?php
$varID = ""; if (isset($_GET["id"]) ){ $varID =$_GET["id"];}
$del = "delete from def where 1=1 and id= ".$varID." "; // 準備 新增或修改或刪除的SQL語法
//echo "del=" . $del . "<br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
header(sprintf("Location: %s","def_qry.php" ) );
?>
留言列表
