I have a form in which I can input text through text boxes.
How do I make these data go into the
db on clicking submit.
this is the code of the form in the template.
<form method="post" action="app/save_page">
<p>
Title:<input type="text" name="title"/>
</p>
<p>
Name:<input type="text" name="name"/>
</p>
<p>
Phone:<input type="text" name="phone"/>
</p>
<p>
Email:<input type="text" name="email"/>
</p>
<p>
<textarea name="description" rows=20 cols=60>
</textarea><br>
</p>
<input type="submit" value="Submit"/>
</form>
I have a function in the views.py for saving the data in the page. But I dont know how to impliment it properly:
def save_page(request):
title = request.POST["title"]
name = request.POST["name"]
phone = request.POST["phone"]
email = request.POST["email"]
description = request.POST["description"]
Now how do I send these into the db?
And what do I put in views.py so that those data goes into the db?
so how do I open a database connection and put those into the
db and save it?
should I do something like :
connection=sqlite3.connect('app.
db')
cursor= connection.cursor()
.....
.....
connection.commit()
connection.close()
Thank you.
