$conn = new DBCommunication(); $query = "SELECT * FROM whwp_Advert, whwp_User " . "WHERE whwp_Advert.advert_id = :advert_id " . "AND whwp_User.user_id = whwp_Advert.advert_owner"; $conn->prepQuery($query); $conn->bind('advert_id', $advert_id); $resultset = $conn->single(); $price = $resultset->advert_price; $title = $resultset->advert_bookname; //$image = $resultset -> image; $author = $resultset->advert_bookauthor; $user = $resultset->advert_owner; $username = $resultset->user_firstname; //$description = $resultset -> description; $query = "SELECT whwp_Image.image_location FROM whwp_Advert " . "JOIN whwp_AdImage ON whwp_Advert.advert_id = whwp_AdImage.adimage_advert " . "JOIN whwp_Image ON whwp_AdImage.adimage_image = whwp_Image.image_id " . "WHERE whwp_Advert.advert_id = :advert_id"; $conn->prepQuery($query); $conn->bind('advert_id', $advert_id); $image = $conn->resultset(); foreach ($image as $element) { echo "<img src = itemPhotos/" . $element->image_location . " alt=" . $title . " title=" . $title . "<br/>"; } echo "Price: " . $price . "<br/>"; echo "Title: " . $title . "<br/>"; echo "Author: " . $author . "<br/>"; // echo "Description: " . $description . "<br/>"; echo "Posted by: <a href='user.php?user_id={$user}'>" . $username . "</a><br/>"; echo "<hr/>"; } catch (PDOException $e) { echo 'Something went wrong'; } ?> <div id="form2"> <h2>Post a comment:</h2>
<?php require 'DBCommunication.php'; header('Content-type: application/json'); $response_array = array('success' => false, 'data' => ''); try { $conn = new DBCommunication(); $query = "SELECT category_id,category_Description FROM whwp_Category"; $conn->prepQuery($query); $response_array['data'] = $conn->resultset(); $response_array['success'] = true; } catch (PDOException $e) { } echo json_encode($response_array);
</ul> </div> </div> </div> <div class="col-lg-9"> <div class="panel panel-default"> <div class="panel-heading">My Books</div> <div class="panel-body"> <?php try { $conn = new DBCommunication(); if (isset($_SESSION['user_id'])) { $query = "SELECT advert_id,advert_bookname,advert_price FROM whwp_Advert WHERE advert_owner=:user_id AND ((NOT advert_expired=1) OR (advert_expired IS NULL))"; $conn->prepQuery($query); $conn->bind('user_id', $_SESSION['user_id']); $result = $conn->resultset(); echo "<table class=\"table table-hover\">"; echo "<thead>"; echo "<tr>"; echo "<th style=\"width:20%\">ID</th>"; echo "<th style=\"width:20%\">Title</th>"; echo "<th style=\"width:20%\">Price</th>"; echo "<th style=\"width:40%\"></th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; foreach ($result as $item) { echo "<tr id='book" . $item->advert_id . "'>"; echo "<td>" . $item->advert_id . "</td>"; echo "<td>" . $item->advert_bookname . "</td>"; echo "<td>" . $item->advert_price . "</td>";
if (!isset($_SESSION['user_id'])) { echo "You need to log in first!"; header("refresh:3;url=login.php"); } else { // Check which user is logged in $user_id = $_SESSION['user_id']; // Getting messages from the database /*$query = "SELECT * FROM message, message_text WHERE :user_id = receiver_id " . "AND message.message_id = message_text.message_id";*/ try { // Establishing a connection to the database $conn = new DBCommunication(); $query = "SELECT * FROM whwp_Message WHERE :user_id = message_recipient ORDER BY message_date,message_time DESC"; $conn->prepQuery($query); $conn->bind('user_id', $user_id); $message = $conn->resultset(); $countMessages = $conn->rowCount(); if ($countMessages == 0) { echo "You have no messages in your inbox!"; } else { echo "<table class='table'>"; echo "<tr><th>Sender</th><th>Title</th>" . "<th>Time Sent</th></tr>"; foreach ($message as $element) { $message_id = $element->message_id; $sender_id = $element->message_sender; $query = "SELECT user_firstname FROM whwp_User WHERE user_id = :user"; $conn->prepQuery($query); $conn->bind('user', $sender_id); $resultset = $conn->single(); $sender = $resultset->user_firstname; $title = $element->message_subject;
$page = $_GET["page"]; $search_term = $_GET["search"]; } else { //$page = 10; $page = 1; header("location:search.php?search={$search_term}&Search=Search&page=1"); } // Determine which results to show in which page. //$start_from = ($page-1) * 10; $start_from = ($page - 1) * 10; // How many results per one page $pageLimit = 10; $query = "SELECT DISTINCT whwp_Advert.* FROM whwp_Advert, whwp_AdTag, whwp_Tag " . "WHERE whwp_Tag.tag_description LIKE :search_string " . "AND whwp_Tag.tag_id = whwp_AdTag.adtag_tag " . "AND whwp_AdTag.adtag_advert = whwp_Advert.advert_id " . "ORDER BY whwp_Advert.advert_id " . "LIMIT {$start_from}, {$pageLimit}"; $conn->prepQuery($query); $conn->bind('search_string', $search_string); $advert = $conn->resultset(); foreach ($advert as $element) { echo "<p>"; echo "<a href='showAdvert.php?advert_id=" . $element->advert_id . "'>"; echo $element->advert_bookname; echo "</a>"; echo " " . $element->advert_price; echo "</p>"; } // Determining how many pages will be needed and outputting them. $totalPages = ceil($count / $pageLimit); for ($i = 1; $i <= $totalPages; $i++) { echo "<a href='search.php?search={$search_term}&Search=Search&page={$i}'>{$i}</a> "; } } catch (PDOException $e) { echo 'Something went wrong.';
$conn->prepQuery($query); $conn->bind('user_id', $user_id); $user = $conn->single(); $username = $user->user_firstname; echo "The page of " . $username; // Set the target as a private message receiver $_SESSION['target_id'] = $user_id; // If the user is not in his own page - displaay the link to PM if (isset($_SESSION['user_id']) && $_SESSION['user_id'] !== $user_id) { echo "<a href='send_message.php'><img src='images/pm.png' id='pm' alt='Private Message' title='Private Message'/></a>"; } // Query to get all the ads from the user, whose page is accessed. $query = "SELECT * FROM whwp_Advert WHERE advert_owner = :user_id"; $conn->prepQuery($query); $conn->bind('user_id', $user_id); $ad = $conn->resultset(); $countAds = $conn->rowCount(); if ($countAds == 0) { echo "<br/>No adverts uplaoded by this user!"; } else { echo "<h2>Ads uploaded by: " . $username . ":</h2>"; foreach ($ad as $element) { $advert_id = $element->advert_id; $price = $element->advert_price; $title = $element->advert_bookname; echo "<p><a href ='showAdvert.php?advert_id={$advert_id}'>" . $title . " " . $price . "</a></p>"; } } } catch (PDOException $e) { echo "Something went wrong."; }