download_query.php

<?php
session_start();
include_once "functions.php";
$download=new organic_food();
if(isset($_POST["submit"]))
{
	$download_type=$_POST["download_type"];
	$downloadcat_id=$_POST["downloadcat_id"];
	$download_id=$_POST["download_id"];
	$download_name=$_POST["download_name"];
	$download_url=$_POST["download_url"];
	$download_position=$_POST["download_position"];
	$image=preg_replace("/\s+/","_",$_FILES["image"]["name"]);
	$ext=pathinfo($image, PATHINFO_EXTENSION);
	$filename=pathinfo($image, PATHINFO_FILENAME);
	$image="img/download/".date("dMy_His").".".$ext;
	$status="0";
	date_default_timezone_set('Asia/Calcutta'); 
	$created_date=date("Y-m-d h:i:s");
	if($_FILES["image"]["name"]<>'')
	{
		move_uploaded_file($_FILES["image"]["tmp_name"],$image);
		$sql=$download->download_insert($download_type,$downloadcat_id,$download_id,$download_name,$download_url,$download_position,$image,$status,$created_date);
		if($sql)
		{
			$_SESSION["err"]='
		<div class="alert alert-success alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-check"></i>  Your Download is Succesfully Added.
                </div>
		';
			header("location:add-download.php");
		}
	}
	else{
		$image='';
		$sql=$download->download_insert($download_type,$downloadcat_id,$download_id,$download_name,$download_url,$download_position,$image,$status,$created_date);
		if($sql)
		{
			$_SESSION["err"]='
		<div class="alert alert-success alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-check"></i>  Your Download is Succesfully Added.
                </div>
		';
			header("location:add-download.php");
		}
	}
}

if(isset($_POST["update"]))
{
	$id=$_POST["txt_id"];
	$download_type=$_POST["download_type"];
	$downloadcat_id=$_POST["downloadcat_id"];
	$download_id=$_POST["download_id"];
	$download_name=$_POST["download_name"];
	$download_url=$_POST["download_url"];
	$download_position=$_POST["download_position"];
	$image=preg_replace("/\s+/","_",$_FILES["image"]["name"]);
	$ext=pathinfo($image, PATHINFO_EXTENSION);
	$filename=pathinfo($image, PATHINFO_FILENAME);
	$image="img/download/".date("dMy_His").".".$ext;
	date_default_timezone_set('Asia/Calcutta'); 
	$last_update=date("Y-m-d h:i:s");
	$test_image=$_FILES["image"]["name"];
	if($test_image<>'')
	{
		if($ext!=="jpg" and $ext!=="jpeg" and $ext!=="png" and $ext!=="gif" and $ext!=="pdf" and $ext!=="JPG" and $ext!=="JPEG")
		{
			$_SESSION["update_err"]='
			<div class="alert alert-danger alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-ban"></i>  Only Images are allowed in Image Section
                </div>
			';
			header("location:add-download.php?update=".$id."");
		}
		elseif(!move_uploaded_file($_FILES["image"]["tmp_name"],$image))
		{
			$_SESSION["update_err"]='
			<div class="alert alert-danger alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-ban"></i>  File not uploaded Due to Image-Size in Image Section
                </div>
			';
			header("location:add-download.php?update=".$id."");
		}
		else
		{
			$del_img=$download->download_single_data($id);
			$delrow=$del_img->fetch(PDO::FETCH_ASSOC);
			unlink($delrow["image"]);
			$sql=$download->download_updatedata($download_type,$downloadcat_id,$download_id,$download_name,$download_url,$download_position,$image,$last_update,$id);
			if($sql)
			{
				$_SESSION["update_err"]='
				<div class="alert alert-success alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-check"></i>  Your Download is Succesfully Updated.
                </div>
				';
				header("location:add-download.php?update=".$id."");
			}
		}
	}
	else
	{
		$sql=$download->download_update($download_type,$downloadcat_id,$download_id,$download_name,$download_url,$download_position,$last_update,$id);
		if($sql)
		{
				$_SESSION["update_err"]='
				<div class="alert alert-success alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-check"></i>  Your Download is Succesfully Updated.
                </div>
				';
				header("location:add-download.php?update=".$id."");
		}
	}
}

//category Status Updation
if(isset($_GET["status_update"]))
{
	$sql=$download->download_status($_GET["status"],$_GET["status_update"]);
	if($sql)
	{
		header("location:add-download.php");
	}
}
//category Status Updation
if(isset($_GET["delete"]))
{
	$del_img=$download->download_single_data($_GET["delete"]);
	$delrow=$del_img->fetch(PDO::FETCH_ASSOC);
	unlink($delrow["image"]);
	
	$sql=$download->download_delete($_GET["delete"]);
			$_SESSION["d_err"]='
		<div class="alert alert-success alert-dismissible">
                  <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                  <i class="icon fas fa-check"></i>  Download deletion is successfully done.
                </div>
		';
		header("location:add-download.php");
}
?>

docroot: /home/gplohaghat24/domains/gplohaghat.org.in/public_html

curdir: /home/gplohaghat24/domains/gplohaghat.org.in/public_html/admin

	.	4096
	..	4096
X	add-administration.php	11253
X	add-banner.php	10281
X	add-committee.php	11607
X	add-department.php	12075
X	add-download.php	14617
X	add-event.php	12470
X	add-faculty.php	14432
X	add-join.php	10235
X	add-message.php	11927
X	add-news.php	10817
X	add-officials.php	11488
X	add-product.php	10760
X	add-recruiters.php	11019
X	add-shortnews.php	10913
X	add-throughts.php	10907
X	administration_query.php	5266
X	alumini_query.php	6082
X	aside.php	6291
	assets	47
X	banner_query.php	5040
X	category_query.php	5414
X	changepassword.php	5807
X	changepassword_exe.php	1913
X	committee_query.php	5489
X	connection.php	109
X	create-category.php	9977
X	create-downloadcat.php	8612
X	department_query.php	6498
	dist	38
X	download_query.php	5436
X	downloadcat_query.php	2137
X	event_query.php	5210
	extrahead	48
X	extrahead.php	183
X	faculty_query.php	5602
X	feedback_query.php	867
X	footer.php	135
X	forms.php	28572
X	functions.php	51760
X	header.php	884
X	home.php	13551
	img	4096
	includes	72
X	index.php	3464
X	input.php	0
X	join_query.php	4967
X	login.php	1853
X	logout.php	162
X	manage-product.php	6710
X	message_query.php	5529
X	news_query.php	4779
X	officials_query.php	5544
	plugins	4096
X	product_query.php	8244
X	recruiters_query.php	5343
X	shortnews_query.php	5002
X	throughts_query.php	5002
X	view-alumini.php	11560
X	view-feedback.php	6216