<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>:: บันทึกการแก้ไขข้อมูล ::</title> </head> <body> <? include("connectdb.php"); $id_car = $_REQUEST['id_car']; $id = $_REQUEST['id']; $brand = $_REQUEST['brand']; $version = $_REQUEST['version']; $detail = $_REQUEST['detail']; $price = $_REQUEST['price']; $file = $_FILES['pic']; $file_name = $file["name"]; $file_size = $file["size"]; $file_type = $file["type"]; $file_path = $file["tmp_name"]; echo "name : $file_name <br/> size : $file_size <br/> type : $file_type <br/> path : $file_path <br/>"; //Check input $is_upload=true; if($file_size <= 0){ $is_upload =false; echo "file is Error<br />"; echo "<a href='addcar.php'>Upload Again</a>"; } else if($file_type !="image/pjpeg" && $file_type !="image/gif" ){ $is_upload =false; echo "file type is Error<br />"; echo "<a href='addcar.php'>Upload Again</a>"; } else if($file_size > 1000*1024){ $is_upload =false; echo "file size too big<br />"; echo "<a href='addcar.php'>Upload Again</a>"; } //Save if($is_upload){ include("connectdb.php"); //1.inseat into database $sql = "UPDATE car SET pic='' WHERE id_car = $id_car"; mysql_query($sql)or die (mysql_error()) ; //2.upload pic $type = ""; if($file_type =="image/pjpeg"){ $type="jpg"; } else{ $type="gif"; } $fileupload = "images/$id_car.$type"; move_uploaded_file($file_path,$fileupload); //3.update name pic to database $sql = "UPDATE car SET pic='$fileupload' WHERE id_car = $id_car"; mysql_query($sql)or die (mysql_error()) ; echo "Save file Completed <br/>"; echo "<a href='show.php'>Back</a>"; } $sql = "UPDATE car SET brand='$brand',version='$version',detail='$detail',price=$price,id=$id WHERE id_car=$id_car"; mysql_query($sql)or die (mysql_error()) ; include("disconnectdb.php"); ?> </body> </html>
<html> <head> <title>ThaiCreate.Com Tutorial</title> </head> <body> <? //*** Update Record ***// $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database"); $objDB = mysql_select_db("mydatabase"); $strSQL = "UPDATE files "; $strSQL .=" SET NAME = '".$_POST["txtName"]."' WHERE FilesID = '".$_GET["FilesID"]."' "; $objQuery = mysql_query($strSQL); if($_FILES["filUpload"]["name"] != "") { if(copy($_FILES["filUpload"]["tmp_name"],"myfile/".$_FILES["filUpload"]["name"])) { //*** Delete Old File ***// @unlink("myfile/".$_POST["hdnOldFile"]); //*** Update New File ***// $strSQL = "UPDATE files "; $strSQL .=" SET FilesName = '".$_FILES["filUpload"]["name"]."' WHERE FilesID = '".$_GET["FilesID"]."' "; $objQuery = mysql_query($strSQL); echo "Copy/Upload Complete<br>"; } } ?> <a href="PageUploadToMySQL3.php">View files</a> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
