Created
November 12, 2017 18:34
-
-
Save saiprasad1996/67d92875b5e8c9b4bac3d1dbffe3bb3c to your computer and use it in GitHub Desktop.
PHP code for uploading file and description and inserting records into database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $target_dir = "uploads/"; | |
| $target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]); | |
| $text = $_POST["description"]; | |
| $uploadOk = 1; | |
| $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION); | |
| // Check if image file is a actual image or fake image | |
| if(isset($_POST["submit"])) { | |
| $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]); | |
| if($check !== false) { | |
| echo "File is an image - " . $check["mime"] . "."; | |
| $uploadOk = 1; | |
| } else { | |
| echo "File is not an image."; | |
| $uploadOk = 0; | |
| } | |
| } | |
| // Check if file already exists | |
| if (file_exists($target_file)) { | |
| echo "Sorry, file already exists."; | |
| $uploadOk = 0; | |
| } | |
| // Check file size | |
| if ($_FILES["fileToUpload"]["size"] > 500000) { | |
| echo "Sorry, your file is too large."; | |
| $uploadOk = 0; | |
| } | |
| // Allow certain file formats | |
| if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" | |
| && $imageFileType != "gif" ) { | |
| echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed."; | |
| $uploadOk = 0; | |
| } | |
| // Check if $uploadOk is set to 0 by an error | |
| if ($uploadOk == 0) { | |
| echo "Sorry, your file was not uploaded."; | |
| // if everything is ok, try to upload file | |
| } else { | |
| if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) { | |
| echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded."; | |
| //Your mysql insert logic here for uploading data to the table from the text box | |
| $sql = "INSERT INTO $tablename(`name`,`photo`,`description`) VALUES('name','$target_file','$text')"; | |
| $servername = "localhost"; | |
| $username = "username"; | |
| $password = "password"; | |
| // Create connection | |
| $conn = mysqli_connect($servername, $username, $password); | |
| if (!$conn) { | |
| die("Connection failed: " . mysqli_connect_error()); | |
| } | |
| if (mysqli_query($conn, $sql)) { | |
| echo "New record inserted successfully"; | |
| } else { | |
| echo "Error: " . $sql . "<br>" . mysqli_error($conn); | |
| } | |
| mysqli_close($conn); | |
| } else { | |
| echo "Sorry, there was an error uploading your file."; | |
| } | |
| } | |
| ?> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>File upload example</title> | |
| </head> | |
| <body> | |
| <form action="fileupload.php" method="post" enctype="multipart/form-data"> | |
| Select image to upload: | |
| <textarea name="description">Description</textarea> | |
| <input type="file" name="fileToUpload" id="fileToUpload"> | |
| <input type="submit" value="Upload Picture" name="submit"> | |
| </form> | |
| </body> | |
| </html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment