Displaying a Table in Django from Database

Question

How do you display the information from a database table in a table format on a webpage  Is there a simple way to do this in django or does it require a more complicated approach  More specifically  how do you pretty much port over the columns and rows in a database table to a visual table that can be seen from a url

User · Accepted Answer

The easiest way is to use a for loop template tag.

Given the view:

def MyView(request):
    ...
    query_results = YourModel.objects.all()
    ...
    #return a response to your template and add query_results to the context

You can add a snippet like this your template...

<table>
    <tr>
        <th>Field 1</th>
        ...
        <th>Field N</th>
    </tr>
    {% for item in query_results %}
    <tr> 
        <td>{{ item.field1 }}</td>
        ...
        <td>{{ item.fieldN }}</td>
    </tr>
    {% endfor %}
</table>

This is all covered in Part 3 of the Django tutorial. And here's Part 1 if you need to start there.

User · Answer

If you want to table do following steps -  views py   def view info request       objs Model name objects all                        return render request  template name    objs  obj      html page      for item in objs         lt tr gt             lt td gt    item field1    lt  td gt            lt td gt    item field2    lt  td gt            lt td gt    item field3    lt  td gt            lt td gt    item field4    lt  td gt       lt  tr gt            endfor

User · Answer

pip install django-tables2   settings py  INSTALLED APPS    django tables2  TEMPLATES OPTIONS context-processors    django template context processors request    models py  class hotel models Model        name   models CharField max length 20    views py  from django shortcuts import render  def people request       istekler   hotel objects all       return render request   list html   locals      list html     yonetim templates list html       load render table from django tables2       load static     lt  doctype html gt   lt html gt       lt head gt           lt link rel  stylesheet  href     static   ticket static css screen css        gt       lt  head gt       lt body gt             render table istekler         lt  body gt   lt  html gt

[django] Displaying a Table in Django from Database

Examples related to django

Examples related to database