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, 2422🔥, 1💬
Popular Posts:
How to access Request body from "context.Request.Body" object in Azure API Policy? Request body is t...
How to use the "@(...)" expression in Azure API Policy? The "@(...)" expression in Azure API Policy ...
How to search for the first match of a regular expression using re.search()? The re.search() functio...
Where to find tutorials on RSS specifications? I want to learn it to describe my API services. Here ...
How to use the "set-backend-service" Policy Statement for an Azure API service operation? The "set-b...