<?php
require('header.php');
$name='';
$title='';
$desc='';
$keywords='';
$info='';
$image='';
$msg='';
if(isset($_GET['id']) && $_GET['id']!=''){
$id=get_safe_value($con,$_GET['id']);
$res=mysqli_query($con,"select * from blog where id='$id'");
$check=mysqli_num_rows($res);
if($check>0){
$row=mysqli_fetch_assoc($res);
$name=$row['name'];
$title=$row['title'];
$desc=$row['desc'];
$keywords=$row['keywords'];
$info=$row['info'];
$image=$row['img'];
}else{
header('location:blogs.php');
die();
}
}
if(isset($_POST['submit'])){
$name=get_safe_value($con,$_POST['name']);
$title=get_safe_value($con,$_POST['title']);
$desc=get_safe_value($con,$_POST['desc']);
$keywords=get_safe_value($con,$_POST['keywords']);
$info=get_safe_value($con,$_POST['info']);
$res=mysqli_query($con,"select blog.* from blog where blog.name='$name'");
$check=mysqli_num_rows($res);
if($check>0){
if(isset($_GET['id']) && $_GET['id']!=''){
$getData=mysqli_fetch_assoc($res);
if($id==$getData['id']){
}else{
$msg="Product already exist";
}
}else{
$msg="Product already exist";
}
}
if(isset($_GET['id']) && $_GET['id']==0){
if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg' &&
$_FILES['logo_img']['type']!='image/png' && $_FILES['logo_img']['type']!='image/jpg' && $_FILES['logo_img']['type']!='image/jpeg'
){
$msg="Please select only png,jpg and jpeg image formate";
}
}else{
if($_FILES['image']['type']!=''){
if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg' &&
$_FILES['logo_img']['type']!='image/png' && $_FILES['logo_img']['type']!='image/jpg' && $_FILES['logo_img']['type']!='image/jpeg'){
$msg="Please select only png,jpg and jpeg image formate";
}
}
}
if($msg==''){
if(isset($_GET['id']) && $_GET['id']!=''){
if($_FILES['image']['name'] != ''){
$image = rand(111111111, 999999999) . '_' . $_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'], 'assets/images/blog/' . $image);
$update_sql="UPDATE `blog` SET `name` = '$name',`title` = '$title',`desc` = '$desc',`keywords` = '$keywords', `info` = '$info', `img` = '$image' WHERE `blog`.`id` = $id;";
mysqli_query($con,$update_sql);
} else {
$update_sql="UPDATE `blog` SET `name` = '$name',`title` = '$title',`desc` = '$desc',`keywords` = '$keywords', `info` = '$info' WHERE `blog`.`id` = $id;";
mysqli_query($con,$update_sql);
}
}else{
$image = rand(111111111, 999999999) . '_' . $_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'], 'assets/images/blog/' . $image);
$sql = "INSERT INTO `blog` (`name`,`title`,`desc`,`keywords`, `img`, `info`, `added_on`)
VALUES ('$name','$title','$desc','$keywords', '$image', '$info', current_timestamp())";
mysqli_query($con,$sql);
$id=mysqli_insert_id($con);
}
redirect('blogs.php');
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Diabease</title>
<link rel="shortcut icon" href="../assets/images/diabease/DiabEaseLogo.png" />
<link rel="stylesheet" href="vendors/bundle.css" type="text/css">
<link rel="stylesheet" href="vendors/slick/slick.css" type="text/css">
<link rel="stylesheet" href="vendors/slick/slick-theme.css" type="text/css">
<link rel="stylesheet" href="vendors/datepicker/daterangepicker.css" type="text/css">
<link rel="stylesheet" href="vendors/dataTable/datatables.min.css" type="text/css">
<link rel="stylesheet" href="assets/css/app.min.css" type="text/css">
</head>
<script src="https://cdn.ckeditor.com/4.11.1/standard/ckeditor.js"></script>
<script>
window.onload = function() {
CKEDITOR.replace('info');
};
</script>
<body class="">
<div class="content-body">
<div class="content">
<div class="page-header">
<nav aria-label="breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.php">Home</a>
</li>
<li class="breadcrumb-item">
<a href="add-blog.php">Add blog</a>
</li>
</ol>
</nav>
</div>
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-body">
<form class="needs-validation" novalidate="" method="post"
enctype="multipart/form-data">
<div class="form-row">
<div class="col-md-3 mb-3">
<label for="validationCustom01"> name</label>
<input type="text" class="form-control" name="name"
placeholder="name"
value="<?php echo $name?>">
</div>
<div class="col-md-3 mb-3">
<label for="validationCustom01"> title</label>
<input type="text" class="form-control" name="title"
placeholder="title"
value="<?php echo $title?>">
</div>
<div class="col-md-3 mb-3">
<label for="validationCustom01"> desc</label>
<input type="text" class="form-control" name="desc"
placeholder="desc"
value="<?php echo $desc?>">
</div>
<div class="col-md-3 mb-3">
<label for="validationCustom01"> keywords</label>
<input type="text" class="form-control" name="keywords"
placeholder="keywords"
value="<?php echo $keywords?>">
</div>
<div class="col-md-6 mb-3">
<label for="validationCustom01">Image</label>
<input type="file" name="image" class="form-control">
<?php
if($image!=''){
echo "<a target='_blank' href='assets/images/blog/$image'><img width='150px' src='assets/images/blog/$image'/></a>";
}
?>
</div>
<div class="col-md-12 mb-3">
<label for="validationCustom01"> info</label>
<textarea name="info" class="form-control" cols="10" rows="5">
<?php echo $info ?></textarea>
</div>
<br>
<button class="btn btn-primary" id="payment-button" name="submit"
type="submit">Submit form</button>
<div class="field_error"><?php echo $msg?></div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('footer.php')?>
</div>
</div>
</div>
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script>
$(document).ready(function() {
$('#orders').DataTable({
paging: true // Enable pagination
});
});
</script>
<script src="vendors/bundle.js"></script
<script src="https://apexcharts.com/samples/assets/irregular-data-series.js"></script>
<script src="vendors/charts/apex/apexcharts.min.js"></script>
<script src="vendors/datepicker/daterangepicker.js"></script>
<script src="vendors/dataTable/datatables.min.js"></script>
<script src="assets/js/examples/dashboard.js"></script>
<script src="vendors/vmap/jquery.vmap.min.js"></script>
<script src="vendors/vmap/maps/jquery.vmap.usa.js"></script>
<script src="assets/js/examples/vmap.js"></script>
<script src="assets/js/examples/pages/ecommerce-dashboard.js"></script>
<script src="assets/js/app.min.js"></script>
</body>
</html>