<?php $query = 'select * from users_photo ' . "where userID=" . $customerID; $result = $db->query($query); $num_results = $result->num_rows; for ($i = 0; $i < $num_results; $i++) { $row = $result->fetch_assoc(); echo '<img src="users_photo/' . $row['photo'] . '" height="100">'; } ?> <section> <?php if (isset($_GET['customerID'])) { $customerID = $_GET['customerID']; } print_basic_info($customerID, $db); ?> description: <br/> <p> <?php $query = 'select * from users_description ' . "where userID=" . $customerID; $result = $db->query($query); $Intro = NULL; $Mate_Criteria = NULL; $Life_Style = NULL; while ($row = $result->fetch_assoc()) { switch ($row['type']) { case "Intro": $Intro = $row['description']; break;
<header> <h1>heydate</h1> </header> <nav> <a href="index.php">Main</a> <a href="logout.php">Logout</a> <a href="registration.php">Register</a> <a href="profile.php">profile</a> </nav> <section> <?php $action = "profile_action.php"; $action_postfix = '?'; print_basic_info($_SESSION['valid_userID'], $db); ?> <?php $query = 'SELECT * FROM users_account RIGHT JOIN(SELECT receiverID FROM (SELECT receiverID, time FROM `users_message` WHERE senderID=' . $_SESSION['valid_userID'] . ' UNION SELECT senderID, time FROM `users_message` WHERE receiverID=' . $_SESSION['valid_userID'] . ') as X group by receiverID order by time DESC)as Y on userID=receiverID'; $Contacters = $db->query($query); while ($row1 = $Contacters->fetch_assoc()) { $contact = $row1['receiverID']; $contact_name = $row1['name']; $query = 'select * from users_message ' . "where (senderID=" . $_SESSION['valid_userID'] . " and receiverID =" . $contact . ")or" . "(receiverID=" . $_SESSION['valid_userID'] . " and senderID =" . $contact . ")" . 'order by time desc'; $message_history = $db->query($query); echo 'contactID: ' . $contact_name;