Tools, FAQ, Tutorials:
Uploading Files into Database in PHP
How To Upload Files into Database in PHP?
✍: FYIcenter.com
To store uploaded files to MySQL database, you can use the normal SELECT statement as shown in the modified processing_uploaded_files.php listed below:
<?php $con = mysql_connect("localhost", "", ""); mysql_select_db("fyi"); $error = $_FILES['fyicenter_logo']['error']; $tmp_name = $_FILES['fyicenter_logo']['tmp_name']; $size = $_FILES['fyicenter_logo']['size']; $name = $_FILES['fyicenter_logo']['name']; $type = $_FILES['fyicenter_logo']['type']; print("<pre>\n"); if ($error == UPLOAD_ERR_OK && $size > 0) { $fp = fopen($tmp_name, 'r'); $content = fread($fp, $size); fclose($fp); $content = addslashes($content); $sql = "INSERT INTO fyi_files (name, type, size, content)" . " VALUES ('$name', '$type', $size, '$content')"; mysql_query($sql, $con); print("File stored.\n"); } else { print("Upload faield.\n"); } print("&/pre>\n"); mysql_close($con); ?>
Note that addslashes() is used to add backslashes to special characters that need to be protected in SQL statements.
⇒ Configuration Settings for File Upload in PHP
⇐ Creating a Database Table to Store Files in PHP
2017-02-20, 2324🔥, 1💬
Popular Posts:
How To Read a File in Binary Mode in PHP? If you have a file that stores binary data, like an execut...
Where to find tutorials on Python programming language? I want to learn Python. Here is a large coll...
How to build a test service operation to dump everything from the "context.Request" object in the re...
What is Azure API Management Developer Portal Admin? The Developer Portal Admin is an Azure Web port...
How to read Atom validation errors at w3.org? If your Atom feed has errors, the Atom validator at w3...