1#@!#!123s

: / home / grandhou / www / admin /
Filename : manage-contact.php
back
<?php
session_start();
if(strlen($_SESSION['alogin'])==0)
	{	
header('location:index.php');
}
include('include/constant.php');
include('include/pdo.php');
error_reporting( ~E_NOTICE );
	
$id = '1';
		$stmt_edit = $DB_con->prepare('SELECT * FROM getintouch WHERE id =:uid');
		$stmt_edit->execute(array(':uid'=>$id));
		$edit_row = $stmt_edit->fetch(PDO::FETCH_ASSOC);
		extract($edit_row);		
if(isset($_POST['btn_save_updates']))
	{
		$id = $_POST['txtCityId'];
		 $metatitle = htmlspecialchars($_POST['metatitle'], ENT_QUOTES, 'UTF-8'); 
		 $metadesc = htmlspecialchars($_POST['metadesc'], ENT_QUOTES, 'UTF-8'); 
 $description1 = htmlspecialchars($_POST['description1'], ENT_QUOTES, 'UTF-8'); 
 $description2 = htmlspecialchars($_POST['description2'], ENT_QUOTES, 'UTF-8'); 

		$imgFile7 = $_FILES['puser_image7']['name'];
		$tmp_dir7 = $_FILES['puser_image7']['tmp_name'];
		$imgSize7 = $_FILES['puser_image7']['size'];
		
		$imgFile8 = $_FILES['puser_image8']['name'];
		$tmp_dir8 = $_FILES['puser_image8']['tmp_name'];
		$imgSize8 = $_FILES['puser_image8']['size'];
		
		
			if($imgFile7)
		{
			$upload_dir7 = 'upload/'; // upload directory	
			$imgExt7 = strtolower(pathinfo($imgFile7,PATHINFO_EXTENSION)); // get image extension
			$valid_extensions7 = array('jpeg', 'jpg', 'png', 'gif'); // valid extensions
			$headerimage1 = rand(1000,1000000).".".$imgExt7;
			if(in_array($imgExt7, $valid_extensions7))
			{			
				if($imgSize7 < 5000000)
				{
					unlink($upload_dir7.$edit_row['headerimage1']);
					move_uploaded_file($tmp_dir7,$upload_dir7.$headerimage1);
				}
				else
				{
					$errMSG7 = "Sorry, your file is too large it should be less then 5MB";
				}
			}
			else
			{
				$errMSG7 = "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";		
			}	
		}
		else
		{
			// if no image selected the old image remain as it is.
			$headerimage1 = $edit_row['headerimage1']; // old image from database
		}
		
					if($imgFile8)
		{
			$upload_dir8 = 'upload/'; // upload directory	
			$imgExt8 = strtolower(pathinfo($imgFile8,PATHINFO_EXTENSION)); // get image extension
			$valid_extensions8 = array('jpeg', 'jpg', 'png', 'gif'); // valid extensions
			$headerimage2 = rand(1000,1000000).".".$imgExt8;
			if(in_array($imgExt8, $valid_extensions8))
			{			
				if($imgSize8 < 5000000)
				{
					unlink($upload_dir8.$edit_row['headerimage2']);
					move_uploaded_file($tmp_dir8,$upload_dir8.$headerimage2);
				}
				else
				{
					$errMSG8 = "Sorry, your file is too large it should be less then 5MB";
				}
			}
			else
			{
				$errMSG8 = "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";		
			}	
		}
		else
		{
			// if no image selected the old image remain as it is.
			$headerimage2 = $edit_row['headerimage2']; // old image from database
		}
	// if no error occured, continue ....
		if(!isset($errMSG8) and !isset($errMSG7))
		{
			$stmt = $DB_con->prepare('UPDATE getintouch 
									     SET id=:uprop, 
										     metatitle=:metatitle, 
										     metadesc=:metadesc,
											 description1=:description1,
											 description2=:description2,
											 headerimage1=:headerimage1,
											 headerimage2=:headerimage2
										WHERE id=:uid');
			$stmt->bindParam(':uprop',$id);
			$stmt->bindParam(':metatitle',$metatitle);   
			$stmt->bindParam(':metadesc',$metadesc);
			$stmt->bindParam(':description1',$description1);
			$stmt->bindParam(':description2',$description2);
			$stmt->bindParam(':headerimage1',$headerimage1);
			$stmt->bindParam(':headerimage2',$headerimage2);
			
			$stmt->bindParam(':uid',$id);
			if($stmt->execute()){
				?>
                <script>
				alert('Successfully Updated ...');
				window.location.href='manage-contact.php';
				</script>
                <?php
			}
			else{
				$errMSG = "Sorry Data Could Not Updated !";
			}
		}					
	}
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Wedding Photo Sydeny Price Details</title>
	<link type="text/css" href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
	<link type="text/css" href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">
<link rel="shortcut icon" href="upload/favicon.ico">
	<link type="text/css" href="css/theme.css" rel="stylesheet">
	<link type="text/css" href="images/icons/css/font-awesome.css" rel="stylesheet">
    <link rel="stylesheet" href="imgup/style.css">
	<link type="text/css" href='http://fonts.googleapis.com/css?family=Open+Sans:400italic,600italic,400,600' rel='stylesheet'>
<link rel="stylesheet" href="tinymce/style.css">
<script src="<?php echo $tiny; ?>" referrerpolicy="origin"></script>
<script src="tiny.js" type="text/javascript"></script>
</head>
<body oncontextmenu="return false;">
<script>
document.onkeydown = function(e) {
if(event.keyCode == 123) {
return false;
}
if(e.ctrlKey && e.shiftKey && e.keyCode == 'I'.charCodeAt(0)){
return false;
}
if(e.ctrlKey && e.shiftKey && e.keyCode == 'J'.charCodeAt(0)){
return false;
}
if(e.ctrlKey && e.keyCode == 'U'.charCodeAt(0)){
return false;
}
}
</script>
<?php include('include/header.php');?>

	<div class="wrapper">
		<div class="container">
			<div class="row">
<?php include('include/sidebar.php');?>				
			<div class="span9">
					<div class="content">

						<div class="module">
							<div class="module-head">
								<h3>Manage Contact</h3>
							</div>
							<div class="module-body">

									<?php if(isset($_POST['submit']))
{?>
									<div class="alert alert-success">
										<button type="button" class="close" data-dismiss="alert">×</button>
									<strong>Well done!</strong>	<?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?>
									</div>
<?php } ?>
						<br />
				<form class="form-horizontal row-fluid" method="post" enctype="multipart/form-data" >
						  <?php
								  $Id='1';
$STH = $DB_con->query("select * from getintouch where id='$Id'");
# setting the fetch mode
$STH->setFetchMode(PDO::FETCH_OBJ);
# showing the results
while($row = $STH->fetch()) {
	$aa='bg.jpg';
?>
<div class="control-group">
<div class="controls">
<input type="hidden" name="txtCityId" id="txtCityId" value="<?php echo $row->id;?>" class="span8 tip" readonly required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="basicinput">Meta Title</label>
<div class="controls">
<input type="text" name="metatitle" id="metatitle" value="<?php echo $row->metatitle;?>" class="span8 tip" required>
</div>
</div>

<div class="control-group">
<label class="control-label" for="basicinput">Meta Description</label>
<div class="controls">
<input type="text" name="metadesc" rows="6" value="<?php echo $row->metadesc;?>" style="width:70%;"/>
</div>
</div>

<div class="control-group">
<label class="control-label" for="basicinput">Description 1</label>
<div class="controls">
<textarea name="description1" cols="30" rows="10"/><?php echo $row->description1;?></textarea>
<input name="image" type="file" id="upload" class="hidden" onchange="">
</div>
</div>

<div class="control-group">
<label class="control-label" for="basicinput">Image 1<br> ( 800x500  )</label>
<div class="controls">
<img src="upload/<?php if(empty($row->headerimage1)){echo $aa;} else{echo $row->headerimage1;}?>" width="50px" height="50px" alt="No Image"/>
<input type="file" name="puser_image7" accept="image/*" />
</div>
<br>
</div>	

<div class="control-group">
<label class="control-label" for="basicinput">Description 2</label>
<div class="controls">
<textarea name="description2" cols="30" rows="10"/><?php echo $row->description2;?></textarea>
<input name="image" type="file" id="upload" class="hidden" onchange="">
</div>
</div>


<div class="control-group">
<label class="control-label" for="basicinput">Image 2<br> ( 800x500 )</label>
<div class="controls">
<img src="upload/<?php if(empty($row->headerimage2)){echo $aa;} else{echo $row->headerimage2;}?>" width="50px" height="50px" alt="No Image"/>
<input type="file" name="puser_image8" accept="image/*" />
</div>
<br>
</div>	


<div class="control-group">
											<div class="controls">
												<button type="submit" name="btn_save_updates" class="btn">Update</button>
											</div>
										</div>
<?php } ?>
									</form>
						</div>
					</div><!--/.content-->
				</div><!--/.span9-->
			</div>
		</div><!--/.container-->
	</div><!--/.wrapper-->
</div>
<?php include('include/footer.php');?>
	<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
	<script>
		$(document).ready(function() {
			$('.datatable-1').dataTable();
			$('.dataTables_paginate').addClass("btn-group datatable-pagination");
			$('.dataTables_paginate > a').wrapInner('<span />');
			$('.dataTables_paginate > a:first-child').append('<i class="icon-chevron-left shaded"></i>');
			$('.dataTables_paginate > a:last-child').append('<i class="icon-chevron-right shaded"></i>');
		} );
	</script>

</body>