小編使用python中的django框架來(lái)完成！
1，首先用pycharm創(chuàng)建django項(xiàng)目并配置相關(guān)環(huán)境
這里小編默認(rèn)項(xiàng)目都會(huì)創(chuàng)建
settings.py中要修改的兩處配置
DATABASES = {
'default': {
# 'ENGINE': 'django.db.backends.sqlite3',
# 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
'ENGINE': 'django.db.backends.mysql',
'NAME': 'photos',
'HOST': '127.0.0.1',
'PORT': '3306',
'USER': 'root',
'PASSWORD': '201314',
}
}
STATIC_URL = '/static/'
STATICFILES_DIRS = [
os.path.join(BASE_DIR, 'static')
]
2，創(chuàng)建表
①先按鍵盤(pán)上win+s鍵，然后輸入cmd，中文輸入法兩下回車，英文輸入法一下回車，即可進(jìn)入dos窗口。
②輸入 mysql -uroot -p密碼 回車進(jìn)入mysql數(shù)據(jù)庫(kù)，再輸入 create database 庫(kù)名; 一個(gè)小回車，創(chuàng)建數(shù)據(jù)庫(kù)🆗
③在app下的models.py中創(chuàng)建表結(jié)構(gòu)
models.py
from django.db import models
# Create your models here.
class Images(models.Model):
img = models.ImageField(upload_to='static/pictures/') # upload_to='static/pictures/'是指定圖片存儲(chǔ)的文件夾名稱，上傳文件之后會(huì)自動(dòng)創(chuàng)建
img_name = models.CharField(max_length=32)
create_time = models.DateTimeField(auto_now_add=True)
④遷移數(shù)據(jù)庫(kù)
分別按順序在pycharm下面的Terminal中執(zhí)行下面兩條語(yǔ)句
python manage.py makemigrations
python manage.py migrate
3，上傳圖片功能
urls.py
from django.conf.urls import url
from django.contrib import admin
from app01 import views
urlpatterns = [
url(r'^admin/$', admin.site.urls),
url(r'^upload/$', views.upload, name='upload'),
]
views.py
from django.shortcuts import render, redirect
from app01 import models
# Create your views here.
def upload(request):
error = ''
if request.method == 'POST':
img = request.FILES.get('img')
pic_name = img.name
if pic_name.split('.')[-1] == 'mp4':
error = '暫不支持上傳此格式圖片！！！'
else:
models.Images.objects.create(img_name=pic_name, img=img)
return redirect('show')
return render(request, 'upload.html', locals())
前端上傳頁(yè)面upload.html
!DOCTYPE html>
html lang="en">
head>
meta charset="UTF-8">
title>上傳照片/title>
/head>
body>
div style="height: 160px">
form action="" method="post" enctype="multipart/form-data">
{% csrf_token %}
h1>上傳圖片頁(yè)面/h1>
table cellpadding="5px">
tr>
td>上傳圖片/td>
td>input type="file" name="img">/td>
/tr>
tr>
td>
button>上傳/button>
/td>
td>strong style="color: red">{{ error }}/strong>/td>
/tr>
/table>
/form>
/div>
div style="text-align: center;color: #2b542c;font-size: 20px;">
a href=" {% url 'show' %} " rel="external nofollow" >返回/a>
/div>
/body>
/html>
4，展示圖片功能
urls.py
"""
from django.conf.urls import url
from django.contrib import admin
from app01 import views
urlpatterns = [
url(r'^admin/$', admin.site.urls),
url(r'^upload/$', views.upload, name='upload'),
url(r'^show/$', views.show, name='show'),
]
views.py
from django.shortcuts import render, redirect
from app01 import models
# Create your views here.
def upload(request):
error = ''
if request.method == 'POST':
img = request.FILES.get('img')
pic_name = img.name
if pic_name.split('.')[-1] == 'mp4':
error = '暫不支持上傳此格式圖片！??！'
else:
models.Images.objects.create(img_name=pic_name, img=img)
return redirect('show')
return render(request, 'upload.html', locals())
def show(request):
all_images = models.Images.objects.all()
# for i in all_images:
# print(i.img)
return render(request, 'show.html', locals())
前端展示show.html
!DOCTYPE html>
html lang="en">
head>
meta charset="UTF-8">
title>展示照片/title>
/head>
body>
{% for image in all_images %}
img src="/{{ image.img }}" style="width: 240px;height: 240px;">
{% endfor %}
br/>
p style="text-align: center;color: #2b542c;font-size: 20px;">
a href="{% url 'upload' %}" rel="external nofollow" rel="external nofollow" >返回/a>
/p>
/body>
/html>
5，刪除圖片功能
urls.py
from django.conf.urls import url
from django.contrib import admin
from app01 import views
urlpatterns = [
url(r'^admin/$', admin.site.urls),
url(r'^upload/$', views.upload, name='upload'),
url(r'^show/$', views.show, name='show'),
url(r'^delete/$', views.delete, name='delete'),
]
views.py
from django.shortcuts import render, redirect
from app01 import models
# Create your views here.
def upload(request):
error = ''
if request.method == 'POST':
img = request.FILES.get('img')
pic_name = img.name
if pic_name.split('.')[-1] == 'mp4':
error = '暫不支持上傳此格式圖片?。?！'
else:
models.Images.objects.create(img_name=pic_name, img=img)
return redirect('show')
return render(request, 'upload.html', locals())
def show(request):
all_images = models.Images.objects.all()
# for i in all_images:
# print(i.img)
return render(request, 'show.html', locals())
def delete(request):
pk = request.GET.get('pk')
models.Images.objects.filter(id=pk).delete()
return redirect('show')
show.html
!DOCTYPE html>
html lang="en">
head>
meta charset="UTF-8">
title>展示照片/title>
/head>
body>
{% for image in all_images %}
img src="/{{ image.img }}" style="width: 240px;height: 240px;">
a href="/delete/?pk={{ image.id }}" rel="external nofollow" >刪除/a>
{% endfor %}
br/>
p style="text-align: center;color: #2b542c;font-size: 20px;">
a href="{% url 'upload' %}" rel="external nofollow" rel="external nofollow" >返回/a>
/p>
/body>
/html>
6，整體演示一遍
因?yàn)闀r(shí)間緊，故以最low方式簡(jiǎn)要實(shí)現(xiàn)，并沒(méi)有加上漂亮的頁(yè)面和樣式，喜歡美的看客朋友可自行去Bootstrap官網(wǎng)或jq22自行添加?。?！
到此這篇關(guān)于django將圖片保存到mysql數(shù)據(jù)庫(kù)并展示在前端頁(yè)面的實(shí)現(xiàn)的文章就介紹到這了,更多相關(guān)django 圖片保存到mysql內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
您可能感興趣的文章:- mysql創(chuàng)建表添加字段注釋的實(shí)現(xiàn)方法
- MySQL之存儲(chǔ)過(guò)程按月創(chuàng)建表的方法步驟
- mysql創(chuàng)建表的sql語(yǔ)句詳細(xì)總結(jié)
- Hibernate4在MySQL5.1以上版本創(chuàng)建表出錯(cuò) type=InnDB
- 詳解在MySQL中創(chuàng)建表的教程
- MySQL動(dòng)態(tài)創(chuàng)建表，數(shù)據(jù)分表的存儲(chǔ)過(guò)程
- MYSQL建立外鍵失敗幾種情況記錄Can''t create table不能創(chuàng)建表
- IDEA連接mysql數(shù)據(jù)庫(kù)報(bào)錯(cuò)的解決方法
- golang實(shí)現(xiàn)mysql數(shù)據(jù)庫(kù)事務(wù)的提交與回滾
- MySQL安裝后默認(rèn)自帶數(shù)據(jù)庫(kù)的作用詳解
- python3 實(shí)現(xiàn)mysql數(shù)據(jù)庫(kù)連接池的示例代碼
- mysql數(shù)據(jù)庫(kù)入門(mén)第一步之創(chuàng)建表
