Advertisement
markleyco23

Untitled

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