How to retrieve data from MySQL database in Django and display it in html page?

Question

I am trying to retrieve data from MySQL database and display it in a html page using python.

Here is my view.py:

def show(request):
    data = Persons.objects.all()

    person = {
       "Persons": data
    }
    return render(request, "home.html", person)

models.py:

class Persons(models.Model):   
   PersonID = models.IntegerField()
   LastName = models.CharField(max_length=100)
   FirstName = models.CharField(max_length=100)
   Address = models.CharField(max_length=100)
   City = models.CharField(max_length=100)
   class Meta:
      db_table = "persons"

html:

  <div>
      {% for item in Person %}
          <div class="numbers">{{ item.LastName }}</div>
       {% endfor %}
  </div>

But I didnot retrieve anything. Any help will be highly appreciated.

C14L · Accepted Answer · 2021-12-23 10:07:28Z

1

You create a dict key Persons

person = {
   "Persons": data
}

...but you iterate over Person

{% for item in Person %}

answered Dec 23, 2021 at 10:07

C14L

12.6k4 gold badges43 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rutuparna Over a year ago

If I am iterating over Persons I am getting error Table 'mysql.persons' doesn't exist"

C14L Over a year ago

That's the table you specified in your Model db_table = "persons". Does the table exist?

Rutuparna Over a year ago

Yes, the table exists is MySQL database.

C14L Over a year ago

To debug, use the Django shell to access the table. ./manage.py shell. Then import your Persons Model and try to read from it. If that still doesn't work, the bug is probably in you database settings.

Collectives™ on Stack Overflow

How to retrieve data from MySQL database in Django and display it in html page?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related