Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_server = "localhost";
- $db_username = "root";
- $db_password = "";
- $db_database = "meubelfabriek";
- $conn = new PDO("mysql:host=$db_server;dbname=$db_database", $db_username, $db_password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- if(isset($_POST['submit']))
- {
- $prijs = $_POST['prijs'];
- $naam = $_POST['fname'];
- $beschrijving = $_POST['desc'];
- $maat1 = $_POST['maat1'];
- $maat2 = $_POST['maat2'];
- $maat3 = $_POST['maat3'];
- $maat4 = $_POST['maat4'];
- $imageName = $_FILES["image"]["name"];
- $imageData = file_get_contents($_FILES["image"]["tmp_name"]);
- $imageType = $_FILES["image"]["type"];
- if(substr($imageType,0,5)=="image")
- {
- $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) . ")");
- $stmt->execute(array(":naam"=>$naam, ":beschrijving"=>$beschrijving, ":prijs"=>$prijs, ":maat1"=>$maat1, ":maat2"=>$maat2, ":maat3"=>$maat3, ":maat4"=>$maat4));;
- }
- else
- {
- echo "Oops, something went wrong!"; }
- }
- ?>
- <?php
Add Comment
Please, Sign In to add comment