bnmbertsu,yu,yu,yu,uy,ltdfg

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<script type="text/javascript" language="JavaScript1.2" src="../stmenu.js"></script>

<?php
session_start();
// Database configuration

$dbHost     = "localhost";
$dbUsername = "root";
$dbPassword = "";
$dbName     = "easyusep_shoping";

// Create database connection
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

// Check connection
if ($db->connect_error) {
    die("Connection failed: " . $db->connect_error);
}

if(strlen($_SESSION['alogin'])==0)
	{	
header('location:index.php');
}
else{

include('../Mplusedata&base/config.php');	
if(isset($_GET['del']))
		  {
		          mysqli_query($con,"delete from images where id = '".$_GET['id']."'");
                  $_SESSION['delmsg']="images deleted !!";
		  }

<!DOCTYPE html>
<html lang="en">
	<head>
		<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
		<meta charset="utf-8" />
		<title>insert image slider page || Ann</title>
		<meta name="description" content="Static &amp; Dynamic Tables" />
		<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
		
		<link rel="stylesheet" href="assets/css/bootstrap.min.css" />
		<link rel="stylesheet" href="assets/font-awesome/4.5.0/css/font-awesome.min.css" />
		
		
		<link rel="stylesheet" href="assets/css/fonts.googleapis.com.css" />
		
		<link rel="stylesheet" href="assets/css/ace.min.css" class="ace-main-stylesheet" id="main-ace-style" />
		
		<link rel="stylesheet" href="assets/css/ace-skins.min.css" />
		<link rel="stylesheet" href="assets/css/ace-rtl.min.css" />
		
		
		
		<script src="assets/js/ace-extra.min.js"></script>
				<link rel="shortcut icon" type="image/x-icon" href="logo/logo2.jpg">

</head>

<body class="no-skin">
		<?php include("topheader.php");?>
		<div class="main-container ace-save-state" id="main-container">
			<script type="text/javascript">
				try{ace.settings.loadState('main-container')}catch(e){}
			</script>
			<?php include("leftheader.php");?>
	
			<div class="main-content">
				<div class="main-content-inner">
			<div class="page-content">
			
					     <div class="row">
							<div class="col-xs-12">
								
								<div class="hr hr-18 dotted hr-double"></div>
								<div class="row">
									<div class="col-xs-12">
									<div class="module-head">
								<h3><span class="widget-toolbar">
											<?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 } ?>

<?php if(isset($_GET['del']))
{?>
									<div class="alert alert-error">
										<button type="button" class="close" data-dismiss="alert">×</button>
									<strong>Oh snap!</strong> 	<?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?>
									</div>
<?php } ?>
													</span></h3>
							</div>

<div class="row">
							<div class="col-xs">
										<div class="col-xs-12 ">
											<div class="widget-box">
												<div class="table-header">
Insert Slider Image
											
												</div>
		
												<div class="widget-body">
												
													<div class="widget-main">
	<?php
if(isset($_POST['submit'])){
    // Include the database configuration file
    #include_once 'dbConfig.php';
    
    // File upload configuration
    $targetDir = "slider/";
    $allowTypes = array('jpg','png','jpeg','gif');
    
    $statusMsg = $errorMsg = $insertValuesSQL = $errorUpload = $errorUploadType = '';
    if(!empty(array_filter($_FILES['files']['name']))){
        foreach($_FILES['files']['name'] as $key=>$val){
            // File upload path
            $fileName = basename($_FILES['files']['name'][$key]);
            $targetFilePath = $targetDir . $fileName;
            
            // Check whether file type is valid
            $fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
            if(in_array($fileType, $allowTypes)){
                // Upload file to server
                if(move_uploaded_file($_FILES["files"]["tmp_name"][$key], $targetFilePath)){
                    // Image db insert sql
                    $insertValuesSQL .= "('".$fileName."', NOW()),";
                }else{
                    $errorUpload .= $_FILES['files']['name'][$key].', ';
                }
            }else{
                $errorUploadType .= $_FILES['files']['name'][$key].', ';
            }
        }
        
        if(!empty($insertValuesSQL)){
            $insertValuesSQL = trim($insertValuesSQL,',');
            // Insert image file name into database
            $insert = $db->query("INSERT INTO images (file_name, uploaded_on) VALUES $insertValuesSQL");
            if($insert){
                $errorUpload = !empty($errorUpload)?'Upload Error: '.$errorUpload:'';
                $errorUploadType = !empty($errorUploadType)?'File Type Error: '.$errorUploadType:'';
                $errorMsg = !empty($errorUpload)?'<br/>'.$errorUpload.'<br/>'.$errorUploadType:'<br/>'.$errorUploadType;
                $statusMsg = "Files are uploaded successfully.".$errorMsg;
            }else{
                $statusMsg = "Sorry, there was an error uploading your file.";
            }
        }
    }else{
        $statusMsg = 'Please select a file to upload.';
    }
    
    // Display status message
    echo $statusMsg;
}
?>

