Advertisement
Guest User

codigo update

a guest
Mar 20th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. <?php
  2. // Lampirkan db dan User
  3. require_once "db.php";
  4. require_once "User.php";
  5.  
  6. // Buat object user
  7. $user = new User($db);
  8.  
  9. // Jika belum login
  10. if(!$user->isLoggedIn()){
  11. header("location: login.php"); //Redirect ke halaman login
  12. }
  13.  
  14. // Ambil data user saat ini
  15. $currentUser = $user->getUser();
  16.  
  17. ?>
  18.  
  19. <?php
  20. if(isset($_POST['update']))
  21. {
  22. // resgata os valores do formulário
  23. $nama = isset($_POST['nama']) ? $_POST['nama'] : null;
  24. $email = isset($_POST['email']) ? $_POST['email'] : null;
  25. $password = isset($_POST['password']) ? $_POST['password'] : null;
  26. $thumbnail_login = isset($_POST['thumbnail_login']) ? $_POST['thumbnail_login'] : null;
  27. $id = isset($_POST['id']) ? $_POST['id'] : null;
  28.  
  29. // validação (bem simples, mais uma vez)
  30. if (empty($nama))
  31. {
  32. echo "Volte e preencha todos os campos";
  33. exit;
  34. }
  35.  
  36. // atualiza o banco
  37. $db = db_connect();
  38. $query = "UPDATE tblogin SET nama=:nama, email=:email, password=:password, thumbnail_login=:thumbnail_login WHERE id = :id'";
  39. $db = $db->prepare($query);
  40. $query->bindParam(':nama', $nama);
  41. $query->bindParam(':email', $email);
  42. $query->bindParam(':password', $password);
  43. $query->bindParam(':thumbnail_login', $thumbnail_login);
  44. $query->bindParam(':id', $id);
  45.  
  46. if ($query->execute())
  47. {
  48. header('Location: index.php');
  49. }
  50. else
  51. {
  52. echo "Erro ao alterar";
  53. print_r($query->errorInfo());
  54. }
  55. }
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement