Viewing file:  add-training.php (13.53 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");
$edit = $_GET['edit'];
$delete = $_GET['delete_id'];
$del = $_GET['delete_id'];
$selectdelete = mysqli_query($con,"SELECT * FROM blog where id=".$del."");
$selectimg = mysqli_fetch_array($selectdelete);
$path = 'images/blog/';
$now_delete = unlink($path.$selectimg['img']);
if($now_delete){
$query_delete="DELETE FROM blog WHERE id='".$_GET['delete_id']."'";
$query_delete_views = "DELETE FROM views WHERE id = '" . $delete . "'";
$p_delete_views = mysqli_query($con, $query_delete_views);
$p = mysqli_query($con, $query_delete);
echo "<script>alert('Deleted Successfully');</script>
<script>window.location.href = 'view-blog.php'</script>";
}
if (isset($_POST['publise'])) {
$newStartValue = 1;
$query1 = "ALTER TABLE blog AUTO_INCREMENT = $newStartValue";
$result1 = mysqli_query($con, $query1);
$title = mysqli_real_escape_string($con, $_POST['title']);
$blog_department = mysqli_real_escape_string($con, $_POST['blog_department']);
$type = mysqli_real_escape_string($con, $_POST['t_type']);
$sub_title = mysqli_real_escape_string($con, $_POST['sub_title']);
$descrip = mysqli_real_escape_string($con, $_POST['descrip']);
$sub_descrip = mysqli_real_escape_string($con, $_POST['sub_descrip']);
$title_fa = mysqli_real_escape_string($con, $_POST['title_fa']);
$descrip_fa = mysqli_real_escape_string($con, $_POST['descrip_fa']);
$sub_image1 = mysqli_real_escape_string($con, $_POST['link']);
$sub_title_fa = mysqli_real_escape_string($con, $_POST['sub_title_fa']);
$sub_descrip_fa = mysqli_real_escape_string($con, $_POST['sub_descrip_fa']);
if ($_FILES['lis_img']['name'] != '') {
$lis_img = rand() . $_FILES['lis_img']['name'];
$tempname = $_FILES['lis_img']['tmp_name'];
$folder = "images/blog/" . $lis_img;
move_uploaded_file($tempname, $folder);
} else {
$lis_img = $roww["img"];
}
$insertdata = mysqli_query($con, "INSERT INTO blog(title, blog_department, type, descrip,img, date, sub_image1, sub_title, sub_descrip, title_fa, descrip_fa, sub_descrip_fa, sub_title_fa) VALUES ('$title', '$blog_department', '$type', '$descrip', '$lis_img', '$today', '$sub_image1', '$sub_title', '$sub_descrip','$title_fa', '$descrip_fa', '$sub_descrip_fa', '$sub_title_fa')");
$newStartValue2 = 1;
$query2 = "ALTER TABLE views AUTO_INCREMENT = $newStartValue2";
$result2 = mysqli_query($con, $query2);
$view = 1;
$view_insert = mysqli_query($con, "INSERT INTO views (views_count) VALUES ($view)");
if ($insertdata && $view_insert) {
echo "<script>alert('Posted Successfully');</script>
<script>window.location.href = 'add-training.php'</script>";
} else {
echo "<script>alert('Failed to Post');</script>
<script>window.location.href = 'add-training.php'</script>";
}
}
?>
<div class="row no-margin-padding">
<div class="col-md-6">
<h3 class="block-title">Add Training / اضافه کردن آموزش</h3>
</div>
<div class="col-md-6">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.php">
<span class="ti-home"></span>
</a>
</li>
<li class="breadcrumb-item">Trainings</li>
</ol>
</div>
</div>
<section class="content">
<div class="row justify-content-center">
<div class="col-md-12">
<form method="post" enctype="multipart/form-data">
<div class="card card-outline card-info">
<div class="form-group col-md-12" style="text-align: right;">
<label for="address" style="font-size: 25px;">اطلاعات آموزش</label>
<hr color="green">
</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>
<textarea name="title_fa" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="sub_title_fa" dir="rtl" style="text-align: right; padding-right: 40px;">عنوان فرعی آموزش</label>
<div class="mb-3">
<textarea name="sub_title_fa" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="descrip_fa" dir="rtl" style="text-align: right; padding-right: 40px;">جزئیات آموزش</label>
<div class="mb-3">
<textarea name="descrip_fa" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="sub_descrip_fa" dir="rtl" style="text-align: right; padding-right: 40px;">جزئیات فرعی</label>
<div class="mb-3">
<textarea name="sub_descrip_fa" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="form-group col-md-12">
<label for="address" style="font-size: 25px;">Training Information</label>
<hr color="green">
</div>
<div class="card-header">
<div class="form-group">
<label>Enter Title</label>
<textarea name="title" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;" class="textarea"></textarea>
</div>
</div>
<div class="card-header" dir="ltr">
<div class="form-group">
<label>Enter sub-title</label>
<textarea name="sub_title" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="card-body pad" style="text-align: left;">
<label>Enter Description</label>
<div class="mb-3">
<textarea name="descrip" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="card-header" dir="ltr" style="text-align: left;">
<label>Enter Sub-Description</label>
<div class="mb-3">
<textarea name="sub_descrip" class="textarea" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="card-header" style="text-align: left;" dir="ltr">
<div class="form-group">
<label>Select Department</label>
<select name="blog_department" class="form-control" >
<option>Select...</option>
<?php
$location = mysqli_query($con, "SELECT * FROM department");
while ($location_ft = mysqli_fetch_array($location)) {
?>
<option <?php if ($blog_row["blog_department"] == $location_ft["d_name"]) {
echo 'selected';
} ?> value="<?php echo $location_ft["d_name"]; ?>"><?php echo $location_ft["d_name"]; ?></option>
<?php
}
?>
</select>
</div>
<div class="form-group" dir="ltr">
<label>Type of Training</label>
<select name="t_type" class="form-control">
<option>Select</option>
<option value="Pro">Professionalism Training</option>
<option value="general">General Training</option>
</select>
</div>
</div>
<div class="card-header" style="text-align: center;">
<div class="form-group">
<label for="exampleInputFile">Select Main Image<span style="color:red;">(only compressed) <br></span></label>
<p style="color:red;">Image size 800px x 800px</p>
<input name="lis_img" type="file">
</div>
</div>
<div class="card-header" style="text-align: center;">
<div class="form-group">
<label for="exampleInputFile">Enter training video link</label>
<p style="color:red;">Youtube Link only</p>
<input name="link" type="text">
</div>
</div>
</div>
<div class="card-header">
<div class="form-group">
<div class="row">
<div style="padding-right: 450px;">
<div class="form-group">
<center><button type="submit" name="publise" class="btn btn-primary btn-lg">Publish Post</button></center>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</section>
<!-- /Main Content -->
</div>
<!-- /Page Content -->
</div>
<!-- Back to Top -->
<a id="back-to-top" href="#" class="back-to-top">
<span class="ti-angle-up"></span>
</a>
<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="dist/js/demo.js"></script>
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<script>
$(function () {
$('.textarea').summernote()
})
</script>
<!-- Popper Library-->
<script src="js/popper.min.js"></script>
<!-- Bootstrap Library-->
<script src="js/bootstrap.min.js"></script>
<!-- Datatable -->
<script src="datatable/jquery.dataTables.min.js"></script>
<script src="datatable/dataTables.bootstrap4.min.js"></script>
<!-- Custom Script-->
<script src="js/custom.js"></script>
</body>
</html>
|