Advertisement
Guest User

Untitled

a guest
May 23rd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. <?php
  2.  
  3. $dbHost = "localhost";
  4. $dbUser = "root";
  5. $dbPass = "root";
  6. $dbName = "test23052017";
  7. $dbConnection = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
  8.  
  9. if(mysqli_connect_errno()){
  10. die("Database connection error ".mysqli_connect_error()." => ".mysqli_connect_errno());
  11. }
  12.  
  13. $query = "UPDATE users
  14. SET lastname = 'Zovko', zip_code = 71000
  15. WHERE name = 'Ivo'";
  16. $result = mysqli_query($dbConnection, $query);
  17.  
  18. if($result && mysqli_affected_rows($dbConnection) == 1){
  19. echo "Success";
  20. } else {
  21. die("Query failed ".mysqli_error($dbConnection));
  22. }
  23.  
  24. mysqli_close($dbConnection);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement