/var/www/c-c.com.hk/webadmin/project_image_add.php


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
<?php
include 'config.php';

// Check if the user is logged in

if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require(
"configure.php"); 
require(
"function_createthumb.php");

$pdid                htmlspecialchars($_POST["pdid"],ENT_QUOTES);
$nowdate             date("Y-m-d H:i:s");
//print_r($_POST); 

// copy image
$x=1;
for(
$i=1;$i<=10;$i++){    
    if (
$_FILES['pimgfile']['name'][$i] <> '')
    {
        if ((
$_FILES['pimgfile']["type"][$i] == "image/bmp") || ($_FILES['pimgfile']["type"][$i] == "image/BMP") || ($_FILES['pimgfile']["type"][$i] == "image/gif") || ($_FILES['pimgfile']["type"][$i] == "image/GIF") || ($_FILES['pimgfile']["type"][$i] == "image/jpg") || ($_FILES['pimgfile']["type"][$i] == "image/JPG") || ($_FILES['pimgfile']["type"][$i] == "image/jpeg") || ($_FILES['pimgfile']["type"][$i] == "image/JPEG") || ($_FILES['pimgfile']["type"][$i] == "image/pjpeg") || ($_FILES['pimgfile']["type"][$i] == "image/PJEG") || ($_FILES['pimgfile']["type"][$i] == "image/png") || ($_FILES['pimgfile']["type"][$i] == "image/x-png") || ($_FILES['pimgfile']["type"][$i] == "image/PNG") || ($_FILES['pimgfile']["type"][$i] == "image/X-PNG"))
        {
            
$sql "select max(pimgid) as maxid ";
            
$sql .= "from project_img ";
            
$result=mysql_query($sql);
            
$row mysql_fetch_array($result,MYSQL_ASSOC);
            
$pimgid $row{maxid}+1;
            
            
$sql2 "select max(pimgsort) as maxid ";
            
$sql2 .= "from project_img where pdid=$pdid ";
            
$result2=mysql_query($sql2);
            
$row2 mysql_fetch_array($result2,MYSQL_ASSOC);
            
$pimgsort $row2{maxid}+1;
            
            
$filename=$_FILES['pimgfile']['name'][$i];
            
preg_match("/\.([^\.]+)$/"$filename$file_ext);
            
            
copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
                or die (
"Could not copy the file: Project Photo"); 
            
            
$image "../project/".$pdid."_id_".$pimgid.".".$file_ext[1];
            
createthumb($image$image800800);
            
            
copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/large/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
                or die (
"Could not copy the file: Project Photo(large)"); 
            
            
$imagelarge "../project/large/".$pdid."_id_".$pimgid.".".$file_ext[1];
            
createthumb($imagelarge$imagelarge280280);
            
            
copy ($_FILES['pimgfile']['tmp_name'][$i], "../project/thumb/".$pdid."_id_".$pimgid.".".$file_ext[1]) 
                or die (
"Could not copy the file: Project Photo(thumb)"); 
            
            
$imagethumb "../project/thumb/".$pdid."_id_".$pimgid.".".$file_ext[1];
            
createthumb($imagethumb$imagethumb140140);
            
            
$pimgfile[$i] = $pdid."_id_".$pimgid.".".$file_ext[1];
            
$pimgfile[$i] = htmlspecialchars($pimgfile[$i],ENT_QUOTES);
            
            
// Save DB                    
            
$sql "insert into project_img (pimgid, pdid, pimgfile, pimgsort, creationday, modifyday, cmsloginid) values ('$pimgid', '$pdid', '".$pimgfile[$i]."', '".$pimgsort."', '$nowdate', '$nowdate', '".$_SESSION['cmsloginid']."')";
            
mysql_query($sql);
            if( 
mysql_errno() > ){
                echo 
'Add Project Detail(Images) Error:<br />'mysql_error() .'<br />SQL: '$sql;
                exit;
            }
            
$x++;    
          }
        else
          {
          
// upload error
          
?>
            <script language="javascript">
            alert("Files must be BMP, JPEG, GIF, or PNG");
            history.back();
            </script>
         <?php
         
exit;
         }        
    }
    else
    {
        
$pimgfile[$i] = "";
    }
    
    
}
// End copy image


mysql_close($dbh);

header("Location: project_image_index.php?pdid=$pdid&msg=Add Successful");
?>