1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
<?php
if(id_top_permission("a")!=1){
permission_fail();
}
// Status Package Module
$status_module=select_query("status_module","cms_status_module","id","18");
if($status_module[0]!=1) {
fieldset_no_module();
}
$navig['project']="ผลงานของเรา";
$navig['project_update']="แก้ไขข้อมูล";
navigator($navig);
echo"<br>";
bar_header("แก้ไขข้อมูล"); // Bar_Header
fieldset_top("ผลงานของเรา");
if($p_topic!="") { $topic=trim($p_topic); }
if($p_evar!="") { $fulltexts=trim($p_evar); }
$userfile1_name=trim($_FILES['userfile1']['name']);
$userfile2_name=trim($_FILES['userfile2']['name']);
$userfile3_name=trim($_FILES['userfile3']['name']);
$userfile4_name=trim($_FILES['userfile4']['name']);
$userfile5_name=trim($_FILES['userfile5']['name']);
if($p_id_update!="") { $id_update=trim($p_id_update); }
if($p_check_pic1!="") { $check_pic1=trim($p_check_pic1); }
if($p_check_pic2!="") { $check_pic2=trim($p_check_pic2); }
if($p_check_pic3!="") { $check_pic3=trim($p_check_pic3); }
if($p_check_pic4!="") { $check_pic4=trim($p_check_pic4); }
if($p_check_files!="") { $check_files=trim($p_check_files); }
if($p_price!="") { $price=trim($p_price); }
// เช็คไฟล์ว่าถูกต้องหรือไม่
if($userfile1_name!="") { check_pic($userfile1_name,1); }
if($userfile2_name!="") { check_pic($userfile2_name,2); }
if($userfile3_name!="") { check_pic($userfile3_name,3); }
if($userfile4_name!="") { check_pic($userfile4_name,4); }
if($userfile5_name!="") { check_file($userfile5_name,5); }
// Create_Filename
if($userfile1_name!="") {
$name1=create_filename($userfile1_name);
$dlink="$_SESSION[web_name]/mainfile/".$name1;
delete_filename("cms_project","pic1",$id_update,"$_SESSION[web_name]/mainfile/","id");
upload_file_to_server($dlink,$_FILES['userfile1']);
}
if($userfile2_name!="") {
$name2=create_filename($userfile2_name);
$dlink="$_SESSION[web_name]/mainfile/".$name2;
delete_filename("cms_project","pic2",$id_update,"$_SESSION[web_name]/mainfile/","id");
upload_file_to_server($dlink,$_FILES['userfile2']);
}
if($userfile3_name!="") {
$name3=create_filename($userfile3_name);
$dlink="$_SESSION[web_name]/mainfile/".$name3;
delete_filename("cms_project","pic3",$id_update,"$_SESSION[web_name]/mainfile/","id");
upload_file_to_server($dlink,$_FILES['userfile3']);
}
if($userfile4_name!="") {
$name4=create_filename($userfile4_name);
$dlink="$_SESSION[web_name]/mainfile/".$name4;
delete_filename("cms_project","pic4",$id_update,"$_SESSION[web_name]/mainfile/","id");
upload_file_to_server($dlink,$_FILES['userfile4']);
}
if($userfile5_name!="") {
$name5=create_filename($userfile5_name);
$dlink="$_SESSION[web_name]/mainfile/".$name5;
delete_filename("cms_project","files",$id_update,"$_SESSION[web_name]/mainfile/","id");
upload_file_to_server($dlink,$_FILES['userfile5']);
}
//*******แก้ไขข้อมูลลงในฐาน*************************************************
$sql="select pic1,pic2,pic3,pic4,files from cms_project where id='$id_update'";
$result=mysql_query($sql);
$data=mysql_fetch_row($result);
if($userfile1_name=="") { $name1=$data[0]; }
if($userfile2_name=="") { $name2=$data[1]; }
if($userfile3_name=="") { $name3=$data[2]; }
if($userfile4_name=="") { $name4=$data[3]; }
if($userfile5_name=="") { $name5=$data[4]; }
// ######## เอาไฟล์ออกจากระบบ #######
if($check_pic1=="1" and $userfile1_name==""){
check_pic_out("cms_project","pic1",$id_update,"$_SESSION[web_name]/mainfile/","id");
$name1="";
}
if($check_pic2=="1" and $userfile2_name==""){
check_pic_out("cms_project","pic2",$id_update,"$_SESSION[web_name]/mainfile/","id");
$name2="";
}
if($check_pic3=="1" and $userfile3_name==""){
check_pic_out("cms_project","pic3",$id_update,"$_SESSION[web_name]/mainfile/","id");
$name3="";
}
if($check_pic4=="1" and $userfile4_name==""){
check_pic_out("cms_project","pic4",$id_update,"$_SESSION[web_name]/mainfile/","id");
$name4="";
}
if($check_files=="1" and $userfile5_name==""){
check_pic_out("cms_project","files",$id_update,"$_SESSION[web_name]/mainfile/","id");
$name5="";
}
$sql="UPDATE `cms_project` SET `topic` = '$topic', `fulltexts` = '$fulltexts',`pic1` = '$name1',`pic2` = '$name2',`pic3` = '$name3',`pic4` = '$name4',`files` = '$name5',`price` = '$price' WHERE id='$id_update'";
$result = mysql_query($sql) or die(mysql_error());
msg_update_data(); // ข้อความแก้ไขแล้ว
refresh_data('index.php?mod=project&path=project',"2"); // refresh หน้าจอ
fieldset_down();
?>
|