pdf file not uploaded in phpmyadmin?

manpreet Best Answer 3 years ago

hello everyone this is my piece of code to upload the pdf file,file is not being uploaded to path i have given plz help me out in database its shows the entry but in the path where pdf file should be there it does not exist...

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', '', 'college');
            if(mysqli_connect_errno()) {
                die("MySQL connection failed: ". mysqli_connect_error());
            }

            // Gather all required data
            $id1 = $dbLink->real_escape_string($_FILES['uploaded_file']['down_id']);
            $id2 = $dbLink->real_escape_string($_FILES['uploaded_file']['course_id']);
            $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
            move_uploaded_file($data,"/upload/syllabus/");
            $mypath="upload/syllabus/";
            $type = intval($_FILES['uploaded_file']['down_type']);

            // Create the SQL query
            $query = "
                INSERT INTO `download_master` (
                    `down_id`, `course_id`, `down_title`, `path`
                )
                VALUES (
                    '{$id1}', '{$id2}', {$type}, '{$mypath}'
                )";

            // 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'
                   . "
{$dbLink->error}
";
            }
        }
        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 '
Click here to go back
';
    ?>