Python CGI psycopg2 - příklad 1: Porovnání verzí
m (příklad psycopg2) |
(Žádný rozdíl)
|
Verze z 24. 4. 2007, 18:00
#!/usr/bin/python print "Content-type: text/html" print try: import psycopg2 conn = psycopg2.connect("dbname='webdb' user='webuser' \ host='localhost' password='tajne-heslo'") cur = conn.cursor() cur.execute("""SELECT a, b FROM test""") rows = cur.fetchall() print "<html>" print "<head>" print "<title>SQL select -> HTML tabulka</title>" print "</HEAD>" print "<body bgcolor = white>" print "<table border=\"1\">" print "<tr>" print "<th> a </th>" # sloupec a print "<th> b </th>" # sloupec b print "</tr>" for row in rows: print "<tr>" print "<td>" + row[0] + "</td>" print "<td>" + row[1] + "</td>" print "</tr>" print "</table>" print "</body>" print "</html>" except: print "pripojeni k databazi se nepodarilo"