Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $table = "users";
- $data = array("name" => $_POST["editName"],
- "lastname" => $_POST["editLastname"],
- "username" => $_POST["editUsername"],
- "password" => $encrypt,
- "role" => $_POST["editRole"],
- "photo" => $path);
- $response = UsersModel::MdlEditUser($table, $data);
- static public function MdlEditUser($table, $data){
- $stmt = Connection::connect()->prepare("UPDATE $table SET name = :name, lastname = :lastname, password = :password, role = :role, photo = :photo,
- WHERE username = :username");
- $stmt -> bindParam(":name", $data["name"], PDO::PARAM_STR);
- $stmt -> bindParam(":lastname", $data["lastname"], PDO::PARAM_STR);
- $stmt -> bindParam(":password", $data["password"], PDO::PARAM_STR);
- $stmt -> bindParam(":role", $data["role"], PDO::PARAM_STR);
- $stmt -> bindParam(":photo", $data["photo"], PDO::PARAM_STR);
- $stmt -> bindParam(":username", $data["username"], PDO::PARAM_STR);
- var_dump($stmt);
- 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