• Django模糊查询


    https://blog.csdn.net/liuweiyuxiang/article/details/71104613

    def search(request):

        searchtype = request.POST.get("searchtype")

        keyword = request.POST.get("keyword")

        if searchtype == "all":

            #多个字段模糊查询, 括号中的下划线是双下划线,双下划线前是字段名,双下划线后可以是icontains或contains,区别是是否大小写敏感,竖线是或的意思

            sciencenews = models.Sciencenews.objects.filter(Q(title__icontains=keyword)

    |Q(content__icontains=keyword)|Q(author__icontains=keyword))

        elif searchtype == "author":

            #单个字段模糊查询

            sciencenews = models.Sciencenews.objects.filter(author__icontains=keyword)

        elif searchtype == "title":

            sciencenews = models.Sciencenews.objects.filter(title__icontains=keyword)

        elif searchtype == "content":

            sciencenews = models.Sciencenews.objects.filter(content__icontains=keyword)

    else:

    #使用点连接的filter链表示and

    sciencenews = models.Sciencenews.objects.filter(author__icontains=keyword).

    filter(title__icontains=keyword).filter(content__icontains=keyword)

        return render(request,"show/index.html",{"param":sciencenews,"searchtype":searchtype,"keyword":keyword})

    1

    2

    3

    4

    5

    6

    7

    8

    9

    10

    11

    12

    13

    14

    15

    16

    17

    18

    19

    20

  • 相关阅读:
    使用setTimeout()代替setInterval()
    音视频入门-02-RGB拼图
    音视频入门-01-认识RGB
    CMake入门-04-自定义编译选项
    CMake入门-03-还是HelloWorld
    CMake入门-02-HelloWorld扩展
    CMake入门-01-从HelloWorld开始
    HTML页面启动sass监听编译成css文件
    安装+配置Express
    安装+配置Nginx
  • 原文地址:https://www.cnblogs.com/pythonClub/p/9886579.html
Copyright © 2020-2023  润新知