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, 2237🔥, 1💬
Popular Posts:
How to use "json-to-xml" Azure API Policy Statement? The "json-to-xml" Policy Statement allows you t...
What Happens If One Row Has Missing Columns? What happens if one row has missing columns? Most brows...
Where Is the Submitted Form Data Stored in PHP? When a user submit a form on your Web server, user e...
How to Install Docker Desktop 2.5.0 on Windows 10? You can follow this tutorial to Install Docker De...
How To Create an Array with a Sequence of Integers or Characters in PHP? The quickest way to create ...