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";
}
} |
Partager