Just follow these links and few more steps:
Then enable design view, this is really useful
http://debian.sreenadh.in/2008/11/28/how-to-enable-designer-in-phpmyadmin/
Now you can setup python for apache2:
http://www.howtoforge.com/embedding-python-in-apache2-with-mod_python-debian-etch
don't forget to install python-mysqldb
apt-get install python-mysqldb
restart apache:
/etc/init.d/apache2 restart
Now let's try a small db connection:
agonzalez@kozlex:~/django-dev$ cat /var/www/test4.py
#!/usr/bin/python
import MySQLdb
# enable debugging
import cgitb
cgitb.enable()
print "Content-Type: text/plain;charset=utf-8"
print "Hello World!"
# connect
mydb = MySQLdb.connect(host="127.0.0.1", user="root", passwd="root",
db="tdb")
cursor = mydb.cursor()
# execute SQL select statement
cursor.execute("SELECT * FROM test")
# get the number of rows in the resultset
numrows = int(cursor.rowcount)
# get and display one row at a time.
for x in range(0,numrows):
row = cursor.fetchone()
print (row[0], "-->", row[1])
def index(req):
return row[1];
agonzalez@kozlex:~/django-dev$
That should work although the prints are not shown!
P.D. Libya flag is the only country flag with single color and no design.
