Django Querying database based on the user input

Question

I just started learning python/django and I'm working on a small project. I have models and an html form build. How can I query my database and filter all the names of the drivers that matches the destination city the user entered.

My models

class Drivers(models.Model):
    first_name = models.CharField(max_length=30, null=True, blank=False)
    last_name = models.CharField(max_length=30, null=True, blank=False)
    destination_one = models.CharField(max_length=50, null=True, blank=False)

My HTML form

<form id="searchform"  method="get" action="" accept-charset="utf-8">
  Search destination:
  <input id="searchbox" name="search_res" type="text" placeholder="Search">
  <input type="submit" value="OK">
</form>

    {% for dr in results %}

        {{dr.first_name}}
        {{dr.last_name}}
        {{dr.destination_one}}
        <br>

    {% endfor %}

    <br>

My View

def newpage(request):
    query = request.GET.get('search_res')
    if request.method == 'GET':
        results = Drivers.objects.filter(destination_one=query)
        context = RequestContext(request)
    return render_to_response(request,'busapp/newpage.html',{'results': results})

Models and HTML are fine. I'm having trouble building a simple def in views.py.

if querry=None that will create issue in filter when user open that page without search_res parameter — Neeraj Kumar
– Neeraj Kumar, Commented Oct 13, 2017 at 6:23

marc_s · Accepted Answer · 2017-10-13 20:03:23Z

2

from django.shortcuts import render
def newpage(request):
    query = request.GET.get('search_res', None)
    context = {}

    if query and request.method == 'GET':
        results = Drivers.objects.filter(destination_one=query)
        context.update({'results': results})
return render(request,'busapp/newpage.html',context)

edited Oct 13, 2017 at 20:03

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 13, 2017 at 6:10

Neeraj Kumar

3,9612 gold badges23 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Django Querying database based on the user input

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related