Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    File Upload To MySQL

    Uploaded by

    dipti dongarde

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    File Upload To MySQL

    Uploaded by

    dipti dongarde
    7 views4 pages

    Original Title

    File Upload to MySQL

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    7 views4 pages

    File Upload To MySQL

    Uploaded by

    dipti dongarde

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    File Upload, View and Download using PHP and

    MySQL

    upload and store the image file in MySQL database using PHP.
    The example code demonstrates the process to implement the file upload functionality
    in the web application and the following functionality will be implemented.
     HTML form to upload image.
     Upload image to server using PHP.
     Store file name in the database using PHP and MySQL.
     Retrieve images from the database and display in the web page.

    Create Datbase Table

    To store the image file name a table need to be created in the database. The following
    SQL creates an images table with some basic fields in the MySQL database.

    CREATE TABLE `images` (


    `id` int(11) NOT NULL AUTO_INCREMENT,
    `file_name` varchar(255) NOT NULL,
    `uploaded_on` datetime NOT NULL,
    `status` tinyint(1) NOT NULL DEFAULT 1,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

    Database Configuration (dbConfig.php)

    The dbConfig.php file is used to connect and select the MySQL database. Specify the
    database hostname ( $dbHost ), username ( $dbUsername ), password ( $dbPassword ),
    and name ( $dbName ) as per your MySQL credentials.

    <?php
    // Database configuration
    $dbHost = "localhost";
    $dbUsername = "root";
    $dbPassword = "root";
    $dbName = "codexworld_db";

    // Create database connection


    $db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

    // Check connection
    if ($db->connect_error) {
    die("Connection failed: " . $db->connect_error);
    }
    ?>

    Upload Form HTML

    Create an HTML form to allow the user to choose a file they want to upload. Make sure
    <form> tag contains the following attributes.
     method="post"
     enctype="multipart/form-data"

    Also, make sure <input> tag contains type="file" attribute.

    <form action="upload.php" method="post" enctype="multipart/form-data">


    Select Image File to Upload:
    <input type="file" name="file">
    <input type="submit" name="submit" value="Upload">
    </form>

    The file upload form will be submitted to the upload.php file to upload image to the
    server.

    Upload File to Server and Store in Database (upload.php)

    The upload.php file handles the image upload functionality and shows the status
    message to the user.
     Include the database configuration file to connect and select the MySQL database.
     Get the file extension using pathinfo() function in PHP and validate the file format to check
    whether the user selects an image file.
     Upload image to server using move_uploaded_file() function in PHP.
     Insert image file name in the MySQL database using PHP.
     Upload status will be shown to the user.
    <?php
    // Include the database configuration file
    include_once 'dbConfig.php';

    $statusMsg = '';

    // File upload directory


    $targetDir = "uploads/";

    if(isset($_POST["submit"])){
    if(!empty($_FILES["file"]["name"])){
    $fileName = basename($_FILES["file"]["name"]);
    $targetFilePath = $targetDir . $fileName;
    $fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);

    // Allow certain file formats


    $allowTypes = array('jpg','png','jpeg','gif');
    if(in_array($fileType, $allowTypes)){
    // Upload file to server
    if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){
    // Insert image file name into database
    $insert = $db->query("INSERT INTO images (file_name, uploaded_on) VALUES ('".
    $fileName."', NOW())");
    if($insert){
    $statusMsg = "The file ".$fileName. " has been uploaded successfully.";
    }else{
    $statusMsg = "File upload failed, please try again.";
    }
    }else{
    $statusMsg = "Sorry, there was an error uploading your file.";
    }
    }else{
    $statusMsg = 'Sorry, only JPG, JPEG, PNG, & GIF files are allowed to upload.';
    }
    }else{
    $statusMsg = 'Please select a file to upload.';
    }
    }

    // Display status message


    echo $statusMsg;
    ?>
    Display Images from Database

    Now we will retrieve the uploaded images from the server based on the file names in
    the database and display images in the web page.
     Include the database configuration file.
     Fetch images from MySQL database using PHP.
     List images from the uploads directory of the server.
    <?php
    // Include the database configuration file
    include 'dbConfig.php';

    // Get images from the database


    $query = $db->query("SELECT * FROM images ORDER BY uploaded_on DESC");

    if($query->num_rows > 0){


    while($row = $query->fetch_assoc()){
    $imageURL = 'uploads/'.$row["file_name"];
    ?>
    <img src="<?php echo $imageURL; ?>" alt="" />
    <?php }
    }else{ ?>
    <p>No image(s) found...</p>
    <?php } ?>

    You might also like