mysql and Django configuration and simple operation of the database-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

mysql and Django configuration and simple operation of the database

黄舟

Jul 18, 2017 pm 03:25 PM

djangomysqldatabase

This article mainly introduces Django+mysql configuration and simple operation database examples. Friends who need it can refer to it

Step 1: Download the mysql driver

cmd to enter the created django project directory: use the command

pip install mysqlclient

and wait for the installation to be successful!

Step 2: Configure mysql connection parameters in settings.py (if you don’t have mysql, install mysql first)

DATABASES = {
  &#39;default&#39;: {
    &#39;ENGINE&#39;: &#39;django.db.backends.mysql&#39;,
    &#39;NAME&#39;: &#39;数据库名(你得先在mysql中创建数据库)&#39;,
    &#39;USER&#39;:&#39;mysql用户名（如root）&#39;,
    &#39;PASSWORD&#39;:&#39;密码（如123456789）&#39;,
    &#39;HOST&#39;:&#39;域名（127.0.0.1或localhost）&#39;,
    &#39;PORT&#39;:&#39;端口号（3306）&#39;,
  }
}

Step 3: Create the model class in models.py

from django.db import models
# Create your models here. 类似于MVC架构中的Model
class Article(models.Model):
  title = models.CharField(max_length=60,default=&#39;title&#39;)
  content = models.TextField(null=True)

Step 4: Create a database table based on the model class

1. cmd into the django project path

2. Python manage.py migrate #Create the table structure, non Other tables of the model class, required by Django

3, python manage.py makemigrations app name#Preparation for data migration

For example: python manage.py makemigrations myblog myblog is in my project app name

4, python manage.py migrate #Execute migration and create medel table structure

##Step 5: Start writing code

First let’s talk about the requirements, which is to insert a record into MySQL in the code and display it on the page

1. Create a new template under templates, which is actually a page, such as index.html

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Title</title>
</head>
<body>
<h2 id="nbsp-article-title"> {{article.title}}</h2>
内容:{{ article.content }}
</body>
</html>

Use {{ }} to display data on the page. You will understand if you look at it here

2. Configure URL

1. In the project Configure url mapping in urls.py under the project (note that it is urls.py under the project):

from django.conf.urls import url,include
from django.contrib import admin
#根url配置
urlpatterns = [
  #url(页面正则,响应的方法名称)
  url(r&#39;^admin/&#39;, admin.site.urls),
  url(r&#39;^myblog/&#39;,include(&#39;myblog.urls&#39;)),
]

Note here that there is a

include ('myblog.urls') is the secondary url we want to configure next. Configure

from django.conf.urls import url
from django.contrib import admin
from . import views
urlpatterns = [
  #url(页面正则,响应的方法名称) ^index$:表示要以index开始和结束，正则约束
  url(r&#39;^index/$&#39;,views.index),
]

in the urls.py under the app. Now a path is 'localhost:8000/myblog/ The access path of index/' is configured. url(r'^index/$', views.index) means that the final /myblog/index/ path is responded to by the index method in views.py.

3. Write a response function: insert a data into the image data and display it on the page

from django.shortcuts import render
from django.http import HttpResponse
from myblog.models import Article
# Create your views here.
def index(request):
  article = Article(title=&#39;标题&#39;,content=&#39;内容！&#39;)
  article.save()
  return render(request,&#39;index.html&#39;,{&#39;article&#39;:article}

Step 6 : Run the project

I use pycharm here, just click the run button. If you don’t have pycharm, you can use:

python manage.py runserver

Start the server, then enter http://localhost:8000/myblog/index/ in the browser, and call it a day!

The above is the detailed content of mysql and Django configuration and simple operation of the database. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

怎么将Django项目迁移到linux系统中Jun 01, 2023 pm 01:07 PM

Django项目配置修改我们需要把原先的Django项目进行修改才能更好地进行项目迁移工作，首先需要修改的是settings.py文件。由于项目上线之后不能让用户看到后台的运行逻辑，所以我们要把DEBUG改成False，把ALLOWED_HOSTS写成‘*’，这样是为了允许从不同主机进行访问。由于linux中如果不加这句可能会出现文件找不到的情况，所以我们要把模板的路径进行拼接。由于做Django项目肯定进行过数据库的同步，所以我们要把migrations

centos+nginx+uwsgi部署django项目上线的方法May 15, 2023 am 08:13 AM

我django项目叫yunwei,主要app是rabc和web,整个项目放/opt/下如下：[root@test-codeopt]#lsdjango_virtnginxredisredis-6.2.6yunwei[root@test-codeopt]#lsyunwei/manage.pyrbacstatictemplatesuwsgiwebyunwei[root@test-codeopt]#lsyunwei/uwsgi/cut_log.shloguwsgi.iniuwsgi.loguwsgi.p

Django框架中的数据库迁移技巧Jun 17, 2023 pm 01:10 PM

Django是一个使用Python语言编写的Web开发框架，其提供了许多方便的工具和模块来帮助开发人员快速地搭建网站和应用程序。其中最重要的一个特性就是数据库迁移功能，它可以帮助我们简单地管理数据库模式的变化。在本文中，我们将会介绍一些在Django中使用数据库迁移的技巧，包括如何开始一个新的数据库迁移、如何检测数据库迁移冲突、如何查看历史数据库迁移记录等等

Django框架中的文件上传技巧Jun 18, 2023 am 08:24 AM

近年来，Web应用程序逐渐流行，而其中许多应用程序都需要文件上传功能。在Django框架中，实现上传文件功能并不困难，但是在实际开发中，我们还需要处理上传的文件，其他操作包括更改文件名、限制文件大小等问题。本文将分享一些Django框架中的文件上传技巧。一、配置文件上传项在Django项目中，要配置文件上传需要在settings.py文件中进

如何用nginx+uwsgi部署自己的django项目May 12, 2023 pm 10:10 PM

第一步：换源输入命令换掉Ubuntu的下载源sudonano/etc/apt/sources.list将以下全部替换掉原文件，我这里用的是阿里的源，你也可以换其他的。debhttp://mirrors.aliyun.com/ubuntu/bionicmainrestricteddebhttp://mirrors.aliyun.com/ubuntu/bionic-updatesmainrestricteddebhttp://mirrors.aliyun.com/ubuntu/bionicunive

使用Django构建RESTful APIJun 17, 2023 pm 09:29 PM

Django是一个Web框架，可以轻松地构建RESTfulAPI。RESTfulAPI是一种基于Web的架构，可以通过HTTP协议访问。在这篇文章中，我们将介绍如何使用Django来构建RESTfulAPI，包括如何使用DjangoREST框架来简化开发过程。安装Django首先，我们需要在本地安装Django。可以使用pip来安装Django，具体

使用Python Django框架构建博客网站Jun 17, 2023 pm 03:37 PM

随着互联网的普及，博客在信息传播和交流方面扮演着越来越重要的角色。在此背景下，越来越多的人开始构建自己的博客网站。本文将介绍如何使用PythonDjango框架来构建自己的博客网站。一、PythonDjango框架简介PythonDjango是一个免费的开源Web框架，可用于快速开发Web应用程序。该框架为开发人员提供了强大的工具，可帮助他们构建功能丰

Django+Bootstrap构建响应式管理后台系统Jun 17, 2023 pm 05:27 PM

随着互联网技术的快速发展和企业业务的不断扩展，越来越多的企业需要建立自己的管理后台系统，以便于更好地管理业务和数据。而现在，使用Django框架和Bootstrap前端库构建响应式管理后台系统的趋势也越来越明显。本文将介绍如何利用Django和Bootstrap构建一个响应式的管理后台系统。Django是一种基于Python语言的Web框架，它提供了丰富的功

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

1 months agoByDDD

R.E.P.O. Save File Location: Where Is It & How to Protect It?

1 months agoByDDD

R.E.P.O. Best Graphic Settings

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

1 weeks agoByDDD

Hot Tools

SublimeText3 English version

Recommended: Win version, supports code prompts!

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),