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

mysql and Django configuration and simple operation of the database

黄舟

Release： 2017-07-18 15:25:08

Original

1488 people have browsed it

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

Copy after login

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;,
  }
}

Copy after login

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)

Copy after login

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> {{article.title}}</h2>
内容:{{ article.content }}
</body>
</html>

Copy after login

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;)),
]

Copy after login

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),
]

Copy after login

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}

Copy after login

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

Copy after login

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!