Django Add Record - W3Schools

Trang chủ » đan Tr » Django Add Record - W3Schools

Có thể bạn quan tâm

Tutorials References Exercises Certificates Menu Search field × See More Sign In ★ +1 Get Certified Upgrade Teachers Spaces Get Certified Upgrade Teachers Spaces My W3Schools Tutorials References Exercises Certificates Spaces Get Certified Plus Academy All our Services Logout ×

Tutorials

Tutorials filter input ×

HTML and CSS

Learn HTML Tutorial Reference Learn CSS Tutorial Reference Learn RWD Tutorial Learn Bootstrap Overview Learn W3.CSS Tutorial Reference Learn Sass Tutorial Reference Learn Colors Tutorial Reference Learn Icons Tutorial Reference Learn SVG Tutorial Reference Learn Canvas Tutorial Reference Learn Graphics Tutorial Learn UTF-8 and Emojis Reference Learn How To Tutorial

Data Analytics

Learn AI Tutorial Learn Generative AI Tutorial Learn ChatGPT-3.5 Tutorial Learn ChatGPT-4 Tutorial Learn Google Bard Tutorial Learn Machine Learning Tutorial Learn DSA Tutorial Learn Data Science Tutorial Learn NumPy Tutorial Learn Pandas Tutorial Learn SciPy Tutorial Learn Matplotlib Tutorial Learn Statistics Tutorial Learn Excel Tutorial Learn Google Sheets Tutorial

Web Building

Create a Website HOT! Create a Server NEW Where To Start Web Templates Web Statistics Web Certificates Web Development Introduction to Programming Introduction to HTML & CSS Code Editor Test Your Typing Speed Play a Code Game Cyber Security Accessibility Join our Newsletter

JavaScript

Learn JavaScript Tutorial Reference Learn React Tutorial Learn jQuery Tutorial Reference Learn Vue Tutorial Reference Learn Angular Tutorial Learn AngularJS Tutorial Reference Learn JSON Tutorial Reference Learn AJAX Tutorial Learn AppML Tutorial Reference Learn W3.JS Tutorial Reference

Web Building

Create a Website HOT! Create a Server NEW Where To Start Web Templates Web Statistics Web Certificates Web Development Introduction to Programming Introduction to HTML & CSS Code Editor Test Your Typing Speed Play a Code Game Cyber Security Accessibility Join our Newsletter

Backend

Learn Python Tutorial Reference Learn SQL Tutorial Reference Learn MySQL Tutorial Reference Learn PHP Tutorial Reference Learn Java Tutorial Reference Learn C Tutorial Reference Learn C++ Tutorial Reference Learn C# Tutorial Learn R Tutorial Learn Kotlin Tutorial Learn Rust Tutorial Learn Go Tutorial Learn Django Tutorial Reference Learn PostgreSQL Tutorial Learn TypeScript Tutorial Learn ASP Tutorial Reference Learn Node.js Tutorial Reference Learn Raspberry Pi Tutorial Learn Swift Tutorial Learn Git Tutorial Learn Bash Tutorial Learn MongoDB Tutorial Learn AWS Cloud Tutorial Learn XML Tutorial Reference

Data Analytics

Learn AI Tutorial Learn Generative AI Tutorial Learn ChatGPT-3.5 Tutorial Learn ChatGPT-4 Tutorial Learn Google Bard Tutorial Learn Machine Learning Tutorial Learn DSA Tutorial Learn Data Science Tutorial Learn NumPy Tutorial Learn Pandas Tutorial Learn SciPy Tutorial Learn Matplotlib Tutorial Learn Statistics Tutorial Learn Excel Tutorial Learn Google Sheets Tutorial

Web Building

Create a Website HOT! Create a Server NEW Where To Start Web Templates Web Statistics Web Certificates Web Development Introduction to Programming Introduction to HTML & CSS Code Editor Test Your Typing Speed Play a Code Game Cyber Security Accessibility Join our Newsletter ×

References

References filter input ×

HTML and CSS

HTML Tags Reference CSS Reference W3.CSS Reference Bootstrap 3 Reference Bootstrap 4 Reference Color Names Icons Reference SVG Reference Canvas Reference Sass Reference UTF-8 Charset Reference UTF-8 Emojis Reference

JavaScript

JavaScript Reference jQuery Reference Vue Reference Angular Reference JSON Reference AppML Reference W3.JS Reference

Backend

Python Reference SQL Reference MySQL Reference PHP Reference Java Reference C Reference C++ Reference Django Reference ASP Reference Node.js Reference XML Reference ×

Exercises

Excercises filter input ×

HTML and CSS

HTML Exercise Quiz CSS Exercise Quiz Bootstrap 3 Exercise Quiz Bootstrap 4 Exercise Quiz Bootstrap 5 Exercise Quiz

Data Analytics

DSA Exercise Quiz NumPy Exercise Quiz Pandas Exercise Quiz SciPy Exercise Quiz Excel Exercise What is an Exercise? What is a Quiz?

JavaScript

