upload picture to and send path to database

Posted by opa.mido on Stack Overflow See other posts from Stack Overflow or by opa.mido
Published on 2014-05-27T21:12:00Z Indexed on 2014/05/27 21:27 UTC
Read the original article Hit count: 297

Filed under:
|
|

I am trying to upload picture and link it to my database and I used the codes below :

Upload2.php

        <?php
    // Check if a file has been uploaded
    if(isset($_FILES['uploaded_file'])) {
        // Make sure the file was sent without errors
        if($_FILES['uploaded_file']['error'] == 0) {
            // Connect to the database
            $dbLink = new mysqli('localhost', 'root', '1234', 'fyp');
            if(mysqli_connect_errno()) {
                die("MySQL connection failed: ". mysqli_connect_error());
            }

            // Gather all required data
            $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
            $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
            $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
            $size = intval($_FILES['uploaded_file']['size']);

            // Create the SQL query
            $query = "
                INSERT INTO `pic` (
                    `Name`,  `size`, `data`, `created`
                )
                VALUES (
                    '{$name}', '{$mime}', {$size}, '{$data}', NOW()
                )";

            // Execute the query
            $result = $dbLink->query($query);

            // Check if it was successfull
            if($result) {
                echo 'Success! Your file was successfully added!';
            }
            else {
                echo 'Error! Failed to insert the file'
                   . "<pre>{$dbLink->error}</pre>";
            }
        }
        else {
            echo 'An error accured while the file was being uploaded. '
               . 'Error code: '. intval($_FILES['uploaded_file']['error']);
        }

        // Close the mysql connection
        $dbLink->close();
    }
    else {
        echo 'Error! A file was not sent!';
    }

        // Echo a link back to the main page
        echo '<p>Click <a href="index.html">here</a> to go back</p>';


 ?>

I reached the last stage and its give error a file was not sent

I don't know where I have missed.

thank you

© Stack Overflow or respective owner

Related posts about php

Related posts about file-upload