Laravel-将文件上传到数据库 [英] Laravel - Upload File to Database
问题描述
这些就是我所拥有的:
名为lamanInformasi的数据库表，其中具有名为isi的字段.
Database table named lamanInformasi, which has field named isi.
这就是我想要的:
用户可以上传多个文档或图像文件，并且这些文件将存储到数据库中.文件名将保存到isi字段，文件本身将保存到名为propic的文件夹.用户还可以在网站上显示所需的文件并下载.
User can upload multiple document or image files, and the files will be stored to database. The file names will be saved to isi field, and the files itself will be saved to a folder named propic. User also can show the file they want on the website and download it.
这就是我所做的:
我使用了bootstrap插件来输入文件.我使用了源.我只使用了js和css文件夹中的文件.这是我的代码:
I used bootstrap plugin to input file. I used this source. I just used files inside the js and css folder. This is my code:
<html lang="en">
<head>
<meta charset="UTF-8"/>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
<link href="../css/fileinput.css" media="all" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script src="../js/fileinput.js" type="text/javascript"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js" type="text/javascript"></script>
</head>
<body>
<div class="container kv-main">
<div class="page-header">
<h1>Upload Files</h1>
</div>
<form enctype="multipart/form-data">
<div class="form-group">
<input id="file-5" class="file" type="file" multiple data-preview-file-type="any" data-upload-url="#">
</div>
</form>
</div>
</body>
<script>
$("#file-5").fileinput({
uploadUrl: "{{ url('lamanInformasi') }}",
uploadAsync: false,
previewFileIcon: '<i class="fa fa-file"></i>',
allowedPreviewTypes: 'image',
previewFileIconSettings: {
'doc': '<i class="fa fa-file-word-o text-primary"></i>',
'xls': '<i class="fa fa-file-excel-o text-success"></i>',
'ppt': '<i class="fa fa-file-powerpoint-o text-danger"></i>',
'jpg': '<i class="fa fa-file-photo-o text-warning"></i>',
'pdf': '<i class="fa fa-file-pdf-o text-danger"></i>',
'zip': '<i class="fa fa-file-archive-o text-muted"></i>',
'htm': '<i class="fa fa-file-code-o text-info"></i>',
'txt': '<i class="fa fa-file-text-o text-info"></i>',
'mov': '<i class="fa fa-file-movie-o text-warning"></i>',
'mp3': '<i class="fa fa-file-audio-o text-warning"></i>',
},
previewFileExtSettings: {
'doc': function(ext) {
return ext.match(/(doc|docx)$/i);
},
'xls': function(ext) {
return ext.match(/(xls|xlsx)$/i);
},
'ppt': function(ext) {
return ext.match(/(ppt|pptx)$/i);
},
'zip': function(ext) {
return ext.match(/(zip|rar|tar|gzip|gz|7z)$/i);
},
'htm': function(ext) {
return ext.match(/(php|js|css|htm|html)$/i);
},
'txt': function(ext) {
return ext.match(/(txt|ini|md)$/i);
},
'mov': function(ext) {
return ext.match(/(avi|mpg|mkv|mov|mp4|3gp|webm|wmv)$/i);
},
'mp3': function(ext) {
return ext.match(/(mp3|wav)$/i);
},
}
});
</script>
这是我的问题
如何将文件保存到数据库?如何显示网站上的文件?如何使文件可下载?谢谢
How to save the files to database? How to show the files on the website? How to make the files become downloadable? Thanks
推荐答案
您需要为文件输入字段命名，例如
You need to give the file input field a name like
<form enctype="multipart/form-data">
<div class="form-group">
<input id="file-5" name="image" class="file" type="file" multiple data-preview-file-type="any" data-upload-url="#">
</div>
</form>
然后在您的控制器方法中，您可以访问上载的文件并获取各种属性
Then in your controller method you can access the uploaded file and get the various properties
**EDIT**
$destinationPath = storage_path().'/uploads/';
or
$destinationPath = public_path().'/uploads/';
//storage_path will give the fully qualified path to the storage folder
//public_path will give the fully qualified path to the public folder
//uploads - is the folder name where you want to store the user uploaded files, could be any name you prefer.
**EDIT end**
// Retrieving An Uploaded File
$file = Input::file('image');
// Determining If A File Was Uploaded
if (Input::hasFile('image'))
{
//
}
// Determining If An Uploaded File Is Valid
if (Input::file('image')->isValid())
{
//
}
// Moving An Uploaded File
Input::file('image')->move($destinationPath);
Input::file('image')->move($destinationPath, $fileName); //$filename is the name by which you want to store the file - change the name if required by by app.
// Getting Requested file path
$path = Input::file('image')->getRealPath();
// Getting Original name of the file
//**Edit** - gives the original filename as on uploading user's system. **Edit end**
$name = Input::file('image')->getClientOriginalName();
// Getting uploaded File extention
$extension = Input::file('image')->getClientOriginalExtension();
// Getting Size of the file
$size = Input::file('image')->getSize();
// Getting MIME Type of uploaded file
$mime = Input::file('image')->getMimeType();
然后可以通过与案例lamanInformasi中的数据库表相对应的Model或使用查询构建器将原始属性直接存储到数据库表中，从而将属性存储在数据库中.
You can then store the properties in your database either through a Model corresponding to the database table in your case lamanInformasi or using query builder directly to the database table with raw queries.
看看laravel文档:
数据库-查询生成器
雄辩的模型方法
Have a look at laravel documentation:
Database - query builder
Eloquent - model approach
您可以使用 Laravel的文件系统从文件夹中检索文件并准备列表视图供用户查看可下载的文件.
You can use Laravel's filesystem to retrieve the files from a folder and prepare a list view for users to see the files available for download.
然后，用户可以利用 Laravel的响应下载为以下内容提供下载功能:用户.
Then use can leverage Laravel's Response Download to provide the download functionality for the users.
希望这会有所帮助.
这篇关于Laravel-将文件上传到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
