Frontend and backend web development | php-wordpress web programmer

Tutorials Details

How to insert PHP MySql Upload Image / file ?

Publish by Sifur Rahaman March 19, 2021, 3:02 pm

Description:

Many more methods are available for uploads file or image. But I talk to you best method for uploading an image or file. This method is not simple. It is a dynamic method. This method includes complete validation. Like – Define file extension (jpeg, png, zip, rar, etc.), Define File size (1MB = 1024KB), Define empty or not, etc.
At first, go to https://localhost/phpmyadmin. Now create a database (bd_sifurrahaman). Inside this database, create a table (tbl_php). Inside this table, create three columns (id, caption, image). Now save this table and create a database, connection and make a connection to a MySQL database. Now write the below code

Note: Here we use the Bootstrap class to create a form. So if you want to design your form with Bootstrap, then you must add Bootstrap CSS and JS CDN

Source Code:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Image Upload</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.7/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container mt-5">
    <div class="row">
        <div class="col-md-6 mx-auto">
            <form action="" method="POST" enctype="multipart/form-data">
               
<?php
    $host = "localhost";
    $username = "root";
    $password = "";
    $dbname = "db_sifurrahaman";

// Create connection
    $con = new mysqli($host, $username, $password, $dbname);
     // Check connection
    if ($con->connect_error) {
        die("Connection failed: " . $con->connect_error);
}
 if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['submit'])){
        $caption = $_POST['caption'];
    
        $permited  = array('jpg', 'jpeg', 'png', 'gif');
        $file_name = $_FILES['image']['name'];
        $file_size = $_FILES['image']['size'];
        $file_temp = $_FILES['image']['tmp_name'];

$div = explode('.', $file_name);
        $file_ext = strtolower(end($div));
        $unique_image = substr(md5(time()), 0, 10).'.'.$file_ext;
        $uploaded_image = "uploads/".$unique_image;
        
        if($caption == "" || $uploaded_image == "" ){
           echo "<h5 class='alert alert-danger text-center'><strong>Error..!</strong> Field must not be empty..!</h5>";
           
        } else{
			if (!empty($file_name)){
		if ($file_size >5242835) {
     echo "<h5 class='alert alert-warning text-center'><strong>Error..!</strong> Image Size should be less then 5MB..!</h5>";
    } elseif (in_array($file_ext, $permited) === false) {
            
     echo "<h5 class='alert alert-warning text-center'><strong>Error..!</strong> You can upload only:-" .implode(', ', $permited)."</h5>";
        }else{
            move_uploaded_file($file_temp, $uploaded_image);
            
    $sql = "INSERT INTO tbl_php(caption, image) VALUES('$caption', '$uploaded_image')";
            
    $inserted_row = mysqli_query($con, $sql);

// or $inserted_rows = mysqli_query($con, $sql);

if ($inserted_row) {
     		 echo "<h5 class='alert alert-success text-center'><strong>Success..!</strong> Data Inserted Successfully.</h5>";
            
     	} else {
     	 echo "<h5 class='alert alert-warning text-center'><strong>Error..!</strong> Data Inserted Not Successfully.</h5>";
       }
     }
    }
  }
}
?>

<div class="form-group">
                    <label for="caption">Caption</label>
                    <input type="text" class="form-control" placeholder="Enter Caption" name="caption">
                </div>
                 <div class="form-group">
                    <label for="image">Image</label>
                    <input type="file" class="form-control" name="image">
                </div>
                 <div class="form-group">
                    <label for="image"></label>
                    <input type="submit" class="form-control btn btn-info" name="submit" value="Submit">
                </div>

</form>
        </div>
    </div>
</div>

<?php $con->close(); ?>

Sifur Rahaman

Tutorials Details

How to insert PHP MySql Upload Image / file ?

Description:

Source Code:

Free PHP Tutorials: How to develop Frontend and Backend website development in PHP for beginning to advance lebel?

1. What is PHP and Why You Should Learn PHP or learn Frontend and backend web development?

2. How to Install PHP Version 7 or Local Server like - Wamp / Xampp with example?

3. How to Display or run first PHP Code?

4. How to Learn PHP Variables with example?

5. How to Sum any PHP field like column or cell?

6. How to Use PHP echo and print statement?

7. How to Learn PHP Data Types (String Data Type)?

8. How to Learn PHP Data Types (Integer Data Type)?

9. How to Learn PHP Data Types (Float Data Type)?

10. How to Learn PHP Data Types (Boolean Data Type)?

11. How to Learn PHP Data Types (Array Data Type)?

12. How to Learn PHP Data Types (Object Data Type)?

13. How to Learn PHP Operators For Frontend and Backend Development?

14. How to check PHP conditions use If, Else and Elseif statements for a expert frontend and backend depeloper?

15. How to learn PHP Loop for a expert frontend and backend depeloper?

16. How to learn PHP Functions for a expert frontend and backend depeloper?

17. How to learn PHP Arrays for a expert frontend and backend depeloper?

18. How to learn PHP Supper global variable

19. How to learn PHP RegEx for a expert frontend and backend depeloper?

20. How to Learn PHP Forms Validation For Frontend and Backend Development?

21. How to learn PHP MysQl Database for a expert frontend and backend depeloper?

22. How to learn PHP Database Connection for a expert frontend and backend depeloper?

23. How to Create PHP Database Class Database Class for Database Connection into MysQl DB?

24. How to Create a config.php file for MySql Database?

25. How to Create Dynamic PHP Session Class for a Secure frontend and backend depeloper?

26. How to Learn PHP MySql Select Query For Frontend and Backend Development?

27. How to Learn PHP MySql Insert Query and store data into Database For Frontend and Backend Development?

28. How to Learn PHP MySql Update Query For Frontend and Backend Development?

29. How to Learn PHP MySql Delete Query For Frontend and Backend Development?

30. How to insert PHP MySql Upload Image / file ?

31. How to send Email in live server?

32. How to upload image with file validations like extension (jpg, jpeg, png, gif, webp) and file size

33. How to create "JOIN QUERY" for display multiple database tables data in a single place?

34. How to count PHP notifications and display in the backend?