MySQL is the world's most popular open source database. Most web developers are using MySQL with php. Python can handle this database by using a module MySQL-Python. For connecting to MySQL you need MySQL-Python module,you can get it from http://sourceforge.net/projects/mysql-python .If you have a fedora or Debian Linux installation is bit easy.For installing MySQL-python in fedora type


#yum install MySQL-python


For installing in Debian do

#apt-get install MySQL-python

After installing the module we are going to do some codings for connecting to the database.

import MySQLdb

try:

    conn = MySQLdb.connect (host = "yourhost",

                            user = "user",

                            passwd = "password",

                            db = "database")

except MySQLdb.Error, e:

     print "Error %d: %s" % (e.args[0], e.args[1])

The above script will connect to database so you have to provide necessary login informations such as host name,user name,password and database name.

For executing SQL commands we hace to make a cursor.For making a cursor use the following code

cursor = conn.cursor ()

MySQL commands can execute using this cursor for example see the below code

cursor.execute ("""INSERT INTO clg_register (roll_no, name, age)VALUES(%s, %s,%s,%s)""",("39","Nikhil","18"))

You can use variables in the script instead of given values in the cursor.execute() code.Any MySQL command can execute using this code.After executing MySQL commands close the connection to the database by using the below code

cursor.close ()
conn.close ()


A sample program is given below to insert data into a school register database.

import MySQLdb



try:

   conn = MySQLdb.connect (host = "localhost",

                           user = "root",

                           passwd = "password",

                           db = "college_register")

except MySQLdb.Error, e:

    print "Error %d: %s" % (e.args[0], e.args[1])

cursor = conn.cursor ()

cursor.execute ("""

CREATE TABLE Person

(

LastName varchar(30),

FirstName varchar(20),

Address varchar(30),

Age int(3)

)

""")



cursor.execute ("""INSERT INTO Person(LastName,FirstNAME,Address,Age) VALUES("Vishnu","Nikhil","India,Kerala","18")""")

cursor.close ()

conn.close ()

Making a web server using python is very easy. It is done by using web frameworks of python.Here we are using Web.py as a web framework. For using python first you have to install python in your system. In linux and unix os's python is a built in language. Windows version of python can be download from www.python.org.Download and install latest version of python. from http://webpy.org/ download and install web.py. Installing web.py is a very easy one. Extract the file in a folder using command prompt go to the folder and type.

>>python setup.py install

This will install Web.py.

Writing the first application


code.py
-----------

import web
urls = ('/', 'index'    )
class index:
  def GET(self):
        print "Hello World!"
if __name__ == "__main__": web.run(urls, globals())

This is a Hello world program. Copy this code and save it as "code.py" . Run this file using command prompt by using the command

>>python code.py

this will give you a message like the below one.

>>http://0.0.0.0:8080/

This tells us that our system became a server and it serve the data through the port 8080. You can see the "Hello World!" message by typing the address http://localhost:8080/ in your browser.If all thigs worked well you can see Hello World! message in your browser. You can use the python functionalities for making complex codes for the server. The html pages are served using templates.