JavaScript Exercise Quiz React Exercise Quiz jQuery Exercise Quiz Vue Exercise Quiz Angular Exercise Quiz

Backend

Python Exercise Quiz SQL Exercise Quiz MySQL Exercise Quiz PHP Exercise Quiz Java Exercise Quiz C Exercise Quiz C++ Exercise Quiz C# Exercise Quiz R Exercise Quiz Kotlin Exercise Quiz Django Exercise Quiz Node.js Exercise Quiz PostgreSQL Exercise Quiz TypeScript Exercise Quiz Git Exercise Quiz Bash Exercise Quiz Go Exercise MongoDB Exercise

Data Analytics

DSA Exercise Quiz NumPy Exercise Quiz Pandas Exercise Quiz SciPy Exercise Quiz Excel Exercise What is an Exercise? What is a Quiz? ×

Certificates

Filter field for certifications ×

HTML and CSS

HTML Certificate Course CSS Certificate Course Bootstrap 3 Certificate Course Bootstrap 4 Certificate Course Bootstrap 5 Certificate

Data Analytics

DSA Certificate Data Analytics Course NumPy Certificate Course Pandas Certificate Course Excel Certificate Social Media Course What is a Certificate?

Programs

Full Access Best Value! Front End Certificate Course Web Dev. Certificate Course Web App Certificate Course Web Design Certificate Course

JavaScript

JavaScript Certificate Course React Certificate Course jQuery Certificate Course Vue Certificate

Programs

Full Access Best Value! Front End Certificate Course Web Dev. Certificate Course Web App Certificate Course Web Design Certificate Course

Programs

Full Access Best Value! Front End Certificate Course Web Dev. Certificate Course Web App Certificate Course Web Design Certificate Course

Backend

Python Certificate Course SQL Certificate Course MySQL Certificate PHP Certificate Course Java Certificate Course C Certificate C++ Certificate Course C# Certificate Course R Course Django Certificate NodeJS Certificate TypeScript Certificate Course XML Certificate Course Cyber Security Certificate Course Accessibility Certificate Course

Data Analytics

DSA Exam Data Analytics Course NumPy Course Pandas Course Excel Certificate Social Media Course What is a Certificate? ×

All Our Services

Dark mode Services filter input ×

W3Schools offers a wide range of services and products for beginners and professionals, helping millions of people everyday to learn and master new skills.

Free Tutorials

Enjoy our free tutorials like millions of other internet users since 1999

References

Explore our selection of references covering all popular coding languages

Create a Website

Create your own website with W3Schools Spaces - no setup required

Exercises

Test your skills with different exercises

Quizzes

Test yourself with multiple choice questions

Get Certified

Document your knowledge

Log in / Sign Up

Create an account to track your progress

League

Earn XP and climb the ranks with different challenges

Upgrade

Become a PLUS user and unlock powerful features (ad-free, hosting, support,..)

Where To Start

Not sure where you want to start? Follow our guided path

Code Editor (Try it)

With our online code editor, you can edit code and view the result in your browser

Videos

Learn the basics of HTML in a fun and engaging video tutorial

Templates

We have created a bunch of responsive website templates you can use - for free!

Web Hosting

Host your own website, and share it to the world with W3Schools Spaces

Create a Server

Create your own server using Python, PHP, React.js, Node.js, Java, C#, etc.

How To's

Large collection of code snippets for HTML, CSS and JavaScript

CSS Framework

Build fast and responsive sites using our free W3.CSS framework

Browser Statistics

Read long term trends of browser usage

Typing Speed

Test your typing speed

Color Picker

Use our color picker to find different RGB, HEX and HSL colors. A circular color wheel showing the gradation of colors in the spectrum

Code Game

W3Schools Coding Game! Help the lynx collect pine cones Lynx logo

Newsletter

Join our newsletter and get access to exclusive content every month

Emojis Reference

Check out our refererence page with all the emojis supported in HTML 😊

UTF-8 Reference

Check out our full UTF-8 Character reference

Community

Chat, Learn and Connect with Us on Discord

Teachers

Contact us about W3Schools Academy for educational institutions

For Businesses

Contact us about W3Schools Academy for your organization

Contact Us

About sales: [email protected] About errors: [email protected]

× ❮ ❯ HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT SWIFT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST

Django Tutorial

Django Home Django Intro Django Get Started Create Virtual Environment Install Django Django Create Project Django Create App Django Views Django URLs Django Templates Django Models Django Insert Data Django Update Data Django Delete Data Django Update Model

Display Data

Prep Template and View Add Link to Details Add Master Template Add Main Index Page Django 404 Template Add Test View

Admin

Django Admin Create User Include Models Set List Display Update Members Add Members Delete Members

Django Syntax

Django Variables Django Tags Django If Else Django For Loop Django Comment Django Include

QuerySets

QuerySet Introduction QuerySet Get QuerySet Filter QuerySet Order By

Static Files

Add Static Files Install WhiteNoise Collect Static Files Add Global Static Files Add Styles to the Project

PostgreSQL

PostgreSQL Intro Create AWS Account Create Database in RDS Connect to Database Add Members

