Sunamena Posted May 26, 2017 Share Posted May 26, 2017 Hello everyone, I have an issue with uploading an image, but i can not seem to figure out what might be the problem. I am new to adding images. I would like to thank you all in advance for your asistance =D This is the PHP code: <?php require('bestanddatconnecteertmetdatabaseenzo.php'); // Foto toevoegen if (!isset($_POST["uploaden"])) { header('Location: ../fout.php'); } else { $error = ""; if (!isset($_POST["titel"])) { $error = "Er is geen ingevulde titel."; } if (!isset($_POST["omschrijving"])) { $error = "Er is geen ingevulde omschrijving."; } if (!isset($_POST["plaats"])) { $error = "Er is geen ingevulde plaats."; } if (!empty($error)) { header('Location: ../fout.php'); } else { try { $bestandNaam = htmlentities(preg_replace('/[^A-Za-z0-9\-]/', '', $_POST["titel"])); // Kijk of deze titel nog niet bestaat $sql = "SELECT count(fotoID) FROM fotos WHERE titel = :checktitel"; $stmt = $db -> prepare($sql); $stmt -> bindParam(':checktitel', $checktitel, PDO::PARAM_STR); $checktitel = $bestandNaam; $stmt -> execute(); $row = $stmt -> fetch(PDO::FETCH_NUM); if ($row[0] > 0){ // deze titel is al in gebruik echo "Deze titel bestaat al. Kies een andere."; } else { // AFBEELDING UPLOADEN $target_dir = "../../images/galerij/"; $target_file = $target_dir . $bestandNaam . ".jpg"; $check_target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]); $uploadOk = 1; $imageFileType = pathinfo($check_target_file,PATHINFO_EXTENSION); echo "<br><br>" . $target_dir . "<br><br>" . $target_file . "<br><br>" . $imageFileType; // Check if image file is a actual image or fake image $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]); if($check !== false) { echo "Bestand is een afbeelding - " . $check["mime"] . "."; $uploadOk = 1; } else { echo "Dit bestand is geen afbeelding."; $uploadOk = 0; } // Controleer de bestand grootte maximaal 150 kilobyte if ($_FILES["fileToUpload"]["size"] > 320000) { echo "Sorry, je bestand is te groot. Het bestand mag maximaal 300 kilobyte zijn."; $uploadOk = 0; } // Aanvaard enkel .jpg bestanden if($imageFileType != "jpg") { echo "Sorry, we aanvaarden enkel .jpg afbeeldingen." . $imageFileType; $uploadOk = 0; } // Controleer of er kan worden geüpload if ($uploadOk == 0) { echo "Sorry, je bestand werd niet geüpload."; } // Als alles in orde is, sla dan het bestand op. else { if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) { echo "Het bestand ". basename( $_FILES["fileToUpload"]["name"]). " is geupload."; } else { echo "Sorry, er is een onvoorziene fout gebeurd."; } } if ($uploadOk == 1) { $sql = "INSERT INTO fotos (titel, omschrijving, plaats, landart, creaties, datum) VALUES (:titel, :omschrijving, :plaats, :landart, :creaties, :datum)"; $stmt = $db -> prepare($sql); $stmt -> bindParam(':titel', $titel, PDO::PARAM_STR); $stmt -> bindParam(':omschrijving', $omschrijving, PDO::PARAM_STR); $stmt -> bindParam(':plaats', $plaats, PDO::PARAM_STR); $stmt -> bindParam(':landart', $landart, PDO::PARAM_INT); $stmt -> bindParam(':creaties', $creaties, PDO::PARAM_INT); $stmt -> bindParam(':datum', $datum, PDO::PARAM_INT); $titel = $bestandNaam; $omschrijving = htmlentities($_POST["omschrijving"]); $plaats = htmlentities($_POST["plaats"]); // Landart en/of creaties $landart = 0; $creaties = 0; if ($_POST["category"] == 1) { $landart = 1; } if ($_POST["category"] == 2) { $creaties = 1; } if ($_POST["category"] == 0) { $landart = 1; $creaties = 1; } $datum = date("omd"); if ($_POST["setdatum"] == 1) { $datum = $_POST["datumJaar"] . $_POST["datumMaand"] . $_POST["datumDag"]; } $stmt -> execute(); echo "Foto toegevoegd."; }}} catch(PDOException $e) { $e -> getLine() . '<br>'; echo 'Bestand: ' . $e -> getFile() . '<br>'; echo 'Foutmelding: ' . $e -> getMessage(); echo "<br><br><br>Er is een fout opgetreden."; } } } ?> And this is the form <form method="post" action="php/fototoevoegen.php"> <div class="formwrapper"> <div class="formleft"> Afbeelding (enkel .jpg) </div> <div class="formright"> <input type="file" name="fileToUpload" id="fileToUpload" required> </div> </div> <div class="formwrapper"> <div class="formleft"> Titel </div> <div class="formright"> <input type="text" name="titel" required max-length="20" placeholder="Titel van de foto"> </div> </div> <div class="formwrapper"> <div class="formleft"> Omschrijving </div> <div class="formright"> <input type="text" name="omschrijving" required max-length="100" placeholder="Omscrhijf hier de foto."> </div> </div> <div class="formwrapper"> <div class="formleft"> Plaats </div> <div class="formright"> <input type="text" name="plaats" required max-length="20" placeholder="Waar is de foto gemaakt?"> </div> </div> <div class="formwrapper"> <div class="formleft"> Category </div> <div class="formright"> <input class="radio" type="radio" name="category" value="0" checked> Landart en Creaties<br> <input class="radio" type="radio" name="category" value="1"> Landart<br> <input class="radio" type="radio" name="category" value="2"> Creaties<br> </div> </div> <div class="formwrapper"> <div class="formleft"> Datum </div> <div class="formright"> <input class="radio" type="radio" name="setdatum" value="0" checked> Vandaag als datum gebruiken<br> <input class="radio" type="radio" name="setdatum" value="1"> Onderstaande datum gebruiken<br> </div> </div> <div class="rowwrapper"><!-- --><div class="row33"> Jaar </div><!-- --><div class="row33"> Maand </div><!-- --><div class="row33"> Dag </div><!-- --></div> <div class="rowwrapper"><!-- --><div class="row33"> <select name="datumJaar"> <?php $ditJaar = date("Y"); for ($i = 2010; $i != $ditJaar; $i++) { ?> <option value="<?php echo $i; ?>"><?php echo $i;?></option> <?php } ?> </select> </div><!-- --><div class="row33"> <select name="datumMaand"> <option value="01">Januari</option> <option value="02">Februari</option> <option value="03">Maart</option> <option value="04">April</option> <option value="05">Mei</option> <option value="06">Juni</option> <option value="07">Juli</option> <option value="08">Augustus</option> <option value="09">September</option> <option value="10">Oktober</option> <option value="11">November</option> <option value="12">December</option> </select> </div><!-- --><div class="row33"> <select name="datumDag"> <option value="01">01</option> <option value="02">02</option> <option value="03">03</option> <option value="04">04</option> <option value="05">05</option> <option value="06">06</option> <option value="07">07</option> <option value="08">08</option> <option value="09">09</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> </div><!-- --></div> <input type="submit" name="uploaden" value="Plaatsen"> </form> Link to comment Share on other sites More sharing options...
dsonesuk Posted May 26, 2017 Share Posted May 26, 2017 https://www.w3schools.com/php/php_file_upload.asp 1 Link to comment Share on other sites More sharing options...
Sunamena Posted May 27, 2017 Author Share Posted May 27, 2017 Thanks. This problem has been solved =D Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now