Hi I would like to point out before I get into this that I am a PHP newb, and I have been struggling for a while. I'm trying this new script, but I got an error every time I did upload file.
Warning: file_get_conten ts(): Filename cannot be empty in C:\Users\user\D esktop\xampp\ht docs\ubfm\d2.ph p on line 18
Warning: file_get_conten ts(): Filename cannot be empty in C:\Users\user\D esktop\xampp\ht docs\ubfm\d2.ph p on line 18
Code:
<?php // Check if a file has been uploaded if(isset($_FILES['uploaded_file'])) { // Make sure the file was sent without errors { // Connect to the database $dbLink = new mysqli('localhost', 'root', '', 'upload'); if(mysqli_connect_error()) { die("MySQL connection failed: ". mysqli_connect_error()); } // Gather all required data $name = &$_POST['name']; $email = &$_POST['email']; $subject = &$_POST['subject']; $department = &$_POST['department']; $message = &$_POST['message']; $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 `file`(Name,email,subject,department,message,mime,size,data,created) VALUES('$name','$email','$subject','$department','$message','$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 'Error! A file was not sent!'; } // Echo a link back to the main page echo '<p>Click <a href="d1.php">here</a> to go back</p>'; ?>
Comment