Video playing
import sqlite3
def application(environ, start_response):
db = sqlite3.connect('/var/www/html/table.db')
db.row_factory = sqlite3.Row
cursor = db.cursor()
cursor.execute('''SELECT id, video_filename FROM table ORDER BY id DESC''')
results = ['<table><th>id</th><th>video_filename</th>']
for row in cursor:
results.append('<tr>')
results.append('<td>{0}</td>'.format(row['id']))
results.append('<td>{0}</td>'.format(row['video_filename'])
results.append('</tr>')
db.close()
results.append('</table>')
headers = [
('Content-Type', 'text/html; charset=utf-8'),
('Content-Length', str(sum(len(line) for line in results)))
]
start_response('200 OK', headers)
return results
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line