Blogging-System/deleteblog.php at master · bhaskargoyal/Blogging-System · GitHub

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
<?php
	session_start();
	require_once('./connect.php');
	if(isset($_SESSION['login'])){
		if($_SESSION['login']){
			if(isset($_SESSION['username'])){

				if(isset($_POST['submit'])){
					$select = $_POST['select'];
					if($select == "no"){
						header("Location: home.php");
						exit();
					}
					$query = "SELECT id FROM users WHERE username = '".$_SESSION['username']."';";
					$result1 = mysqli_query($con, $query);
					$row = mysqli_fetch_assoc($result1);
					$userid = $row['id'];
					$query = "DELETE FROM blogs WHERE id ='".$_SESSION['blogid']."' AND user_id = ".$userid.";";
					$result = mysqli_query($con, $query);
					if($result == True){
						$_SESSION['status'] = "Successfully Deleted";
						header("Location: home.php");
						exit();
					} else {
						$_SESSION['status'] = "Unsuccessfull Delete";
						header("Location: home.php");
						exit();
					}

				} else {
					// create a form

					if(!isset($_GET['blog'])){
						header("Location: home.php");
						exit();
					}
					$_SESSION['blogid'] = $_GET['blog'];
					$query = "SELECT * FROM blogs WHERE id = ".$_SESSION['blogid'].";";
					$result = mysqli_query($con, $query);
					$row = mysqli_fetch_assoc($result);
				?>
<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="css/opensanslight.css" />
	<link rel = "stylesheet" href="css/style.css" type="text/css">
	<title>Blogging System | Delete Blog</title>
</head>
<body>
	<div class="container">
		<div id="head-navbar">
			<div id="logo" class="menu inline">
				<h3 style="margin:0px;">Blogging System</h3>
			</div>
			<div class="menu inline pull-right">
				<a class="btn btn-info" href="home.php">Back</a>
			</div>
		</div>

	    <div class="row give-top-margin">
			<div class="col-sm-2 col-sm-offset-5">
						<form method="post" action="deleteblog.php">
							<div class="form-group">
						        	<label for="select">Confirm </label>
						            <select name="select">
						            	<option value="no">No</option>
										<option value="yes">Yes</option>
									</select>
						        </div>
							<button type="submit" name="submit" class="btn btn-primary" value="submit">Delete Blog</button>
						</form>

			</div>
		</div>
	</div>
					<script src="js/jquery.js"></script>
	<script src="js/bootstrap.js"></script>
	<script type="text/javascript" src="js/script.js"></script>
					</body>
					</html>
					<?php
				}
			} else {
				header("Location: logout.php");
				exit();
			}
		}
	} else {
		$_SESSION['wrong'] = "You are logged out.";
		header("Location: index.php");
		exit();
	}

?>