"Python database GUI CGI Programming"

This address: http://www.cnblogs.com/aiweixiao/p/8390417.html

Original address

Click to follow the public number Wenyuqinghuai

1. Write in front

Last time, we introduced the introduction to Python, and today we'll cover Python's database, GUI, CGI programming, and Python 2.x and Python 3.x differences.

2. Connect to the database

The Python standard database interface for Python db-api,mysqldb is the interface for the Python link MySQL database. When used, the MYSQLDB module must be installed, otherwise it will be reported that the module can not be found.

Installing the MYSQLDB module under 2.1 Linux

Use package installation to wget http://sourceforge.net/projects/mysql-python/files/latest/download

$ tar xfz mysql-python-1.2.3.tar.gz

$ CD mysql-python-1.2.3

$whereis mysql_config mysql_config:/usr/bin/mysql_config

$ vim site.cfg Modify Mysql_config as the path to the MySQL configuration file/usr/bin/mysql_config

Also to modify Threadsafe = False

$ python setup.py Build

$ sudo python setup.py install

Installing the MYSQLDB module under 2.2 mac

Install PIP using the easy_install pip command

$ easy_install pip

mac install Pip

$ pip Install Mysql-python

PIP installation Mysql-python

2.3 Querying the database

Code on GitHub Source address: HTTP://T.CN/RQJCVFL

manipulating Databases

the output effect of the database

3. GUI Programming

Python provides a library of multiple graphical development interfaces, where Tkinter is the standard GUI library for Python. Python uses Tkinter to quickly create GUI applications.

Code on GitHub Source address: HTTP://T.CN/RQJCVFL

GUI programming for Python

the effect of GUI under Mac system4. CGI Programming

1) Python's cgihttpserver is generally installed with Python, the following command can be started, in order to facilitate the organization of the directory, it is recommended to first create a directory, such as the Web, and then run the following command.

Nohup python-m cgihttpserver 8088 &

schematic diagram

2) static file code address: Http://t.cn/R8wMYHr

front-end HTML code

Access Address: http://localhost:8088/

Front end Diagram

3) The address submitted to the backend is http://localhost:8088/cgi-bin/c_area.sh

Back-end shell code

Back-end shell script address: http://t.cn/R8wMmMn

After submission, the results are calculated as 5. Python 2.x differs from Python 3.x

5.1 Not compatible

3??. of Python Version 0, often referred to as Python 3000, or simply py3k. This is a large upgrade relative to earlier versions of Python.

In order not to take in too much of a burden, Python 3.0 did not consider downward compatibility when designing.

Many of the programs designed for early Python versions are not performing properly on Python 3.0.

To take care of the existing program, Python 2.6, as a transitional version, basically uses the syntax and library of Python 2.x, taking into account the migration to Python 3.0, allowing the use of some of the syntax and functions of Python 3.0.

5.2 A picture wins thousand words

the difference between Python2 and Python3

You can upgrade your own version of Python, it is recommended to adopt Python3 directly, after all it is a trend. Using the 2to3 tool is also a good choice.

6. Written in the last

This article simply accepted the Python database link, GUI, Cui's simple programming, finally introduced briefly the difference between Python2 and Python3, welcome everybody to exchange.

a promising Python

"Python database GUI CGI Programming"