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()