10 if(isset($_SESSION[
'loggedin']))
17 <title>PlacementExperience | Posts</title>
19 <meta charset=
"utf-8">
20 <meta name=
"viewport" content=
"width=device-width, initial-scale=1, shrink-to-fit=no">
21 <link rel=
"stylesheet" href=
"https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity=
"sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin=
"anonymous">
24 <link href=
"https://fonts.googleapis.com/css2?family=Montserrat:wght@700&display=swap" rel=
"stylesheet">
25 <link href=
"https://fonts.googleapis.com/css2?family=Nunito:wght@800&family=Roboto+Mono&display=swap" rel=
"stylesheet">
26 <link href=
"https://fonts.googleapis.com/css2?family=Montserrat:wght@500&display=swap" rel=
"stylesheet">
28 <link rel=
"stylesheet" href=
"https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
30 <link rel=
"stylesheet" type=
"text/css" href=
"css/style.css">
41 <div
class=
"col-sm-3" style=
"left:0px;">
42 <div
class=
"container-fluid sidenav">
43 <a href=
"mainpage.php"><img src=
"img/logoo.png" style=
"width:100px; margin-top:15px;"></a>
47 <a style=
"text-decoration: none;" href=
"https://www.cse.iitb.ac.in" target=
"_blank">
48 <h6 style=
"text-align: center;">Department of</h6>
49 <h6 style=
"text-align: center;">Computer Science and Engineering</h6>
50 <h5 style=
"text-align: center;">IIT Bombay</h5>
55 <li><a href=
"mainpage.php"> HOME </a></li>
56 <li><a href=
"posts.php"> POSTS </a></li>
57 <li><a href=
"exp_form.php">SHARE</a></li>
58 <li><a href=
"profile.php"> PROFILE </a></li>
62 <h5>Important Links</h5>
64 <li style=
"font-size:10px;"><a href=
"http://www.iitb.ac.in/" target=_blank> IITB Home</a></li>
65 <li style=
"font-size:10px;"><a href=
"https://www.cse.iitb.ac.in/"> CSE@IITB </a></li>
66 <li style=
"font-size:10px;"><a href=
"https://asc.iitb.ac.in/"> ASC </a></li>
75 <div
class=
"container-fluid col-md-8 whole" style=
"margin-top:0px;">
78 <div
class=
"col-sm-8 main" id=
"title">
79 <img src=
"img/heading_trans.png" alt=
"placementExperience" style=
"align-content: center; margin-left: 25%; margin-right: 25%;">
81 <div
class=
"col-sm-4" style=
"left:0px; padding-top:20px; vertical-align: center;">
82 <button
id=
"logout" type=
"button" class=
"btn btn-info btn-round" style=
"float:right;">
85 <a href=
"profile.php"><i
class=
"fa fa-user-circle-o" style=
"font-size:36px; float:right; padding-right:10px;" ></i></a>
92 <h3 style=
"color: #e67f11; text-align: center">Posts</h3>
94 <div style=
"float:right">
95 <form action=
"" method=
"post">
96 <input
id=
"search" name=
"search" type=
"text" placeholder=
"Search By Company Name" onkeyup=
"stoppedTyping()">
97 <input
class=
"primary" id=
"submit" name=
"searchbtn" type=
"submit" value=
"Search">
103 <!--Fetching Posts -->
105 $user_email = $_SESSION[
'Logged_email'];
106 if(!isset($_POST[
'searchbtn'])){
107 $sql =
"SELECT id,name, companyname, story, roundprovided, created_at FROM posts ORDER BY created_at DESC";
108 $result = mysqli_query($db, $sql);
110 if (mysqli_num_rows($result) > 0) {
111 while($row = mysqli_fetch_assoc($result)) {
114 <div
class=
"card bg-white" style=
"border:3px solid gray;">
115 <div
class=
"card-header">
116 <?php echo
'<p id="post_headings"><b>Name:</b> ' .$row[
'name'].
'</p>';?>
117 <?php echo
'<h4 id="post_company"><b>Company:</b> '.$row[
'companyname'].
'</h4>';?>
118 <?php echo
'<p id="post_company"><b>Round Provided:</b> '.$row[
'roundprovided'].
'</p>';?>
122 <div
class=
"card-body">
123 <?php echo
'<p id="post_body"> '.$row[
'story'].
'</p>'; ?>
125 <div
class=
"card-footer">
126 <?php echo
'<h6 style="float: right;"> Posted on '.date(
'jS M Y', strtotime($row[
'created_at'])).
'</h6>';?>
137 $search = $_POST[
'search'];
139 $sql =
"SELECT id,name, companyname, story, roundprovided, created_at FROM posts WHERE companyname like '$search%' ORDER BY created_at DESC";
140 $result = mysqli_query($db, $sql);
141 if (mysqli_num_rows($result) > 0) {
142 while($row = mysqli_fetch_assoc($result)) {
144 <div
class=
"card bg-white" style=
"border:3px solid gray;">
145 <div
class=
"card-header">
146 <?php echo
'<p id="post_headings"><b>Name:</b> ' .$row[
'name'].
'</p>';?>
147 <?php echo
'<h4 id="post_company"><b>Company:</b> '.$row[
'companyname'].
'</h4>';?>
148 <?php echo
'<p id="post_company"><b>Round Provided:</b> '.$row[
'roundprovided'].
'</p>';?>
152 <div
class=
"card-body">
153 <?php echo
'<p id="post_body"> '.$row[
'story'].
'</p>'; ?>
155 <div
class=
"card-footer">
156 <?php echo
'<h6 style="float: right;"> Posted on '.date(
'jS M Y', strtotime($row[
'created_at'])).
'</h6>';?>
164 }
else{echo
'<em style="color:red; font-size:50px;"><i>No Result Found</i></em>';}
178 <p style=
"color:#e88924">Ⓒ Copyright@IITB</p>
181 <!-- Bootstrap scripts -->
183 <script src=
"https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity=
"sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin=
"anonymous"></script>
184 <script src=
"https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity=
"sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin=
"anonymous"></script>
185 <script src=
"https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity=
"sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin=
"anonymous"></script>
187 <script type=
"text/javascript">
188 document.getElementById(
"logout").onclick =
function () {
189 location.href =
"logout.php";
205 header(
"location: index.php");