前端:
<form action="add_db.php" method="post" enctype="multipart/form-data" name="form1" id="form1" >
<input type="hidden" name="MAX_FILE_SIZE" value="1048576" />
<input type="file" name="upload" size="36">
<input type="submit" name="button" id="button" value="送出" />
</form>
後端:add_db.php
<?php
$upload_dir = "upload/";
$upload_file = $upload_dir.$_FILES["upload"]["name"];
$type = strtolower($_FILES["upload"]["type"]);
$upload_name=$_FILES["advertisement_pic"]["name"];
if ($type=="image/jpeg" or $type=="image/jpg" or $type=="image/gif"){
if (move_uploaded_file($_FILES["advertisement_pic"]["tmp_name"],$upload_file)){
$link=mysql_connect("127.0.0.1","root","");
if(!$link) die("建立資料連接失敗");
$db_selected=mysql_select_db("pic",$link);
if(!$db_selected) die("開啟資料庫失敗");
$sql="INSERT INTO img (name) VALUES ('$upload_name')";
mysql_query("SET NAMES 'utf8'");
$result=mysql_query($sql,$link);
if(!$result) die("執行SQL命令失敗");
mysql_close($link);
exit();
}
else{ echo '上傳失敗';
}
}
else{
echo "<SCRIPT LANGUAGE='javascript'>";
echo "alert('上傳檔案限JPG/JPEG/GIF');";
echo "history.back();";
echo "</SCRIPT>";
exit();
}
?>
資料庫(PIC) TABEL(img ) 有2欄位 PIC_ID (自動編號) name(檔名)
現在上傳一個圖片,原始檔名AAAE.jpg
上傳完在MYSQL裏面的值name=AAAE.jpg
我想把上傳的圖片自動排序改名字,因為要避免重復!
像0.JPG,1.JPG,2.JPG
要怎樣改..謝謝.
