Advertisement
Guest User

Untitled

a guest
Apr 6th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. in your maintenance.php
  2. <form action="ArtworkAddForm.php" method="get">
  3. <br><br>
  4. <h1>Artwork </h1>
  5. <b><i>Add</i></b><br>
  6. Name: <input type="text" name="name"><br>
  7. Date: <input type="text" name="date"> <br>
  8. Dimensions: <input type="text" name="dimensions"><br>
  9. Genre: <input type="text" name="genre"><br>
  10. Location: <input type="text" name="location"><br>
  11. Colours: <input type="text" name="colours"><br>
  12. Price: <input type="text" name="price"><br>
  13. <br>
  14. <input type="submit" value="Add Artwork" style="font-family: 'Abel', sans-serif; font-size:20px;padding:2px; border:3px black">
  15. </form><br>
  16.  
  17. ArtworkAddForm.php
  18.  
  19. <?php
  20. $servername = "localhost";
  21. $username = "root";
  22. $password = "secret";
  23. $dbname = "630a2i2";
  24.  
  25. // Create connection
  26. $conn = new mysqli($servername, $username, $password, $dbname);
  27. if ($conn->connect_error) {
  28. die("Connection failed: " . $conn->connect_error);
  29. }
  30.  
  31. $name = $_GET['name'];
  32. $date = $_GET['dateOfBirthDeath'];
  33. $placesLived = $_GET['placesLived'];
  34. $genre = $_GET['genre'];
  35. $famousWorks = $_GET['famousWorks'];
  36.  
  37. $sql = "INSERT INTO artistTable (artistName, dateOfBirthDeath, placesLived, genre, famousWorks)
  38. VALUES ('$name', '$date', '$placesLived', '$genre', '$famousWorks')";
  39.  
  40.  
  41. if ($conn->query($sql) === TRUE) {
  42. echo "New record added successfully";
  43. } else {
  44. echo "Error: " . $sql . "<br>" . $conn->error;
  45. }
  46. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement