File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/EspressoBarUsato/espressophp/photo_system.php

<?php
include_once("status.php");
?><?php 
if (isset($_POST["show"]) && $_POST["show"] == "galpics"){
	$picstring = "";
	$gallery = preg_replace('#[^a-z 0-9,]#i', '', $_POST["gallery"]);
	$sql = "SELECT * FROM galeria WHERE postimi='$gallery' ORDER BY data ASC";
	$query = mysqli_query($db_conx, $sql);
	while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
		$id = $row["id"];
		$filename = $row["foto"];
		$description = $row["pershkrimi"];
		$uploaddate = $row["data"];
		$picstring .= "$id|$filename|$description|$uploaddate|||";
    }
	mysqli_close($db_conx);
	$picstring = trim($picstring, "|||");
	echo $picstring;
	exit();
}
?><?php 
if (isset($_FILES["photo"]["name"]) && isset($_POST["gallery"])){
	$gallery = preg_replace('#[^a-z 0-9,]#i', '', $_POST["gallery"]);
	$emri = preg_replace('#[^a-z 0-9,]#i', '', $_POST["emri"]);
foreach($_FILES['photo']['tmp_name'] as $key => $tmp_name )
{
	$fileName =  $key.$_FILES["photo"]["name"] [$key];
    $fileTmpLoc = $_FILES["photo"]["tmp_name"][$key];
	$fileType = $_FILES["photo"]["type"][$key];
	$fileSize = $_FILES["photo"]["size"][$key];
	$fileErrorMsg = $_FILES["photo"]["error"];
	$kaboom = explode(".", $fileName);
	$fileExt = end($kaboom);
	$db_file_name = date("DMjGisY")."".rand(1000,9999).".".$fileExt; // WedFeb272120452013RAND.jpg
	list($width, $height) = getimagesize($fileTmpLoc);
	if($width < 10 || $height < 10){
		echo " Kjo foto nuk mund te ngarkohet !";
        exit();	
	}
	$moveResult = move_uploaded_file($fileTmpLoc, "../images/$db_file_name");
	if ($moveResult != true) {
		echo  "Imazhi nuk u ngarkua";
		exit();
	}
	include_once("image_resize.php");
	$wmax = 800;
	$hmax = 600;
	if($width > $wmax || $height > $hmax){
		$target_file = "../images/$db_file_name";
	    $resized_file = "../images/$db_file_name";
		img_resize($target_file, $resized_file, $wmax, $hmax, $fileExt);
	}
	$sql = "INSERT INTO galeria (postimi, foto,pershkrimi, postuesi, data) VALUES ('$gallery','$db_file_name','$emri','$log_username',now())";
	$query = mysqli_query($db_conx, $sql);
}
	mysqli_close($db_conx);
	 ob_start();
	header("location: ../photos.php?u=$log_username");
	exit();
	ob_flush();
}
?><?php 
if (isset($_POST["delete"]) && $_POST["id"] != ""){
	$id = preg_replace('#[^0-9]#', '', $_POST["id"]);
	$query = mysqli_query($db_conx, "SELECT foto FROM galeria WHERE id='$id' LIMIT 1");
	$row = mysqli_fetch_row($query);
	$filename = $row[0];
		$picurl = "../images/$filename"; 
	    if (file_exists($picurl)) {
			unlink($picurl);
			$sql = "DELETE FROM galeria WHERE id='$id' LIMIT 1";
	        $query = mysqli_query($db_conx, $sql);
		}
	mysqli_close($db_conx);
	echo "deleted_ok";
	exit();
}
?>

Batal

⬅ Naik ke EspressoBarUsato 5 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘db_conx.php	php	253 B	2018-02-11 06:14	✏️ Edit 👁️ View
🐘dbconnect.php	php	560 B	2018-02-11 06:15	✏️ Edit 👁️ View
🐘image_resize.php	php	1.5 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘photo_system.php	php	2.7 KB	2018-02-01 03:51	✏️ Edit 👁️ View
🐘status.php	php	1.5 KB	2018-02-01 03:51	✏️ Edit 👁️ View