Viewing file:  settings.php (10.22 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
error_reporting(0);
include 'conn.php';
require_once "auth.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title><?php include('title.php') ?></title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="plugins/fontawesome-free/css/all.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="plugins/summernote/summernote-bs4.css">
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<link rel="shortcut icon" type="image/png" href="images/fav.png">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/themify-icons.css">
<link rel="stylesheet" href="css/animate.css">
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="css/red.css" id="style_theme">
<link rel="stylesheet" href="css/responsive.css">
<link rel="stylesheet" href="charts/css/morris.css">
<link rel="stylesheet" href="css/jquery-jvectormap.css">
<link rel="stylesheet" href="datatable/dataTables.bootstrap4.min.css">
</head>
<body>
<!-- Pre Loader -->
<div class="loading">
<div class="spinner">
<div class="double-bounce1"></div>
<div class="double-bounce2"></div>
</div>
</div>
<!--/Pre Loader -->
<div class="wrapper">
<!-- Sidebar -->
<?php include('sidebar.php') ?>
<!-- /Sidebar -->
<!-- Page Content -->
<div id="content">
<div>
<?php include('topbar.php') ?>
</div>
<?php
date_default_timezone_set('Asia/Kabul');
$today = date("D d M Y");
$resultt = mysqli_query($con, "SELECT * FROM settings ");
$roww = mysqli_fetch_array($resultt);
if (isset($_POST['publise'])) {
$site_name = $_POST['site_name'];
$site_name_fa = $_POST['site_name_fa'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$address = $_POST['address'];
$facebook = $_POST['facebook'];
$twitter = $_POST['twitter'];
$linkedin = $_POST['linkedin'];
$instagram = $_POST['instagram'];
$map = $_POST['map'];
$delete_query = mysqli_query($con, "DELETE FROM settings");
$newStartValue = 1;
$query1 = "ALTER TABLE settings AUTO_INCREMENT = $newStartValue";
$result = mysqli_query($con, $query1);
// Handle image upload for s1
if ($_FILES['s1']['name'] != '') {
// Delete old image for s1
if (!empty($roww["s1"])) {
$oldImagePath = "images/slider/" . $roww["s1"];
if (file_exists($oldImagePath)) {
unlink($oldImagePath);
}
}
// Upload new image for s1
$s1 = rand() . $_FILES['s1']['name'];
$tempname = $_FILES['s1']['tmp_name'];
$folder = "images/slider/" . $s1;
move_uploaded_file($tempname, $folder);
} else {
$s1 = $roww["s1"];
}
// Handle image upload for s2
if ($_FILES['s2']['name'] != '') {
// Delete old image for s2
if (!empty($roww["s2"])) {
$oldImagePath = "images/slider/" . $roww["s2"];
if (file_exists($oldImagePath)) {
unlink($oldImagePath);
}
}
// Upload new image for s2
$s2 = rand() . $_FILES['s2']['name'];
$tempname = $_FILES['s2']['tmp_name'];
$folder = "images/slider/" . $s2;
move_uploaded_file($tempname, $folder);
} else {
$s2 = $roww["s2"];
}
// Use prepared statements to prevent SQL injection
$insertdata = mysqli_prepare($con, "INSERT INTO settings (s1, s2, site_name, site_name_fa, phone, email, address, facebook, twitter, linkedin, instagram, map) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
mysqli_stmt_bind_param($insertdata, "ssssssssssss", $s1, $s2, $site_name, $site_name_fa, $phone, $email, $address, $facebook, $twitter, $linkedin, $instagram, $map);
mysqli_stmt_execute($insertdata);
// Check for successful insertion
if (mysqli_stmt_affected_rows($insertdata) > 0) {
echo "<script>alert('Posted Successfully');</script>
<script>window.location.href = 'settings.php'</script>";
} else {
echo "<script>alert('Error while insert information');</script>
<script>window.location.href = 'settings.php'</script>";
}
mysqli_stmt_close($insertdata);
}
?>
<div class="row no-margin-padding">
<div class="col-md-6">
<h3 class="block-title">Settings/تنظیمات سایت</h3>
</div>
<div class="col-md-6">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.html">
<span class="ti-home"></span>
</a>
</li>
<li class="breadcrumb-item">Settings</li>
</ol>
</div>
</div>
<div class="content-wrapper">
<section class="content" style = "width:1000px; margin-left:-200px;">
<form action="" method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-12">
<div class="card card-outline card-info">
<div class="card-header">
<div class="form-group">
<label>Site Name</label>
<input name="site_name" value="<?php echo $roww["site_name"]; ?>" type="text" class="form-control" placeholder="Enter ...">
</div>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="title_fa" dir="rtl" style="text-align: right; padding-right: 40px;" ></label>
<input type="text" class="form-control" value="<?php echo $roww["site_name_fa"]; ?>" id="site_name_fa" name="site_name_fa" placeholder="نام سایت " required>
</div>
<div class="card-header">
<div class="form-group">
<label>Phone</label>
<input name="phone" value="<?php echo $roww["phone"]; ?>" type="text" class="form-control" placeholder="Enter ...">
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Company Email</label>
<input name="email" value="<?php echo $roww["email"]; ?>" type="text" class="form-control" placeholder="Enter ...">
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Map</label>
<textarea name="map" class="form-control" placeholder="Enter Iframe Code">
<?php echo $roww["map"]; ?>
</textarea>
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Full Address</label>
<input name="address" value="<?php echo $roww["address"]; ?>" type="text" class="form-control" placeholder="Enter ...">
</div>
</div>
</div>
</div>
<!-- /.col-->
<div class="col-md-12">
<div class="card card-outline card-info">
<div class="card-header">
<div class="form-group">
<label>Facebook</label>
<input name="facebook" value="<?php echo $roww["facebook"]; ?>" type="text" class="form-control" placeholder="URL">
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Twitter</label>
<input name="twitter" value="<?php echo $roww["twitter"]; ?>" type="text" class="form-control" placeholder="URL">
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Linkedin</label>
<input name="linkedin" value="<?php echo $roww["linkedin"]; ?>" type="text" class="form-control" placeholder="URL">
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Instagram</label>
<input name="instagram" value="<?php echo $roww["instagram"]; ?>" type="text" class="form-control" placeholder="URL">
</div>
</div>
</div>
<div class="form-group col-md-12">
<label>Slider Images</label>
<input type="file" name="s1" class="form-control" id="file">
</div>
<div class="form-group col-md-12">
<label>Slider Images 2</label>
<input type="file" name="s2" class="form-control" id="file">
</div>
</div>
<div class="col-md-12">
<div class="card-header">
<div class="form-group">
<div class="row">
<div class="col-sm-12">
<!-- text input -->
<div class="form-group">
<center><button type="submit" name="publise" class="btn btn-warning btn-lg">Publish</button></center>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<!-- ./row -->
</section>
</div>
<!-- Back to Top -->
<a id="back-to-top" href="#" class="back-to-top">
<span class="ti-angle-up"></span>
</a>
<script src="js/jquery-3.2.1.min.js"></script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="datatable/jquery.dataTables.min.js"></script>
<script src="datatable/dataTables.bootstrap4.min.js"></script>
<script src="js/custom.js"></script>
<script src="js/custom-datatables.js"></script>
<script src="plugins/jquery/jquery.min.js"></script>
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="dist/js/adminlte.min.js"></script>
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<script>
$(function () {
$('.textarea').summernote()
})
</script>
</body>
</html>
|