File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/www/FerTours/all_php_files/photo_system.php

<? ob_start(); ?>
<?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"])){
	$sql = "SELECT COUNT(id) FROM galeria '";
	$query = mysqli_query($db_conx, $sql);
	$row = mysqli_fetch_row($query);
	if($row[0] > 300){
		header("location: ../message.php?msg=Ju keni arritur limitin tuaj prej 300 fotosh te ngarkuara ne sistem");
        exit();	
	}
	$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){
		header("location: ../message.php?msg=ERROR: Kjo foto nuk mund te ngarkohet !");
        exit();	
	}
	if($fileSize > 10485760) {
		header("location: ../message.php?msg=ERROR: Imazhi juaj eshte me i > se 10 MB");
		exit();	
	} else if (!preg_match("/\.(gif|jpg|png)$/i", $fileName) ) {
		header("location: ../message.php?msg=ERROR: Imazhi juaj nuk eshte i tipit jpg, gif ose png ");
		exit();
	} else if ($fileErrorMsg == 1) {
		header("location: ../message.php?msg=ERROR: An unknown error occurred");
		exit();
	}
	$moveResult = move_uploaded_file($fileTmpLoc, "../img/$db_file_name");
	if ($moveResult != true) {
		header("location: ../message.php?msg=ERROR: Imazhi nuk u ngarkua");
		exit();
	}
	include_once("image_resize.php");
	$wmax = 800;
	$hmax = 600;
	if($width > $wmax || $height > $hmax){
		$target_file = "../img/$db_file_name";
	    $resized_file = "../img/$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);
	header("location: ../photos.php?u=$log_username");
	exit();
}
?><?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[1];
		$picurl = "../img/$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();
}
?>
<? ob_flush(); ?>

Batal

⬅ Naik ke FerTours 5 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘db_conx.php	php	236 B	2019-01-13 01:16	✏️ Edit 👁️ View
🐘dbconnect.php	php	534 B	2019-01-13 01:17	✏️ Edit 👁️ View
🐘image_resize.php	php	803 B	2019-01-13 01:02	✏️ Edit 👁️ View
🐘photo_system.php	php	3.4 KB	2019-01-13 01:02	✏️ Edit 👁️ View
🐘status.php	php	1.7 KB	2019-01-13 01:02	✏️ Edit 👁️ View