python django传参

来源:互联网 发布:Apache set cookie 编辑:程序博客网 时间:2024/05/17 18:16
http://192.168.137.3:8000/blog/?title=dd&body=sdsdssnode2:/django/mysite/blog#cat views.py# -*- coding: utf-8 -*-from __future__ import unicode_literals# from django.shortcuts import render, render_to_responsefrom .models import *# Create your views here.from django.http import HttpResponsefrom django.template import loaderimport MySQLdbdef query(a,b):    conn= MySQLdb.connect(        host='localhost',        port = 3306,        user='root',        passwd='1234567',        db ='tlcb',        )    cur = conn.cursor()    title=a    body=b    #a=cur.execute("select title,body, DATE_FORMAT(timestamp,'%Y-%m-%d %k.%i.%s') A from blog_blogpost where title= %s and body= %s" ,(title,body))    #a=cur.execute("select title,body, DATE_FORMAT(timestamp,'%Y-%m-%d %k.%i.%s') A from blog_blogpost where title= 'dd' and body= 'ddd'")    #a=cur.execute("select title,timestamp,body from blog_blogpost where title= '12121' and body= '31313'")    a=cur.execute('select title,body, DATE_FORMAT(timestamp,%s)  from blog_blogpost where title= %s and body= %s' ,('%Y-%m-%d %k.%i.%s',title,body))    print a    info = cur.fetchall()    print '--------------------------'    print info    print '--------------------------'    return info    cur.close()    conn.close()def archive(req):  print req  print '---------------------'  print req.COOKIES  print '---------------------'  print type(req)  print req.GET  print req.GET['title']  print req.GET['body']  title=req.GET['title']  body=req.GET['body']  param={'title':title,'body':body}    print param# get all blogpost objects  posts =query(title,body)  print posts  print type(posts)  #print blog_list  template = loader.get_template('archive.html')  context = {  'posts':posts  }  print '------------------------------------------'  print  HttpResponse(template.render(context, req))  print '------------------------------------------'  return HttpResponse(template.render(context, req))node2:/django/mysite/blog/templates#cat archive.html{% extends "base.html" %}  {% block content %}      {% for post in posts %}      <h2>{{  post.0 }}</h2>      <p>{{ post.1 }}</p>      <p>{{ post.2 }}</p>      {% endfor %}  {% endblock %}


 
原创粉丝点击