Deploy Django

Elastic Beanstalk (EB) Create requirements.txt Create django.config Create .zip File Deploy with EB Update Project

More Django

Add Slug Field Add Bootstrap 5

Django References

Template Tag Reference Filter Reference Field lookups Reference

Django Exercises

Django Compiler Django Exercises Django Quiz Django Syllabus Django Study Plan Django Server Django Certificate Django Add Record ❮ Previous Next ❯

Adding Records

So far we have created a Members table in our database, and we have inserted five records by writing code in the Python shell.

We have also made a template that allows us to display the content of the table in a web page.

Now we want to be able to create new members from a web page.

Template

Start by adding a link in the members template:

members/templates/index.html:

<h1>Members</h1> <table border="1"> {% for x in mymembers %} <tr> <td>{{ x.id }}</td> <td>{{ x.firstname }}</td> <td>{{ x.lastname }}</td> </tr> {% endfor %} </table> <p> <a href="add/">Add member</a> </p>

The result will look like this:

New Template

Add a new template in the templates folder, named add.html:

members/templates/add.html:

<h1>Add member</h1> <form action="addrecord/" method="post"> {% csrf_token %} First Name:<br> <input name="first"> <br><br> Last Name:<br> <input name="last"> <br><br> <input type="submit" value="Submit"> </form>

The template contains an empty HTML form with two input fields and a submit button.

Note: Django requires this line in the form: {% csrf_token %} to handle Cross Site Request Forgeries in forms where the method is POST.

View

Next, add a view in the members/views.py file, name the new view add:

members/views.py:

from django.http import HttpResponse from django.template import loader from .models import Member def index(request): mymembers = Member.objects.all().values() template = loader.get_template('index.html') context = { 'mymembers': mymembers, } return HttpResponse(template.render(context, request)) def add(request): template = loader.get_template('add.html') return HttpResponse(template.render({}, request))

URLs

Add a path() function in the members/urls.py file, that points the url 127.0.0.1:8000/members/add/ to the right location:

members/urls.py:

from django.urls import path from . import views urlpatterns = [ path('', views.index, name='index'), path('add/', views.add, name='add'), ]

In the browser, click the "Add member" link and the result should look like this:

More URLs

Did you notice the action attribute in the HTML form? The action attribute specifies where to send the form data, in this case the form data will be sent to addrecord/, so we must add a path() function in the members/urls.py file that points to the right view:

members/urls.py:

from django.urls import path from . import views urlpatterns = [ path('', views.index, name='index'), path('add/', views.add, name='add'), path('add/addrecord/', views.addrecord, name='addrecord'), ]

Code for Adding Records

So far we have made the user interface, and we point the URL to the view called addrecord, but we have not made the view yet.

Make sure you add the addrecord view in the in the members/views.py file:

members/views.py:

from django.http import HttpResponse, HttpResponseRedirect from django.template import loader from django.urls import reverse from .models import Member def index(request): mymembers = Member.objects.all().values() template = loader.get_template('index.html') context = { 'mymembers': mymembers, } return HttpResponse(template.render(context, request)) def add(request): template = loader.get_template('add.html') return HttpResponse(template.render({}, request)) def addrecord(request): x = request.POST['first'] y = request.POST['last'] member = Members(firstname=x, lastname=y) member.save() return HttpResponseRedirect(reverse('index'))

Changes that are made in the views.py file:

Line 1: import HttpResponseRedirect Line 3: import reverse

The addrecord view does the following:

  • Gets the first name and last name with the request.POST statement.
  • Adds a new record in the members table.
  • Redirects the user back to the index view.

Try to add a new record and see how it works:

If you press the submit button, the members table should have been updated:

❮ Previous Next ❯ ★ +1 Sign in to track progress Get Certified Offer

COLOR PICKER

colorpicker

REMOVE ADS

PLUS SPACES GET CERTIFIED FOR TEACHERS FOR BUSINESS CONTACT US ×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:[email protected]

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:[email protected]

Top Tutorials
HTML Tutorial CSS Tutorial JavaScript Tutorial How To Tutorial SQL Tutorial Python Tutorial W3.CSS Tutorial Bootstrap Tutorial PHP Tutorial Java Tutorial C++ Tutorial jQuery Tutorial
Top References
HTML Reference CSS Reference JavaScript Reference SQL Reference Python Reference W3.CSS Reference Bootstrap Reference PHP Reference HTML Colors Java Reference AngularJS Reference jQuery Reference
Top Examples
HTML Examples CSS Examples JavaScript Examples How To Examples SQL Examples Python Examples W3.CSS Examples Bootstrap Examples PHP Examples Java Examples XML Examples jQuery Examples
Get Certified
HTML Certificate CSS Certificate JavaScript Certificate Front End Certificate SQL Certificate Python Certificate PHP Certificate jQuery Certificate Java Certificate C++ Certificate C# Certificate XML Certificate FORUM ABOUT ACADEMY W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy. Copyright 1999-2025 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.

Từ khóa » đan Tr