-
Notifications
You must be signed in to change notification settings - Fork 0
/
edit_post.php
127 lines (120 loc) · 3.5 KB
/
edit_post.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
<?php
session_start();
include("includes/data_connect.php");
$get_topics="select * from users";
$xyz=mysqli_query($con,$get_topics);
$row=mysqli_fetch_array($xyz);
$stat=$row['status'];
if($stat=='None')
{
header("location: index.php");
}
include("functions/function.php");
?>
<html>
<head>
<title>Welcome User?</title>
<link rel="stylesheet" href="styles/home_style.css" media="all"/>
</head>
<body>
<div class="container">
<div id="head_wrap">
<div id="header">
<ul id="menu">
<li><a href="home.php">Home</a></li>
<li><a href="members.php">Members</a></li>
<strong>Topics:</strong>
<?php
$get_topics="select * from topics";
$run_topics=mysqli_query($con,$get_topics);
while($row=mysqli_fetch_array($run_topics))
{
$topic_id=$row['topic_id'];
$topic_name=$row['topic_name'];
echo "<li><a href='topic.php?topic=$topic_id'>$topic_name</a></li>";
}
?>
</div>
<div class="content">
<div id="user_timeline">
<div id="user_details">
<?php
$user=$_SESSION['user_email'];
$get_user="select * from users where user_email='$user'";
$run_user=mysqli_query($con,$get_user);
$row=mysqli_fetch_array($run_user);
$user_id=$row['user_id'];
$user_name=$row['user_name'];
$user_country=$row['user_country'];
$user_image=$row['user_image'];
$register_date=$row['user_reg_date'];
$last_login=$row['user_last_login'];
$user_posts="select * from posts where user_id='$user_id'";
$run_posts=mysqli_query($con,$user_posts);
$posts=mysqli_num_rows($run_posts);
$sel_msg="select * from messages where receiver='$user_id'";
$run_msg=mysqli_query($con,$sel_msg);
$count_msg=mysqli_num_rows($run_msg);
echo "<center>
<img src='Users/$user_image' width='200' height='200'/>
</center>
<div id='user_mention'>
<p><strong>Name:</strong>$user_name</p>
<p><strong>Country:</strong>$user_country</p>
<p><strong>Member Since:</strong>$register_date</p>
<p><a href='my_posts.php'?u_id=$user_id'>My Posts($posts)</a></p>
<p><a href='my_messages.php'?u_id=$user_id'>My Messsages($count_msg)</a></p>
<p><a href='edit_profile.php?u_id=$user_id'>Edit Profile</a></p>
<p><a href='logout.php'>Logout</a></p>
</div>
";
?>
</div>
</div>
</div>
<div>
<?php
if(isset($_GET['post_id']))
{
$get_id=$_GET['post_id'];
$get_post="select * from posts where post_id='$get_id'";
$run_post=mysqli_query($con,$get_post);
$row=mysqli_fetch_array($run_post);
$post_title=$row['post_title'];
$post_con=$row['post_content'];
}
?>
<form action="" method="post" id="f">
<h2>Edit Post:</h2>
<input type="text" name="title" value="
<?php echo $post_title; ?>"
size="85" required="required"/><br/>
<textarea cols="86" rows="7" name="content">
<?php echo $post_con;?> </textarea><br/>
<select name="topic">
<option> Select Topic</option>
<?php getTopics(); ?>
</select>
<input type="submit" name="update" value="Update Post"/>
</form>
<?php
if(isset($_POST['update']))
{
$title=$_POST['title'];
$content=$_POST['content'];
$topic=$_POST['topic'];
$update_post="update posts set post_title='$title',
post_content='$content', topic_id='$topic' where post_id='$get_id'";
// echo $get_id;
$run_update=mysqli_query($con,$update_post);
if($run_update)
{
echo "<script>alert('Post has been updated!')</script>";
}
}
?>
</div>
</div>
</div>
</body>
</html>