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.
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.
Code:
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()