php ช่วยทีครับ บันทึกข้อมูล upload file ลงดาต้าเบสไม่ได้ ช่วยดูโค๊ตให้ทีว่าผมใส่อะไรผิดบ้างครับ
Code (PHP) <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body {
background-image: url(images/floral.jpg);
margin-top: 0px;
margin-bottom: 0px;
background-color: #FFF;
}
body,td,th {
font-family: AngsanaUPC;
color: #003;
}
#form1 table tr td strong {
color: #8000FF;
}
</style>
</head>
<body>
<table width="1100" border="1" align="center">
<tr>
<td><img src="images/head.jpg" width="1090" height="170" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><body>
<?
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("datacar");
$strSQL = "INSERT INTO datadriver ";
$strSQL .="(idarmy,rank,firstname,lastname,salary,address,FilesPicture,tel) VALUES ('".$_POST["txt(idarmy"]."','".$_POST["txtrank"]."','".$_POST["txtfirstname"]."', '".$_POST["txtlastname"]."','".$_POST["txtsalary"]."','".$_FILES["filUpload"]["FilesPicture"]."','".$_POST["txttel"]."')";
$objQuery = mysql_query($strSQL);
?>
<a href="PageUploadToMySQL3.php">View files</a>
</body>
</td>
</tr>
<tr>
<td><img src="images/foot.jpg" width="1092" height="85" /></td>
</tr>
</table>
</body>
</html>
Tag PHP
Date :
2012-06-24 10:22:51By :
preacherView :
1003Reply :
8
'".$_POST["txtsalary"]."'
Date :
2012-06-24 10:48:59By :
mangkunzo
อืม.... Code (PHP) $objQuery = mysql_query($strSQL) or die(mysql_error()." = ".$strSQL);
Date :
2012-06-24 11:08:52By :
mr.win
Code (PHP) <!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>Untitled Document</title>
<style type="text/css">
body {
background-image: url(images/floral.jpg);
margin-top: 0px;
margin-bottom: 0px;
background-color: #FFF;
}
body,td,th {
font-family: AngsanaUPC;
color: #003;
}
#form1 table tr td strong {
color: #8000FF;
}
</style>
</head>
<body>
<table width="1100" border="1" align="center">
<tr>
<td><img src="images/head.jpg" width="1090" height="170" /></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<?
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("datacar");
mysql_query("SET NAMES UTF8");
$strSQL = "INSERT INTO datadriver ";
$strSQL .="(idarmy,rank,firstname,lastname,salary,address,FilesPicture,tel) VALUES ('".$_POST["txtidarmy"]."','".$_POST["txtrank"]."','".$_POST["txtfirstname"]."', '".$_POST["txtlastname"]."','".$_POST["txtsalary"]."','".$_POST["txtaddress"]."','".$_FILES["filUpload"]["FilesPicture"]."','".$_POST["txttel"]."')";
$objQuery = mysql_query($strSQL) or die(mysql_error()." = ".$strSQL);
echo $strSQL;
?>
<a href="PageUploadToMySQL3.php">View files</a>
</td>
</tr>
<tr>
<td><img src="images/foot.jpg" width="1092" height="85" /></td>
</tr>
</table>
</body>
</html>
Date :
2012-06-24 14:54:56By :
preacher
ตามตัวอย่างนี้ครับCode (PHP) <?
if(move_uploaded_file($_FILES["filUpload"]["tmp_name"],"myfile/".$_FILES["filUpload"]["name"]))
{
echo "Copy/Upload Complete<br>";
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("mydatabase");
$strSQL = "INSERT INTO files ";
$strSQL .="(Name,FilesName) VALUES ('".$_POST["txtName"]."','".$_FILES["filUpload"]["name"]."')";
$objQuery = mysql_query($strSQL);
}
?>
Go to : PHP สร้างฟอร์มสำหรับ Upload รูปภาพลงในฐานข้อมูล MySQL พร้อมกับแบบ Form สำหรับการแก้ไขรูปภาพ
Date :
2012-06-24 17:11:21By :
mr.win
มันยอก error แถวนี้ครับ แต่ผมไม่ทราบว่าต้องเปลี่ยนอะไรตรงไหนบ้างช่วยบอกที่ครับCode (PHP) if(move_uploaded_file($_FILES["filUpload"]["tmp_name"],"myfile/".$_FILES["filUpload"]["name"]))
Date :
2012-06-24 21:13:39By :
preacher
ลองใช้ copy แทน move_uploaded_file ครับ
Date :
2012-06-25 06:24:18By :
mr.win
Server 04
Load balance : Server 04
