Advertisement
Guest User

server

a guest
Nov 18th, 2018
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <?php
  2. session_start();
  3.  
  4. //initialize variables
  5. $name = "";
  6. $address = "";
  7. $id = 0;
  8. $update = false;
  9.  
  10. // Connect to database
  11.  
  12. $db = mysqli_connect('localhost', 'root', '','crud');
  13.  
  14. // if save button is clicked
  15. if (isset($_POST['save'])) {
  16. $name = $_POST['NAME'];
  17. $address = $_POST['ADDRESS'];
  18.  
  19. mysqli_query($db, "INSERT INTO info (name, address) VALUES ('$name', 'address')");
  20. $_SESSION['message'] = "Address saved";
  21. header('location: index.php');
  22. }
  23. // update records
  24. if (isset($_POST['update'])) {
  25. $id = $_POST['id'];
  26. $name = $_POST['name'];
  27. $address = $_POST['address'];
  28.  
  29. mysqli_query($db, "UPDATE info SET name='$name', address='$address' WHERE id=$id");
  30. $_SESSION['message'] = "Address updated!";
  31. header('location: index.php');
  32. }
  33. // delete records
  34. if (isset($_GET['del'])) {
  35. $id = $_GET['del'];
  36. mysqli_query($db, "DELETE FROM info WHERE id=$id");
  37. $_SESSION['message'] = "Address deleted!";
  38. header('location: index.php');
  39. }
  40. // retrieve records
  41. $results = mysqli_query($db, "SELECT * FROM info");
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement