Last active
August 21, 2018 08:41
-
-
Save Mauryashubham/d5faade90a6d75fba726fdadb0531ab2 to your computer and use it in GitHub Desktop.
How to upload Image in Database using PHP [With Folder]
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
| Hi all , Welcome to Maurya Tricks , Today we are going to discuss ,How to upload Image in Database using PHP [With Folder] | |
| //Database Creation | |
| Make a database named “testdb and table named “image” . | |
| Give the element name 'b_image' (varchar(255)) in tables 'test'. | |
| //Make a folder named "image" in your directory | |
| 1.Make a file in notepad and save it as index.php and paste the below code. | |
| <?php | |
| /** | |
| @author : Shubham Maurya, | |
| Email id : [email protected] | |
| **/ | |
| //connect to mysql database | |
| $con = mysqli_connect("localhost", "root", "", "testdb") or die("Error " . mysqli_error($con)); | |
| //Upload Image | |
| if(isset($_POST['cover_up'])) | |
| { | |
| $imgFile = $_FILES['coverimg']['name']; | |
| $tmp_dir = $_FILES['coverimg']['tmp_name']; | |
| $imgSize = $_FILES['coverimg']['size']; | |
| if(!empty($imgFile)) | |
| { | |
| $upload_dir = 'image/'; // upload directory | |
| $imgExt = strtolower(pathinfo($imgFile,PATHINFO_EXTENSION)); // get image extension | |
| // valid image extensions | |
| $valid_extensions = array('jpeg', 'jpg', 'png', 'gif'); // valid extensions | |
| // rename uploading image | |
| $coverpic = rand(1000,1000000).".".$imgExt; | |
| // allow valid image file formats | |
| if(in_array($imgExt, $valid_extensions)){ | |
| // Check file size '5MB' | |
| if($imgSize < 5000000) { | |
| move_uploaded_file($tmp_dir,$upload_dir.$coverpic); | |
| } | |
| else{ | |
| $errMSG = "Sorry, your file is too large."; | |
| } | |
| } | |
| else{ | |
| $errMSG = "Sorry, only JPG, JPEG, PNG & GIF files are allowed."; | |
| } | |
| //For Database Insertion | |
| // if no error occured, continue .... | |
| if(!isset($errMSG)) | |
| { | |
| $que = "INSERT INTO image(b_image) VALUES('" . $userpic . "')"; | |
| if(mysqli_query($con, $que)) | |
| { | |
| echo "<script type='text/javascript'>alert('Posted succesfully.');</script>"; | |
| } | |
| else | |
| { | |
| echo "<script type='text/javascript'>alert('error while inserting....');</script>"; | |
| } | |
| } | |
| } | |
| } | |
| ?> | |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title></title> | |
| </head> | |
| <body> | |
| <form method="post" enctype="multipart/form-data"> | |
| <p><input type="file" name="coverimg" required="required" /></p> | |
| <p><input type="submit" name="cover_up" style="background-color: rgb(255, 102, 0);" class="btn btn-warning" value="Upload"/></p> | |
| </form> | |
| </body> | |
| </html> | |
| Now, Try this code…and Try to make your own new functions.Happy Coding.. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Lovely and Simple Code :) thanks a lot. Just a small correction line 59
$que = "INSERT INTO image(b_image) VALUES('" . $userpic . "')";
$userpic should be replaced by $coverpic .
Thanks again ,