function username_exists($username) { $db = makePDO(); $dbUsername = $db->quote($username); $rows = $db->query("SELECT *\n FROM User_Accounts\n WHERE Username = {$dbUsername}\n LIMIT 1"); return $rows->rowCount(); }
function show_friends_from_db($sender) { $db = makePDO(); $db_sender = $db->quote($sender); $list_of_friends = $db->query("SELECT * FROM Friend_Table WHERE (Requester={$db_sender} OR Receiver={$db_sender}) ORDER BY Friend_ID DESC;"); return $list_of_friends; }
function show_friends_from_db($sender) { $db = makePDO(); $email = get_email($sender); $email->execute(); $result = $email->fetchAll(); $string = $result['Username'] . $result['Email'] . $result['Password'] . $result['Country']; //print("<p> HI THERE"); //print($string); //print("</p>"); $db_email = $db->quote($sender); $list_of_friends = $db->query("SELECT * FROM Friend_Table WHERE (Requester={$db_email} OR Receiver={$db_email}) ORDER BY Friend_ID DESC;"); return $list_of_friends; }