📌 Introduction
In real applications, data is usually displayed in a tabular format rather than plain text.
In this program, we will:
- fetch student records from database
- display them in a structured HTML table
- use Django template loops
🎯 Program Statement
👉 Display model records in table format using a list view.
🧠 Prerequisite
We use the same Student model from previous posts.
⚙️ Step 1: Create View
📁 File: views.py
🔹 Path:
myproject/myapp/views.py
🔹 Code:
from django.shortcuts import render
from .models import Student
def student_table(request):
students = Student.objects.all()
return render(request, 'student_table.html', {
'students': students
})
🧠 Explanation
- Fetch all records using ORM
- Pass data to template as
students
⚙️ Step 2: URL Mapping
📁 File: urls.py
🔹 Path:
myproject/myproject/urls.py
🔹 Code:
from django.contrib import admin
from django.urls import path
from myapp import views
urlpatterns = [
path('admin/', admin.site.urls),
path('student-table/', views.student_table, name='student_table'),
]
⚙️ Step 3: Create Template (Table Format)
📁 File: student_table.html
🔹 Path:
myproject/templates/student_table.html
🔹 Code:
<!DOCTYPE html>
<html>
<head>
<title>Student Table</title>
<style>
table {
border-collapse: collapse;
width: 80%;
margin: auto;
}
th, td {
border: 1px solid black;
padding: 10px;
text-align: center;
}
th {
background-color: #f2f2f2;
}
</style>
</head>
<body>
<h1 style="text-align:center;">Student Table</h1>
{% if students %}
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Age</th>
<th>Course</th>
<th>Email</th>
</tr>
{% for s in students %}
<tr>
<td>{{ s.id }}</td>
<td>{{ s.name }}</td>
<td>{{ s.age }}</td>
<td>{{ s.course }}</td>
<td>{{ s.email }}</td>
</tr>
{% endfor %}
</table>
{% else %}
<p style="text-align:center;">No records found.</p>
{% endif %}
</body>
</html>
🧠 Explanation
<table>is used for structured display{% for %}loop creates rows dynamically{{ s.id }}shows auto-generated primary key- Styling improves readability
⚙️ Step 4: Run Server
python manage.py runserver
🌐 Step 5: Output
👉 Open:
http://127.0.0.1:8000/student-table/
✅ Example Output:
| ID | Name | Age | Course | |
|---|---|---|---|---|
| 1 | Kanchan | 20 | MCA | kanchan@example.com |
| 2 | Aman | 22 | BCA | aman@example.com |
| 3 | Riya | 21 | MCA | riya@example.com |
🧠 How It Works
- View fetches all records
- Data passed to template
- Template creates table structure
- Loop fills table rows dynamically
🔥 Key Concepts
Fetch Data
Student.objects.all()
Table Structure
<table>
Used for tabular data display.
Loop for Rows
{% for s in students %}
Creates one row per record.
Access Fields
{{ s.name }}
Displays model field value.
Primary Key
{{ s.id }}
Auto-generated ID field.
⚠️ Common Errors
❌ Table not displaying
Check:
{% if students %}
❌ Missing loop
If you forget:
{% for s in students %}
no rows will be displayed.
❌ CSS not applied
Ensure <style> block is correctly written.
❌ Wrong variable name
If context uses:
{'students': students}
template must use:
students
❌ No data in database
Then output will show:
No records found.
🧪 Practice Questions
- Add serial number column
- Add alternating row colors
- Sort students by name
- Add “View Details” link in each row
- Add total record count below table
🎤 Viva Questions & Answers
1. Why do we use table format for displaying data?
Table format organizes data in rows and columns, making it easier to read and understand.
2. What is the role of {% for %} loop in table?
It is used to generate table rows dynamically for each record.
3. What is {{ s.id }}?
It is the primary key automatically created by Django for each record.
4. What is the difference between Post 45 and Post 46?
Post 45 displays data in plain text, while Post 46 displays data in a structured table format.
5. What happens if no records exist?
The {% if %} condition displays a message like “No records found.”
6. Why is styling added in table?
Styling improves readability and presentation of data.
7. Can we use Bootstrap instead of CSS?
Yes, Bootstrap can be used for better design and responsiveness.
8. Where is data fetched from?
Data is fetched from the database using Django ORM.
9. What is a list view?
A list view displays multiple records of a model.
10. Why is this program important?
Displaying data in tables is a very common requirement in real-world applications and exams.
👉 Next Post: Create a Detail Page to Display Information of a Single Record
👉 Back to List: Django Programs (60 Questions with Solutions)
Further Reading
Introduction to Django Framework and its Features
Examples of Array Functions in PHP
Registration Form Using PDO in PHP
Inserting Information from Multiple CheckBox Selection in a Database Table in PHP
- Angular
- ASP.NET
- C
- C#
- C++
- CSS
- Dot Net Framework
- HTML
- IoT
- Java
- JavaScript
- Kotlin
- PHP
- Power Bi
- Python
- Scratch 3.0
- TypeScript
- VB.NET