function displayMembersRecommended($user) { $result1 = queryMysql("SELECT score FROM members WHERE user='******'"); $row = $result1->fetch_array(MYSQLI_ASSOC); $score = $row['score']; $max = $score + 5; $min = $score - 5; // To find the members recommended, is to to find if their score is in the range of max and min // Reason for this: To find a member who uses the web application as much as the user if ($min < 0) { $min = -1; } $result2 = queryMysql("SELECT * FROM members WHERE '{$min}'<score AND score<'{$max}' AND NOT user='******'"); if ($result2->num_rows) { while ($row2 = $result2->fetch_array(MYSQLI_ASSOC)) { $name = $row2['user']; $score = $row2['score']; echo <<<_END <div class='individualUser'> Score: {$score}<br> _END; showUserPicture($name); $reply = getWatching($name, $user); if ($reply == "Watching this user") { echo <<<_END <a href='otherProfile.php?view={$name}'>{$name}</a><br> <a href='findMembers.php?stopWatching={$name}'>[Stop Watching]</a> </div> _END; } else { echo <<<_END <a href='otherProfile.php?view={$name}'>{$name}</a><br> <a href='findMembers.php?startWatching={$name}'>[Watch]</a> </div> _END; } // end else statement } } else { displayAllMembers($user); } }
<li><a href='logout.php'>Log out</a></li> </ul> </li> </ul> </div> </div> <div class='inputEverything'> <div id='selection'> <form method ='get' action='findMembers.php?checkBox'> <input id="checkbox" name="checkBox" type="checkbox" value="1" />All Members <input id="checkbox" name="checkBox" type="checkbox" value="0" />Recommended <br> <button>Choose</button> </form> </div> <div class='members'> <?php if ($check == 0) { displayMembersRecommended($user); } elseif ($check == 1) { displayAllMembers($user); } ?> </div> </div> </body> </html>