 |
|
จะนำมาใช้รวมกันในไฟล์เดียวกัน ใช้คำสั่งไหนเหรอครับ ตอนนี้แยกไฟล์กันอยู่
จากตัวอย่างโค๊ดด้านล่างนี้
Insert
<?
//*** Update Record ***//
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("database");
$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"],"img/file/".$_FILES["filUpload"]["name"]))
{
//*** Delete Old File ***//
@unlink("img/file/".$_POST["hdnOldFile"]);
//*** Update New File ***//
$strSQL = "UPDATE files ";
$strSQL .=" SET FilesName = '".$_FILES["filUpload"]["name"]."' WHERE FilesID = '".$_GET["FilesID"]."' ";
$objQuery = mysql_query($strSQL);
}
}
?>
Delete
<?
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("database");
$strSQL = "DELETE FROM files ";
$strSQL .="WHERE FilesID = '".$_GET["FilesID"]."' ";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "<center>กรุณารอสักครู่..........</center>";
echo '<meta http-equiv= "refresh" content="1; url=index.php"/>';
}
else
{
echo "Error Delete [".$strSQL."]";
}
mysql_close($objConnect);
?>
Update
<?
if(copy($_FILES["filUpload"]["tmp_name"],"img/file/".$_FILES["filUpload"]["name"]))
{
echo "<center>กรุณารอสักครู่..........</center>";
echo '<meta http-equiv= "refresh" content="1; url=index.php"/>';
//*** Insert Record ***//
$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("database");
$strSQL = "INSERT INTO files ";
$strSQL .="(Name,FilesName) VALUES ('".$_POST["txtName"]."','".$_FILES["filUpload"]["name"]."')";
$objQuery = mysql_query($strSQL);
}
?>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2013-03-27 14:32:20 |
By :
imagineverend |
View :
1135 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
