Guest User

Untitled

a guest
Aug 30th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. $table = "users";
  2. $data = array("name" => $_POST["editName"],
  3. "lastname" => $_POST["editLastname"],
  4. "username" => $_POST["editUsername"],
  5. "password" => $encrypt,
  6. "role" => $_POST["editRole"],
  7. "photo" => $path);
  8.  
  9. $response = UsersModel::MdlEditUser($table, $data);
  10.  
  11. static public function MdlEditUser($table, $data){
  12.  
  13. $stmt = Connection::connect()->prepare("UPDATE $table SET name = :name, lastname = :lastname, password = :password, role = :role, photo = :photo,
  14. WHERE username = :username");
  15.  
  16. $stmt -> bindParam(":name", $data["name"], PDO::PARAM_STR);
  17. $stmt -> bindParam(":lastname", $data["lastname"], PDO::PARAM_STR);
  18. $stmt -> bindParam(":password", $data["password"], PDO::PARAM_STR);
  19. $stmt -> bindParam(":role", $data["role"], PDO::PARAM_STR);
  20. $stmt -> bindParam(":photo", $data["photo"], PDO::PARAM_STR);
  21. $stmt -> bindParam(":username", $data["username"], PDO::PARAM_STR);
  22.  
  23. var_dump($stmt);
  24.  
  25. object(PDOStatement)#5 (1) { ["queryString"]=> string(181) "UPDATE users SET name = :name, lastname = :lastname, password = :password, role = :role, photo = :photo, WHERE username = :username" }
Add Comment
Please, Sign In to add comment