retrieveing data in pysqlite by user input

klia

hello everyone

How can i be able to prompt users to query their search about photos Date in which date formate is "2008:12:10". by the way the following codes are hardcoded.

Expand|Select|Wrap|Line Numbers

 import os

import sqlite3

from pysqlite2 import dbapi2 as sqlite3

#import Database.py
 
#Retrieving Data from DB
 
connection = sqlite3.connect('Photos.db')

memoryConnection = sqlite3.connect(':memory:')

cursor = connection.cursor()

cursor.execute('SELECT * FROM photos where Date = "2008:10:12 15:19:16 "')

print cursor.fetchall()

retrieveing data in pysqlite by user input

Similar Python bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about