Guest User

Untitled

a guest
Dec 18th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. <?php
  2. $db_server = "localhost";
  3. $db_username = "root";
  4. $db_password = "";
  5. $db_database = "meubelfabriek";
  6. $conn = new PDO("mysql:host=$db_server;dbname=$db_database", $db_username, $db_password);
  7. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  8. if(isset($_POST['submit']))
  9. {
  10. $prijs = $_POST['prijs'];
  11. $naam = $_POST['fname'];
  12. $beschrijving = $_POST['desc'];
  13. $maat1 = $_POST['maat1'];
  14. $maat2 = $_POST['maat2'];
  15. $maat3 = $_POST['maat3'];
  16. $maat4 = $_POST['maat4'];
  17. $imageName = $_FILES["image"]["name"];
  18. $imageData = file_get_contents($_FILES["image"]["tmp_name"]);
  19. $imageType = $_FILES["image"]["type"];
  20. if(substr($imageType,0,5)=="image")
  21. {
  22. $stmt = $conn->prepare("INSERT INTO producten ( naam, beschrijving, prijs, maat1, maat2, maat3, maat4, namen, image ) VALUES ( :naam, :beschrijving, :prijs, :maat1, :maat2, :maat3, maat4,'$imageName', " . $conn->quote($imageData) . ")");
  23. $stmt->execute(array(":naam"=>$naam, ":beschrijving"=>$beschrijving, ":prijs"=>$prijs, ":maat1"=>$maat1, ":maat2"=>$maat2, ":maat3"=>$maat3, ":maat4"=>$maat4));;
  24. }
  25. else
  26. {
  27. echo "Oops, something went wrong!"; }
  28. }
  29. ?>
  30. <?php
Add Comment
Please, Sign In to add comment