public function search($searchValue)
{
$searchValue = $searchValue . "%";
$query = "SELECT DISTINCT username, profile_picture, banner_picture, welcome_msg FROM bs_users WHERE username LIKE ?;";
return parent::secureExecute($query, $searchValue);
}
public function insertUser($username, $email, $password, $firstname, $lastname, $IBAN)
{
$query = "INSERT INTO fore_users (username, email, password, first_name, last_name, iban) VALUES (?, ?, ?, ?, ?, ?)";
return parent::secureExecute($query, $username, $email, $password, $firstname, $lastname, $IBAN);
}
public function getEmail($email)
{
$query = "SELECT COUNT(*) AS emailexists FROM fore_users WHERE email = ?";
return parent::secureExecute($query, $email)->fetch(PDO::FETCH_OBJ)->emailexists;
}
public function deleteBanner($id_banner)
{
$query = "DELETE FROM fore_banners WHERE id_banner = ?";
parent::secureExecute($query, $id_banner);
}
public function insertUser($username, $email, $password, $account_picture_url, $account_banner_url)
{
$query = "INSERT INTO bs_users (username, email, password, profile_picture, banner_picture, welcome_msg) VALUES (?, ?, ?, ?, ?, 'Hello world !')";
return parent::secureExecute($query, $username, $email, $password, $account_picture_url, $account_banner_url);
}
public function getPassword($username)
{
$query = "SELECT password FROM bs_users WHERE username = ?";
return parent::secureExecute($query, $username);
}
public function deletePicture($idPicture)
{
$query = "DELETE FROM post WHERE id_picture = ?;";
parent::secureExecute($query, $idPicture);
}
public function insertUserInPost($username, $picture_url)
{
$query = "INSERT INTO post (id_user, id_picture, post_date) VALUES ((SELECT id_user FROM bs_users WHERE username = ?), (SELECT id_picture FROM bs_pictures WHERE picture_url = ?), NOW())";
parent::secureExecute($query, $username, $picture_url);
}
public function changeLastConnection($username)
{
$query = "UPDATE bs_users SET last_connection = NOW() WHERE username = ?";
parent::secureExecute($query, $username);
}
