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, 2031👍, 1💬
Popular Posts:
How to use the "send-one-way-request" Policy statement to call an extra web service for an Azure API...
How to extend json.JSONEncoder class? I want to encode other Python data types to JSON. If you encod...
How to install .NET Framework in Visual Studio Community 2017? I have the Visual Studio Installer in...
How To Pad an Array with the Same Value Multiple Times in PHP? If you want to add the same value mul...
How to Test API as a Publisher Administrator? You can follow this tutorial to test an API operation ...