Example #1
0
 /**
  * Профиль пользователя
  * */
 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();
 }