#!/usr/bin/env python #encoding:utf-8 import MySQLdb print "<html>" print "<body>" print "<h2>book</h2>" print "<ul>" connection = MySQLdb.connect(user="root", passwd="123456", db="zabbix") cursor = connection.cursor() cursor.execute("SELECT * FROM users") for row in cursor.fetchall(): print "<li>%s</li>" % row[0] print "</ul>" print "</body></html>"
[root@bogon ~]# python mysql.py <html> <body> <h2>book</h2> <ul> <li>1</li> <li>2</li> </ul> </body></html> [root@bogon ~]#
yum install MySQL-python
