This a very simple connection using mysql. 1. connect to mysql: db = mySQLdb.connect(user='root',passwd='something')
2. To execute and get the result: c = db.cursor() c.execute(sql comment) result = c.fetchall() you can wrap it in a class object. pujo On 6/21/05, Don Parris <[EMAIL PROTECTED]> wrote: > As a newbie developer, the easiest way for me to connect to MySQL is to > just copy & paste the connection commands into each funtion I write. > However, I know that's far from ideal, and consumes more time than its > worth. I would like to create a MySQL connection function that I can just > call up whenever I need it from within an other function. > > ### The Connection Definition ### > # def mysql_Conn(): > # Create a connection object and create a cursor. > # Con = MySQLdb.Connect(host="127.0.0.1", port=3306, user="user", > passwd="password", db="chaddb_test") # email text wrap here > # Cursor = Con.cursor() > > ### The function that Calls the Connection ### > def mbr_Roster(): > mysql_Conn() > > # Make SQL string and execute it. > sql = "SELECT fst_name, lst_name FROM person\ > where env_num is not null\ > order by lst_name" > Cursor.execute(sql) > > # Fetch all results from the cursor into a sequence and close the > # connection. > Results = Cursor.fetchall() > Con.close() > > How do I get mbr_Roster() to recognize the 'Cursor' from mysql_Conn()? Do I > need to declare the cursor as a global variable? > > >From the Traceback: > global name 'Cursor' is not defined > > > Don > -- > evangelinux GNU Evangelist > http://matheteuo.org/ http://chaddb.sourceforge.net/ > "Free software is like God's love - you can share it with anyone anytime > anywhere." > _______________________________________________ > Tutor maillist - Tutor@python.org > http://mail.python.org/mailman/listinfo/tutor > _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
