-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpost.php
More file actions
179 lines (124 loc) · 5.91 KB
/
post.php
File metadata and controls
179 lines (124 loc) · 5.91 KB
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
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
<?php
include "includes/dp.php"
?>
<?php
include "includes/header.php"
?>
<body>
<!-- Navigation -->
<?php
include "includes/nav.php"
?>
<!-- Page Content -->
<div class="container">
<div class="row">
<!-- Blog Entries Column -->
<div class="col-md-8">
<?php
if(isset($_GET['p_id'])){
$the_post_id=$_GET['p_id'];
$query ="SELECT * FROM posts WHERE post_id = $the_post_id";
// the above query mean that it will select only that posts whose post id is given by the user so it mean that user cant directly see the post.php page he or she have to give some id then depending on that id only post of that id will be shown to user
$select_all_post_query = mysqli_query($connection,$query);
while($row=mysqli_fetch_assoc($select_all_post_query)){
$post_title=$row['post_title'];
$post_author=$row['post_author'];
$post_date=$row['post_date'];
$post_image=$row['post_image'];
$post_content=$row['post_content'];
// uper maine varaible me jo bhi stire kiya hai wo kya hai let see that :-
// maine kuch nahi kiya sabke phele maine $row varaible me apne database ki sari row ko store kar diya uske bad ab muje pura database ko to print karna nahin hai ume se kuch values ko print karna hai , to mai kya hu (database side by side dekhte rehna tab or ache se samjega mere database me bahut sari columns hai lekin muje to mai kya kar raha hu har row ke kuch specific coloum ko print kar raha hu jaise ki :- $row['post_title'] iss line me maine kya kiya mai row me gaya uske bad jis colum ka nam 'post_title' hai shrif ussi ki value uthai or uske $post_title iss variable me store kar diya )
?>
<h1 class="page-header">
Post
</h1>
<!-- First Blog Post -->
<h2>
<a href="#"><?php echo $post_title ?></a>
</h2>
<p class="lead">
by <a href="index.php"><?php echo $post_author ?></a>
</p>
<p><span class="glyphicon glyphicon-time"></span> <?php echo $post_date ?></p>
<hr>
<img class="img-responsive" src="images/<?php echo $post_image; ?>"alt="">
<hr>
<p><?php echo $post_content ?></p>
<hr>
<?php }
?>
<!-- Blog Comments -->
<?php
if(isset($_POST['create_comment'])){
$the_post_id=$_GET['p_id'];
$comment_author=$_POST['comment_author'];
$comment_email=$_POST['comment_email'];
$comment_content=$_POST['comment_content'];
$query="INSERT INTO comments(comment_post_id,comment_author,comment_email,comment_content,comment_status,comment_date) ";
$query .="VALUES ($the_post_id,'{$comment_author}','{$comment_email}','{$comment_content}','unapprove',now()) ";
$create_comment_query=mysqli_query($connection,$query);
if(!$create_comment_query){
confirmQuery($create_comment_query);
}
}
?>
<!-- Comments Form -->
<div class="well">
<h4>Leave a Comment:</h4>
<form action="" method="post" role="form">
<div class="form-group">
<label for="Author">Auhtor:-</label>
<input type="text" class="form-control" name="comment_author" required>
</div>
<div class="form-group">
<label for="Email">Email:-</label>
<input type="email" class="form-control" name="comment_email" required>
</div>
<div class="form-group">
<label for="Comments">Your Comments:-</label>
<textarea name="comment_content" class="form-control" rows="3" required ></textarea>
</div>
<button type="submit" name="create_comment" class="btn btn-primary">Submit</button>
</form>
</div>
<hr>
<!-- Posted Comments -->
<?php
$query = "SELECT * FROM comments WHERE comment_post_id={$the_post_id} ";
$query .= "AND comment_status = 'Approved' ";
$query .= "ORDER BY comment_id DESC ";
$select_comment_query = mysqli_query($connection,$query);
if(!$select_comment_query){
confirmQuery($select_comment_query);
}
while ($row=mysqli_fetch_array($select_comment_query)){
$comment_date=$row['comment_date'];
$comment_content=$row['comment_content'];
$comment_author=$row['comment_author'];
?>
<!-- Comment -->
<div class="media">
<a class="pull-left" href="#">
<img class="media-object" src="http://placehold.it/64x64" alt="">
</a>
<div class="media-body">
<h4 class="media-heading"><?php echo $comment_author ?>
<small><?php echo $comment_date ?></small>
</h4>
<?php echo $comment_content ?>
</div>
</div>
<?php } } else{
header("Location:index.php");
} ?>
</div>
<!-- Blog Sidebar Widgets Column -->
<?php
include "includes/side.php"
?>
</div>
<!-- /.row -->
<hr>
<?php
include "includes/footer.php"
?>