How to access specific object from the database in Django to display it in the webpage?

Question

I am trying to display the title and description from an SQLite database in Django? I have all the data from my database and from views file I have returned it as context.
Here's the model.py file:

from django.db import models
from django.utils import timezone
from django.contrib.auth.models import User
from django.urls import reverse


# Create your models here.

class Post(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()

Here's my views.py file:

def home(request):
    posts = Post.objects.all()
    search_query = request.GET.get('q')
    if search_query:
        posts = posts.filter(
            Q(title__icontains = search_query) |
            Q(content__icontains = search_query)
        )

    context={
        'posts': posts
    }
    return render(request,'blog/home.html', context)

And here the HTML code:-

    {% for post in posts %}
      <div class="slide-description">
          <label class="slide-0">
              <h1 class="text-slide">{{Here i want to print the title 1}}</h1>
              <h5>{{Here I want to print the content 1}}</h5>
              <a href="/" class="readmorebutton">Read More</a>
          </label>
          <label class="slide-1">
              <h1 class="text-slide">{{Here i want to print the title 2}}</h1>
              <h5>{{Here I want to print the content 2}}</h5>
              <a href="/" class="readmorebutton">Read More</a>
          </label>
          <label class="slide-2">
              <h1 class="text-slide">{{Here i want to print the title 3}}</h1>
              <h5>{{Here I want to print the content 3}}</h5>
              <a href="/" class="readmorebutton">Read More</a>
          </label>
          <label class="slide-3">
              <h1 class="text-slide">{{Here i want to print the title 4}}</h1>
              <h5>{{Here I want to print the content 4}}</h5>
              <a href="/" class="readmorebutton">Read More</a>
          </label>
      </div>
    {% endfor %}

Is there any way to get my job done i.e., display one title at a time or like what I am trying to say is, is there something like: post.title[1], post.title[2],.... or anything like this?

Zilay · Accepted Answer · 2020-08-21 11:59:49Z

1

You can simply loop through the posts.

      <div class="slide-description">
         {% for post in posts %}
          <label class="slide-0">
              <h1 class="text-slide">{{post["title"]}}</h1>
              <h5>{{post["content"]}}</h5>
              <a href="/" class="readmorebutton">Read More</a>
          </label>
         {% endfor %}
      </div>

answered Aug 21, 2020 at 11:59

Zilay

3061 silver badge6 bronze badges

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

1 Comment

Manish Shah Over a year ago

That's not the solution.

SerioUs · Accepted Answer · 2020-08-21 13:33:27Z

0

You can get that object with the specific title or content, like this:

def home(request):
    posts = Post.objects.get(title='that title you want to use')
    posts2 = Post.objects.get(title='that second title you want to use')
    and...
    search_query = request.GET.get('q')
    if search_query:
        posts = posts.filter(
            Q(title__icontains = search_query) |
            Q(content__icontains = search_query)
            )

     context={
        'posts': posts
         }
     return render(request,'blog/home.html', context)

answered Aug 21, 2020 at 13:33

SerioUs

2983 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to access specific object from the database in Django to display it in the webpage?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related