#!/usr/bin/python 
 
import cgi 
 
# print content type 
print "Content-Type:text/html\n" 

if variable: 
 
#conditionals 

# username is a string, so you can do this two ways 
# (though the second is better, in my opinion) 
print "Hello, " + username 
print "Hello, %s" % username 
 
# userid is an integer type, so you have to explicitly 
# convert it to a string before you can treat it as string 
print "Your user ID is: " + str(userid) 
print "Your user ID is: %s" % userid 

"Hello, %s, your user ID is %d. Welcome to %s!" % (username, userid, website_name) 

"My name is %(first)s %(last)s" %{'first':'John', 'last':'Doe'} 

if rank == admin: 
    print "Welcome to the Admin CP" 
else: 
    "Kindly leave." 

while count < 100: 
    print count 
    count += 1 

try: import cPickle as pickle 
except ImportError: import pickle 
 
# also... 
if not userid: print "Please log in" 
else: print "Welcome!" 

import sys, MySQLdb 
 
# first connect to the db 
try: 
    connection = MySQLdb.connect( 
        host = "localhost", 
        port = 3306, # default MySQL port, can be ommited 
        user = "user", 
        passwd = "pass", 
        db = "database_name", 
    ) 
# handle any errors connecting 
except MySQLdb.Error, e: 
    print "Error %d: %s" % (e.args[0], e.args[1]) 
    sys.exit(1) 
 
# create a database cursor and run a query 
cursor = connection.cursor(MySQLdb.cursors.DictCursor) 
cursor.execute(""" 
    SELECT comment.*, user.username, user.rank 
    FROM comments AS comment 
    LEFT JOIN users AS user ON (user.userid = comment.author) 
    WHERE comment.section = %s 
    LIMIT 20 
""", (comment_section,)) 
 
# fetch resulting rows 
rows = cursor.fetchall() 
 
# loop through the rows and print the contents of the comment 
for comment in rows: 
    print comment["contents"] 
    print "<br />" 
 
# close the cursor and connection when done 
cursor.close() 
connection.close() 

import Electron.db 
 
comments = db.query_read(""" 
    SELECT comment.*, user.username, user.rank 
    FROM comments AS comment 
    LEFT JOIN users AS user ON (user.userid = comment.author) 
    WHERE comment.section = %s 
    LIMIT 20 
""", (comment_section,)) 
 
for comment in comments: 
    print comment["contents"] 
    print "<br />" 

#!/usr/bin/python 
 
print "Content-Type: text/html\n" 
 
import MySQLdb, sys 
 
correct = 5 
 
name = "Peter" 
 
if correct == 5: 
    # first connect to the db  
    try:  
    connection = MySQLdb.connect(  
    host = "mysql.aiirodesign.com",  
    port = 3306, # default MySQL port, can be ommited  
    user = "heheusername",  
    passwd = "********",  
    db = "aiiro_islanddocks_sql", 
    ) 
    # handle any errors connecting  
    except MySQLdb.Error, e:  
    print "Error %d: %s" % (e.args[0], e.args[1])  
    sys.exit(1)  
 
    # create a database cursor and run a query  
    cursor = connection.cursor(MySQLdb.cursors.DictCursor)  
    cursor.execute("""  
    INSERT INTO quiz1 (name) values(%s) 
    """, % name ) 
 
    # close the cursor and connection when done  
    cursor.close()  
    connection.close() 
    print "omg" 

#!/usr/bin/python 
 
import MySQLdb 
 
print "Content-Type: text/html\n\n" 
 
correct = 5  
name = 'Peter' 
 
if correct == 5:  
    # first connect to the db   
    try:   
        cursor = MySQLdb.connect(host = "***",   
            user = "***", passwd = "***", 
            db = "***").cursor() 
    # handle any errors connecting 
    except MySQLdb.Error, e:   
        exit('Error %d: %s' % (e.args[0], e.args[1])) 
  
    # create a database cursor and run a query   
    cursor.execute('INSERT INTO quiz1 (name) values(%s)', name) 
    cursor.close() 
    print "omg"