bnmbnerterterterterterdfgdfgdfgdfgdfgdfgdfgdfgdfg

hjkhhrtertererrrrrerrtertertertertertertert bnmbnerterterterterterdfgdfgdfgdfgdfgdfgdfgdfgdfg

<?php
ob_start();
include("../configuration/function-include.php");

$nav = 'addtestimonial';

if(!empty($_REQUEST['DID'])){ $_REQUEST['DID'] = $_REQUEST['DID']; } else { $_REQUEST['DID'] = ''; }
if(!empty($_REQUEST['datafrmSubmit'])){ $_REQUEST['datafrmSubmit'] = $_REQUEST['datafrmSubmit']; } else { $_REQUEST['datafrmSubmit'] = ''; }

//Fetch Data From Database...............
$sql_select = "Select * from testimonial where id = '".$_REQUEST['DID']."'";
$query_select = mysqli_query($conn, $sql_select);
$res_select = mysqli_fetch_array($query_select);

//Insert & Update Data in Database......
if($_REQUEST['datafrmSubmit'] == 'Submit'){
	
	if(!empty($_REQUEST['DID'])){
		
		if($_FILES["img"]["name"]){
			$photo=$_FILES["img"]["name"];
			$photo_arr = explode('.',$photo);
			$len1=count($photo_arr);
			$len1-=1;
			$f_name = time().".".$photo_arr[$len1];
			move_uploaded_file($_FILES["img"]["tmp_name"],"../upload/testimonial/".$f_name);
			$sql_update="update testimonial set img = '".$f_name."' where id='".$_GET['DID']."'";
			$result=mysqli_query($conn, $sql_update);
		}
		
		$sql_update = "update testimonial set name = '".$_REQUEST['name']."',description = '".$_REQUEST['description']."', update_date_time = '".date("Y-m-d h:i:sa")."' where id = '".$_REQUEST['DID']."'";
		$query_update = mysqli_query($conn, $sql_update);
		$_SESSION['msg'] = "Record updated successfully.";
		header("location:managetestimonial.php");
		
		
	} else {
		
		if($_FILES["img"]["name"]){
			$photo=$_FILES["img"]["name"];
			$photo_arr = explode('.',$photo);
			$len1=count($photo_arr);
			$len1-=1;
			$f_name = time().".".$photo_arr[$len1];
			move_uploaded_file($_FILES["img"]["tmp_name"],"../upload/testimonial/".$f_name);
		}
		
		$sql_insert = "insert into testimonial set name = '".$_REQUEST['name']."',description = '".$_REQUEST['description']."', img = '".$f_name."', update_date_time = '".date("Y-m-d h:i:sa")."', status = '1'";
		$query_insert = mysqli_query($conn, $sql_insert);
		$_SESSION['msg'] = "New record added successfully.";
		header("location:managetestimonial.php");

}
}

/********To Delete Image**********/
if(!empty($_GET['delimg'])){

$sql_img = "select * from testimonial where id = '".$_GET['delimg']."'";
	$result = mysqli_query($conn, $sql_img);
	$row_img = mysqli_fetch_array($result);
	
	$sql = "update testimonial set img = '' where id='".$_GET['delimg']."'";
	$result = mysqli_query($conn, $sql);

@unlink("../upload/testimonial/".$row_img['img']);
	header("location: $_SERVER[HTTP_REFERER]");
  	exit();
}
/**********End of Code************/
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Add Testimonial :: <?php echo $websitedname;?></title>
  
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  
  <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
  
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css">
  
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
</head>
<body class="hold-transition skin-blue sidebar-mini">

<div class="wrapper">

<?php include("top-include.php");?>

<?php include("left-include.php");?>

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Testimonial
        <small>client testimonial</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="index.php"><i class="fa fa-dashboard"></i> Home</a></li>
        <li><a href="#">Testimonial</a></li>
        <li class="active">Add Testimonial</li>
      </ol>
    </section>

<section class="content">
    
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary">
                <div class="box-header">
                    <h3 class="box-title">Add Testimonial</h3>
                    <hr>
                </div>
                
                <form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
                <div class="box-body">
                    <div class="row">
                        <div class="col-lg-9">
                            <div class="form-group">
                                <label>Name</label>
                                <input class="form-control input-lg" type="text" name="name" id="name" value="<?php echo $res_select['name'];?>" />
                            </div>
                             <div class="form-group">
                                <label>Image</label>
                                <?php if(!empty($res_select['img'])){ ?>
                                	<img src="../upload/testimonial/<?php echo $res_select['img'];?>" class="img-responsive" style="height:100px;" />
                                	<a href="addtestimonial.php?delimg=<?php echo $res_select['id'];?>" class="btn btn-block btn-danger btn-sm" style="width:100px; margin-top:20px;">Remove Image</a>
                                	<input type="hidden" name="img" id="img" value="<?php echo $res_select['img']?>" />
                                <?php } else { ?>
                                	<input class="form-control input-lg" type="file" name="img" id="img" value="" />
                                <?php } ?>
                            </div>
                            
                            <div class="form-group">
                                <label>Description</label>
                                <textarea id="editor1" name="description" rows="10" cols="80"><?php echo $res_select['description'];?></textarea>
                            </div>
                            
                            <div class="form-group">
                            	<input type="submit" class="btn btn-block btn-primary btn-lg" style="width:140px;" name="datafrmSubmit" id="datafrmSubmit" value="Submit" />
                            </div>
                        </div>
                    </div>
                </div>
                </form>
                
            </div>
        </div>
    </div>
    
    </section>
    
  </div>

<?php include("footer-include.php");?>

<?php include("sidebar-include.php");?>
  
  
</div>

<script src="plugins/jQuery/jQuery-2.2.0.min.js"></script>

<script src="bootstrap/js/bootstrap.min.js"></script>

<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>

<script src="plugins/fastclick/fastclick.js"></script>

<script src="dist/js/app.min.js"></script>

<script src="dist/js/demo.js"></script>

<script src="https://cdn.ckeditor.com/4.4.3/standard/ckeditor.js"></script>

<script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>
<script>
  $(function () {
    // Replace the <textarea id="editor1"> with a CKEditor
    // instance, using default configuration.
    CKEDITOR.replace('editor1');
    //bootstrap WYSIHTML5 - text editor
    $(".textarea").wysihtml5();
  });
</script>
</body>
</html>