圖片上傳、欄位驗證、日期、位址、留言－ab1628的部落格

2014/10/01 :圖片上傳、欄位驗證、日期、位址、留言

put_gry.php 圖片上傳、欄位驗證、日期、位址、留言 put_date2 put_execl put_gry1 put_gry2 put_ins put_upd puts_data

<?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>

<style>

</style>

</script>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<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>

<?php for($i=18;$i<=80;$i++){?>

<?php

$age = "";

if ( $varAge == strval($i) ){

$age = "selected";

};

<?php } ?>

</select>

</td>

</tr>

<tr>

<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>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

<tr>

<td>

<input type="button" name="btn_ins" value="ins"

onclick="location.href='put_ins.php';">

</td>

<!--

<td>

</td>

-->

</tr>

<tr>

</tr>

<?php if( $totalRow_Recordset1>0 ){?>

<?php do{ ?>

<tr>

<td><img src="../images/upload/<?php echo $row_Recordset1["icon"];?>" width="100" height="100" border="0" /></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><input type="button" name="btn_ins" value="刪除" onclick="location.href='put_upd.php?id=<?php echo $row_Recordset1["id"];?>';" style="height:100%;"></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"]);}