#!c:\Python\python.exe # Fig. 35.23: fig35_23.py # A program to illustrate Python's database connectivity. import cgi import MySQLdb import sys # get results from form form = cgi.FieldStorage() print "Content-type: text/html" print print """ Query results """ try: authorID = form[ "authorID" ].value except KeyError: print """ FORM ERROR
You did not select an author.
Click the Back button, fill out the form and resubmit.

Thank You.""" sys.exit() # connect to database and get cursor try: connection = MySQLdb.connect( db = 'books' ) except OperationalError: print """ DATABASE ERROR
Unable to connect to database. """ sys.exit() queryString = """select Titles.* from Titles, AuthorISBN where AuthorISBN.AuthorID=%s and Titles.ISBN=AuthorISBN.ISBN""" % authorID cursor = connection.cursor() cursor.execute( queryString ) results = cursor.fetchall() cursor.close() # close cursor connection.close() # close connection # display results print """""" for row in results: print "" for entry in row: print '' % entry print "" print """
ISBN Title Edition Year Description Publisher ID
%s
""" ########################################################################## # (C) Copyright 1992-2004 by Deitel & Associates, Inc. and # # Pearson Education, Inc. All Rights Reserved. # # # # DISCLAIMER: The authors and publisher of this book have used their # # best efforts in preparing the book. These efforts include the # # development, research, and testing of the theories and programs # # to determine their effectiveness. The authors and publisher make # # no warranty of any kind, expressed or implied, with regard to these # # programs or to the documentation contained in these books. The authors # # and publisher shall not be liable in any event for incidental or # # consequential damages in connection with, or arising out of, the # # furnishing, performance, or use of these programs. # ##########################################################################