CODEWITHSUNDEEP
htmldjango
jas
jas

Reputation: 57

Extracting data from the database table and display in view

I want to fetch the data from a table which is in database and then display it in tabular format in my webpage. Only the html column name is being shown but not the data from the database table. Can anyone please help me out with this?

My codes: views.py:

def display_majorheads(request):
outputs = ProcessedOutputs.objects.all()
be_year = 0
context = {
        'processed_outputs':outputs, 
        'be_year':be_year,
    }
return render(request, 'website/mhead.html', context )

mhead.html:

<table class="table table-striped">
                <tr>
                    <th>MajorHead</th>
                    <th>BeSalary</th>
                    <th>BeGiaSalary</th> 
                    <th>BeOther</th> 
                    <th>BeTotal</th> 
                    <th>BeNextyrSalary</th>
                    <th>BeNextyrGiaSalary</th>
                    <th>BeNextyrOthrs</th>
                    <th>BeNextyrTotal</th>
                </tr>
                {% for processed_outputs in outputs %}
                <tr> 
                    <td>{{ processed_outputs.major_cd }}</td>
                    <td>{{ processed_outputs.be_salary }}</td>
                    <td>{{ processed_outputs.be_gia_salary }}</td>
                    <td>{{ processed_outputs.be_other }}</td>
                    <td>{{ processed_outputs.be_total }}</td>
                    <td>{{ processed_outputs.be_nextyr_salary }}</td>
                    <td>{{ processed_outputs.be_nextyr_gia_salary }}</td>
                    <td>{{ processed_outputs.be_nextyr_others }}</td>
                    <td>{{ processed_outputs.be_nextyr_total }}</td>  
                </tr>
                {% endfor %}
            </table>

Upvotes: 0

Views: 130

Answers (1)

barbaart
barbaart

Reputation: 867

almost there!

{% for processed_outputs in outputs %}

has to be:

{% for outputs in processed_outputs %}
{{ outputs.major_cd }}
...
...

Upvotes: 1

Related Questions