Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. <?php
  2. session_start();
  3. include_once 'connection.php';
  4. $id = $_SESSION['user_id'];
  5. if(isset($_POST['emailChange']) || isset($_POST['descChange'])){
  6. $desc = $_POST['descChange'];
  7. $email = $_POST['emailChange'];
  8. if(empty($email)){
  9. $query = "UPDATE users SET description = :descr WHERE user_id= :id ;";
  10. $stmt = $conn->prepare($query);
  11. $stmt->bindParam(":descr", $desc);
  12. } else if(empty($desc)){
  13. $query = "UPDATE users SET user_email= :email WHERE user_id= :id ;";
  14. $stmt = $conn->prepare($query);
  15. $stmt->bindParam(":email", $email);
  16. } else{
  17. $query = "UPDATE users SET description = :descr AND user_email = :email WHERE user_id= :id;";
  18. $stmt = $conn->prepare($query);
  19. $stmt->bindParam(":email", $email);
  20. $stmt->bindParam(":descr", $desc);
  21. }
  22. if(!filter_var($email, FILTER_VALIDATE_EMAIL)){
  23. header("Location: ../profile.php?error=invalidEmail");
  24. exit();
  25. }
  26. $stmt->bindParam(":id", $id);
  27. $stmt->execute();
  28. }
  29.  
  30. <form action="assets/upload.php" method="POST">
  31. <input type="text" name="emailChange" class="inputs" id="changeEmail" placeholder = "Enter your new E-mail">
  32. <input type="text" name="descChange" class="inputs" id="changeDesc" placeholder="Enter your description">
  33. <button type="submit" id="btnconfirmCreds" name="changeCreds">Confirm Changes</button>
  34. </form>
  35.  
  36. [user_id][user_username][user_email][user_password][role_id][user_image][description][num_of_posts]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement