/** * Профиль пользователя * */ public function editProfile($data) { $id = intval($data['id']); $query_pass = $this->db->query("SELECT `password` FROM `users` WHERE `id` = {$id}"); if ($data['password'] === "" || $data['password'] === 0) { $password = $query_pass->fetch()->password; } else { $password = validate::hashInit($data['password']); } $query = $this->db->prepare("UPDATE `users` SET `email` = :email, `password` = :password, `name` = :name, `age` = :age, \r\n\t\t \t `country` = :country WHERE `id` = :id"); $query->bindParam(":email", $data['email'], PDO::PARAM_STR); $query->bindParam(":password", $password, PDO::PARAM_STR); $query->bindParam(":name", $data['name'], PDO::PARAM_STR); $query->bindParam(":age", $data['age'], PDO::PARAM_INT); $query->bindParam(":country", $data['country'], PDO::PARAM_STR); $query->bindParam(":id", $data['id'], PDO::PARAM_INT); return $query->execute(); }