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;
}
