Also, I am not sure how you have written html code, so use it properly according to your convinience.
On Wed, Sep 4, 2019 at 2:41 PM Anirudh Jain <[email protected]> wrote: > This can be done easily if you make a proper view function and render data > from it in template properly. > A view function can be written like this :- > > Here I am assuming that you want get the details of all the books/auuthors > at one page. If you want details of a particular book, then the following > function will be different. > > from .models import Details, Author, Books > from django.shortcuts import render > > view.py :- > def getdetails(request): > template_name = 'showDetails.html' > objs = Details.objects.all() > context = {'objs; : objs} > return render(request, template_name, context} > > > showDetails.html :- > (use this block in your html code wherever you want to show this data) > > {% if objs %} > > <table> > <tr> > <th>Author</th> > <th>Book</th> > </tr> > > {% for obj in objs %} > <tr> > <td>{{ obj.author_name }} </td> > <td>{{ obj.book_name }} </td> > </tr> > {% endfor %} > </table> > > {% endif %} > > (In above html code, I have assumed that author_name and book_name are the > FK in your Details table. Also, I am not sure > > > On Wed, Sep 4, 2019 at 1:34 PM Lim Kai Wey <[email protected]> wrote: > >> Hey Amit, >> >> I suggest you to follow this tutorial to build your project, >> >> https://developer.mozilla.org/en-US/docs/Learn/Server-side/Django/Tutorial_local_library_website >> >> It teaches you all the basics that you need to know from scratch, which >> in my opinion will answer all the questions you're asking. >> The tutorial is about building a local library webpage which I believe is >> very similar to what you are doing now. >> >> Hope this helps. >> >> Regards, >> Kai Wey >> >> On Wed, Sep 4, 2019 at 3:59 PM Amit Samanta <[email protected]> >> wrote: >> >>> now how can i get the name for author and details?? >>> >>> On Wed, 4 Sep, 2019, 10:25 AM Bhoopesh sisoudiya, <[email protected]> >>> wrote: >>> >>>> Hi Amit, >>>> >>>> You can use >>>> =================≠===================== >>>> Book.objects.select_related(FK).select_related(FK). values (select >>>> column name which you want).all() >>>> >>>> >>>> Thanks >>>> Bhoopesh sisoudiya >>>> >>>> On Wed, Sep 4, 2019, 9:38 AM Amit Samanta <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I need help i am not understanding the keywords of joining and fetch >>>>> value in veiw.py >>>>> i have three tables in model.py >>>>> >>>>> Table 1(Author) : >>>>> >>>>> Table 2(books): >>>>> >>>>> Table 3 (details): >>>>> FK of table1 >>>>> FK of table2 >>>>> >>>>> Fk = foreign key >>>>> >>>>> I have to just show >>>>> >>>>> Author (author name) Books (dynamic) Books(author 2nd book) >>>>> ... >>>>> details(dynamic) >>>>> details(dtl of author 2nd book) ... >>>>> >>>>> I have created the template >>>>> >>>>> now in views.py i an confused >>>>> >>>>> book=books.object(i do not get what to do) >>>>> Author= (same ) >>>>> details = (same) >>>>> >>>>> Please can anybody help that will be very greatfull. >>>>> Thank you in advance >>>>> >>>>> >>>>> >>>>> Thanks and Regards >>>>> Amit Samanta >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Django users" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/django-users/54483cc3-eadd-4559-8c61-c179cfbab933%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/django-users/54483cc3-eadd-4559-8c61-c179cfbab933%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Django users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/CAAk3c1OzGXKSQg8GK1C8_5Ck-iQ%2B1WjsYMdD%2B%2B0_q3inb94jyw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/django-users/CAAk3c1OzGXKSQg8GK1C8_5Ck-iQ%2B1WjsYMdD%2B%2B0_q3inb94jyw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CAP4hbAY%3DvOB%2BEs6hZ77jcAU_-LuuG51LkqEPU3eB5nrgqS48ow%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CAP4hbAY%3DvOB%2BEs6hZ77jcAU_-LuuG51LkqEPU3eB5nrgqS48ow%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAPcVkjg11EAf-rYFvoz85Y5BLKBisD4FJQSOCzonzi0TFC91ZQ%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAPcVkjg11EAf-rYFvoz85Y5BLKBisD4FJQSOCzonzi0TFC91ZQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > *Anirudh Jain* | *Appreciate you taking time to read the mail.* > -- *Anirudh Jain* | *Appreciate you taking time to read the mail.* -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAC3mK7c%2B_neeXH1qJF9P58mhxBjPh3Aze8K-8CTtpP_vUZmp2w%40mail.gmail.com.
