Displaying MySQL rows with link to show details in Django framework

Our Listing page output is here

Alex John
My John Rob
Asruid
Tes Qry
Big John

On click of the link we will get output like this.

7,My John Rob,Five,78,male
Back

Connecting to urls.py

To execute our model and display records we must add our function to urls.py file.

urls.py

from django.urls import include, path
from.import views
urlpatterns = [
	path('student/display/',views.display,name='display')
]

http://127.0.0.1:8000/student/display/

When we use above url, our url page inside student app will run views.py using display function.

views.py

def display(request):
    id=request.GET.get('id', 'Not available')
    if(id != 'Not available'):
        st=student.objects.get(id=id)
        return render(request,'details.html',{'st':st})
    else:
        st=student.objects.all().order_by('id')[5:10]
        return render(request,'list.html',{'st':st})

Here we can see if the value of id is not available ( id='Not available' ) then list.html is used and if id value is available then details.html is used.

Learn how to collect query string data here.
We used st=student.objects.all().order_by('id')[5:10] to generate one QuerySet with records from id 6 to 10, this line can be changed to get different set of records by using filters.
Different filters and string matching for getting QuerySet.
list.html

{% extends 'temp_basic.html' %}
{% block content %}
{% for sts in st %}
 <a href=?id={{sts.id}}>{{sts.name}}</a><br>
{% endfor %}
{% endblock %}

details.html

{{st.id}},{{st.name}},{{st.cl}},{{st.mark}},{{st.gender}}
<br>
<a href=./>Back</a>

Web form data inserting to MySQL table

Django MySQL for loop form Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

List with link to details from MySQL table

Connecting to urls.py

Subhendu Mohapatra