Preview: insertprivate.php
Size: 1.77 KB
/home/www/idcceurope.com/www/idcceurope.com/admin/insertprivate.php
<?php
$path = $_POST["path"];
$id = (int)$_POST["id"];
$service = $_POST["service"];
$name_en = $_POST["name"];
$cusId = (int)$_POST["customer"];
require "db.php";
$st='';
if(strlen($path)>0){
$temp = explode("\\",$path);
$n =count($temp);
$st = $temp[$n-1];
}
if(strcmp($service,"add")==0){
$sql = "SELECT * FROM details WHERE id = $id";
$result = mysql_query($sql);
if(mysql_num_rows($result)>0){
$sql = "UPDATE details set file_name_en = '$st', name_en = '$name_en',cusId = $cusId WHERE id = $id";
}
else{
$sql = "INSERT INTO details (name_en,file_name_en,cusId) VALUES ('$name_en','$st',$cusId)";
}
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "<br />";
}
else
{
if(!file_exists("../files/" . $_FILES["file"]["name"]))
{
move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
}
}
}
else if(strcmp($service,"edit")==0){
if(strlen($path)>0){
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "<br />";
}
else
{
if(!file_exists("../files/" . $_FILES["file"]["name"]))
{
move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
}
}
$sql = "UPDATE details SET file_name_en = '$st',name_en = '$name_en',cusId = $cusId WHERE id = $id";
}
else{
$sql = "UPDATE details SET name_en = '$name_en',cusId = $cusId WHERE id = $id";
}
}
else{
$sql = "DELETE FROM details WHERE id = $id";
}
//echo $sql;
mysql_query($sql);
header("Location: index.php?page=private");
?>
Directory Contents
Dirs: 4 × Files: 101