retrieveing data in pysqlite by user input

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • klia
    New Member
    • Oct 2008
    • 14

    retrieveing data in pysqlite by user input

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