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
| //************************************************************************************
// Actions
//************************************************************************************
if($action = $_POST['action']){
$maxsize = 300000;
$unique_id = time();
$filesize = $_FILES['image']['size'];
$filetmpname = $_FILES['image']['tmp_name'];
$filename = $_FILES['image']['name'];
$filetype = $_FILES['image']['type'];
$img_jpg = array("image/pjpeg", "image/jpeg");
$img_gif = "image/gif";
$img_png = array("image/png", "image/x-png");
if($action=="insert"){
$db->query("SELECT max(id) as maxid from photos");
$db->next_record();
$id = $db->f("maxid");
}
$filename = $_FILES['image']['name'];
if (!move_uploaded_file($_FILES['image']['tmp_name'], $dir.$filename)){
echo "";
}else{
createThumb($dir.$filename, array('h'=>600), false);
createThumb($dir.$filename, array('h'=>260), true);
}
$nom = str_replace("\n", "<br />", $_POST['nom']);
$description = str_replace("\n", "<br />", $_POST['description']);
$categorie = str_replace("\n", "<br />", $_POST['categorie']);
$ordre = $_POST['ordre'];
$id = $_POST['id'];
if($action=="update"){
$req = "UPDATE photos SET
nom='$nom',
description='$description',
categorie='$categorie',
ordre='$ordre'";
if($filename) $req .= ", image='$filename' ";
$req .= " WHERE id=$id";
$db->query($req);
$action = "update";
}else if($action=="insert"){
$req = "INSERT INTO photos
(cre_date, nom, image, description, categorie, ordre)
VALUES
(now(), '$nom', '$filename', '$description', '$categorie', '$ordre')";
$db->query($req);
$id = $db->inserted_key();
$action = "update";
} else if($action=="delete"){
$req = "DELETE FROM photos WHERE id=$id";
$db->query($req);
$action = "insert";
}
} |
