django将图片保存到mysql数据库并展示在前端页面的实现
作者:跟着哈哥学大智若愚 时间:2024-01-26 06:59:44
小编使用python中的django框架来完成!
1,首先用pycharm创建django项目并配置相关环境
这里小编默认项目都会创建
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,创建表
①先按键盘上win+s键,然后输入cmd,中文输入法两下回车,英文输入法一下回车,即可进入dos窗口。
②输入 mysql -uroot -p密码 回车进入mysql数据库,再输入 create database 库名; 一个小回车,创建数据库🆗
③在app下的models.py中创建表结构
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/'是指定图片存储的文件夹名称,上传文件之后会自动创建
img_name = models.CharField(max_length=32)
create_time = models.DateTimeField(auto_now_add=True)
④迁移数据库
分别按顺序在pycharm下面的Terminal中执行下面两条语句
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())
前端上传页面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>上传图片页面</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,整体演示一遍
因为时间紧,故以最low方式简要实现,并没有加上漂亮的页面和样式,喜欢美的看客朋友可自行去Bootstrap官网或jq22自行添加!!!
来源:https://blog.csdn.net/hpl980342791/article/details/116310609
标签:django,图片保存,mysql
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Python视频爬虫实现下载头条视频功能示例
2021-06-30 05:43:02
![](https://img.aspxhome.com/file/2023/8/121478_0s.jpg)
使用Eclipse如何开发python脚本
2022-06-25 12:41:39
![](https://img.aspxhome.com/file/2023/8/68848_0s.jpg)
Python-copy()与deepcopy()区别详解
2021-06-20 15:00:41
仿DW的图形菜单 DIV+CSS
2007-08-14 10:07:00
![](https://img.aspxhome.com/file/UploadPic/20078/14/2007814102358206s.gif)
Python MongoDB 插入数据时已存在则不执行,不存在则插入的解决方法
2022-11-16 20:48:41
让我们一起来学习一下什么是javascript的闭包
2024-04-17 10:11:43
![](https://img.aspxhome.com/file/2023/6/136336_0s.png)
python实现每次处理一个字符的三种方法
2023-03-07 12:27:30
MySQL常用命令与内部组件及SQL优化详情
2024-01-17 12:50:41
![](https://img.aspxhome.com/file/2023/1/111381_0s.png)
python通过函数名调用函数的几种方法总结
2021-03-22 03:40:35
pycharm开发一个简单界面和通用mvc模板(操作方法图解)
2022-10-09 06:28:39
![](https://img.aspxhome.com/file/2023/3/90283_0s.png)
MySQL表操作插入数据insert语句学习(小白入门篇)
2024-01-14 23:37:49
一些关于SQL2005+ASP.NET2.0的问题
2007-09-23 13:01:00
在ASP中使用SQL语句之7:ORDER BY
2007-08-11 12:51:00
python飞机大战游戏实例讲解
2021-12-07 14:43:26
![](https://img.aspxhome.com/file/2023/7/109467_0s.png)
python私有属性和方法实例分析
2023-11-21 06:16:13
Python中类的创建和实例化操作示例
2023-12-08 14:12:51
Python中int()函数的用法浅析
2022-08-18 09:45:12
python中sys.argv参数用法实例分析
2021-09-19 20:29:30
Sqlserver 常用日期时间函数
2024-01-16 04:35:44
Python实现队列的方法
2023-08-29 06:45:30