-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDeletePost.php
143 lines (138 loc) · 6.79 KB
/
DeletePost.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php require_once("Includes/DB.php"); ?>
<?php require_once("Includes/Functions.php"); ?>
<?php require_once("Includes/Sessions.php"); ?>
<?php
$_SESSION["TrackingURL"]=$_SERVER["PHP_SELF"];
ConfirmLogin();
$PostId=$_GET['Id'];
$sql="SELECT * FROM posts WHERE id=$PostId";
$stmt=$ConnectingDB->query($sql);
while($DataRows=$stmt->fetch()){
$TitleU=$DataRows['title'];
$CategoryU=$DataRows['category'];
$ImageU=$DataRows['image'];
$PostU=$DataRows['post'];
}
if(isset($_POST["Submit"])){
$Target="Uploads/$ImageU";
unlink($Target);
$sql="DELETE FROM posts WHERE id=$PostId";
$Execute=$ConnectingDB->query($sql);
if($Execute){
$_SESSION["SuccessMessage"]="Post deleted successfully";
} else {
$_SESSION["ErrorMessageT"]="Something went wrong. Try again";
}
redirect_to("Posts.php");
}
?>
<!DOCTYPE>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width" , initial-scale=1.0>
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/css/bootstrap.min.css" integrity="sha384-B0vP5xmATw1+K9KRQjQERJvTumQW0nPEzvF6L/Z6nronJ3oUOFUFpCjEUQouq2+l" crossorigin="anonymous">
<link rel="stylesheet" href="CSS/style.css">
<script src="https://kit.fontawesome.com/498d7dfdc9.js" crossorigin="anonymous"></script>
<title>Delete Post</title>
</head>
<body>
<div style="height:10px; background-color:#27aae1"></div>
<!--NAVBAR-->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container">
<a href="#" class="navbar-brand">ALEXSIRBU.COM</a>
<button class="navbar-toggler" data-toggle="collapse" data-target="#navbarcollapseCMS">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarcollapseCMS">
<ul class="navbar-nav mr-auto">
<li class="nav-item"><a href="MyProfile.php" class="nav-link"><i class="fas fa-user text-success"></i> My Profile</a></li>
<li class="nav-item"><a href="Dashboard.php" class="nav-link">Dashboard</a></li>
<li class="nav-item"><a href="Posts.php" class="nav-link">Posts</a></li>
<li class="nav-item"><a href="Categories.php" class="nav-link">Categories</a></li>
<li class="nav-item"><a href="Admins.php" class="nav-link">Manage Admins</a></li>
<li class="nav-item"><a href="Comments.php" class="nav-link">Comments</a></li>
<li class="nav-item"><a href="Blog.php?page=1" class="nav-link">Live Blog</a></li>
</ul>
<ul class="navbar-nav ml-auto">
<li class="nav-item"><a href="Logout.php" class="nav-link">Logout <i class="fas fa-sign-out-alt text-danger"></i></a></li>
</ul>
</div>
</div>
</nav>
<!--NAVBAR END-->
<!--HEADER-->
<header class="bg-dark text-white py-2">
<div class="container">
<div class="row">
<div class="col-md-12">
<h1><i class="fas fa-trash text-danger"></i>Delete Post</h1>
</div>
</div>
</div>
</header>
<!--HEADER END-->
<!--Main Area-->
<section class="container py-2 mb-4">
<div class="row">
<div class="offset-lg-1 col-lg-10" style="min-height:717px">
<?php echo ErrorMessageP(); ?>
<?php echo SuccessMessage(); ?>
<?php echo WarningMessage(); ?>
<form class="" action="DeletePost.php?Id=<?php echo $PostId; ?>" method="POST" enctype="multipart/form-data">
<div class="card bg-secondary text-light">
<div class="card-body bg-dark">
<div class="form-group">
<label for="title"><span class="FieldInfo">Post Title:</span> </label>
<input disabled class="form-control" type="text" name="PostTitle" id="title" value="<?php echo $TitleU; ?>">
</div>
<div class="form-group">
<span class="FieldInfo">Category:</span> <?php echo $CategoryU; ?><br>
</div>
<div class="form-group">
<span class="FieldInfo">Image:</span> <img src="Uploads/<?php echo $ImageU; ?>" class="mb-2" width="170px" height="70px"> <br>
</div>
<div class="form-group">
<label for="Post"><span class="FieldInfo">Post:</span></label>
<textarea disabled class="form-control" id="Post" name="PostDescription" rows="8" cols="80">
<?php echo $PostU; ?>
</textarea>
</div>
<div class="row">
<div class="col-lg-6 mb-2">
<a href="Dashboard.php" class="btn btn-warning btn-block"><i class="fas fa-arrow-left"></i> Back To Dashboard</a>
</div>
<div class="col-lg-6 mb-2">
<button type="submit" name="Submit" class="btn btn-danger btn-block">
<i class="fas fa-trash"></i> Delete
</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</section>
<!--EndMain Area-->
<!--FOOTER-->
<footer class="bg-dark text-white">
<div class="container">
<div class="row">
<div class="col">
<p class="lead text-center"> Theme by | Alex Sirbu | <span id="year"></span> © ----All rights reserved.</p>
</div>
</div>
</div>
</footer>
<!--FOOTER END-->
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/js/bootstrap.min.js" integrity="sha384-+YQ4JLhjyBLPDQt//I+STsc9iw4uQqACwlvpslubQzn4u2UU2UFM80nGisd026JF" crossorigin="anonymous"></script>
<script>
$('#year').text(new Date().getFullYear());
</script>
</body>
</html>