<div class="page-header">
							<h1>
								 Select Image Files to Upload:
								
							</h1>
						</div>
<form action="" method="post" enctype="multipart/form-data">
   
    <input type="file" name="files[]" multiple >
	<br/>
    <input type="submit" name="submit" value="UPLOAD" class="btn form-control">
</form>

<br/>
<?php
// Include the database configuration file

// Get images from the database
$query = $db->query("SELECT * FROM images ORDER BY id DESC");

?>
						<div class="row">
							<div class="col-xs-12">
								
								<div>
									<ul class="ace-thumbnails clearfix">
									    <?php if($query->num_rows > 0){
    while($row = $query->fetch_assoc()){
        $imageURL = 'slider/'.$row["file_name"]; ?>
										<li>
											<a href="<?php echo $imageURL; ?>" title="Photo Title" data-rel="colorbox">
											     <img width="150" height="150" alt="150x150" src="<?php echo $imageURL; ?>" alt="" />
												
											</a>

<a href="insertsliderimage.php?id=<?php echo $row['id']?>&del=delete" onClick="return confirm('Are you sure you want to delete?')">
													<i class="ace-icon fa fa-times red"></i>
												</a>
											</div>
<?php } }

else{ ?>
    <p>No image(s) found...</p>
<?php } ?>
										</li>

</ul>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>

<script src="assets/js/jquery-2.1.4.min.js"></script>

<script type="text/javascript">
			if('ontouchstart' in document.documentElement) document.write("<script src='assets/js/jquery.mobile.custom.min.js'>"+"<"+"/script>");
		</script>
		<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/jquery.colorbox.min.js"></script>

<script src="assets/js/ace-elements.min.js"></script>
		<script src="assets/js/ace.min.js"></script>

<script type="text/javascript">
			jQuery(function($) {
	var $overflow = '';
	var colorbox_params = {
		rel: 'colorbox',
		reposition:true,
		scalePhotos:true,
		scrolling:false,
		previous:'<i class="ace-icon fa fa-arrow-left"></i>',
		next:'<i class="ace-icon fa fa-arrow-right"></i>',
		close:'&times;',
		current:'{current} of {total}',
		maxWidth:'100%',
		maxHeight:'100%',
		onOpen:function(){
			$overflow = document.body.style.overflow;
			document.body.style.overflow = 'hidden';
		},
		onClosed:function(){
			document.body.style.overflow = $overflow;
		},
		onComplete:function(){
			$.colorbox.resize();
		}
	};

$('.ace-thumbnails [data-rel="colorbox"]').colorbox(colorbox_params);
	$("#cboxLoadingGraphic").html("<i class='ace-icon fa fa-spinner orange fa-spin'></i>");//let's add a custom loading icon
	
	
	$(document).one('ajaxloadstart.page', function(e) {
		$('#colorbox, #cboxOverlay').remove();
   });
})
		</script>
	</body>
</html>

</div>
									</div>
										</div>
									</div>

</div>

<?php } ?>