def getRecentBookings()
    connection = mysql.connector.connect(host='localhost',
                              database='webtravel',
                              user='root',
                              password='')
    cursor = connection.cursor()

    customerID = []
    transportID = []
    departID = []
    adults = []
    children = []
    travelDate = []

    customerFname = []
    customerLname = []

    departureLocID = []
    arriveLocID = []

    departureLoc = []
    arriveLoc = []
    departTime = []
    arriveTime = []
    cursor.execute("SELECT * FROM booking LIMIT 10")
    rows = cursor.fetchall()
    for row in rows:
        customerID.append(row[1])
        transportID.append(row[2])
        departID.append(row[3])
        adults.append(row[4])
        children.append(row[5])
        travelDate.append(row[6])

    for custID in customerID:
        cursor.execute("SELECT * FROM customer WHERE id='%d'" % customerID[custID])
        rows = cursor.fetchall()
        for row in rows:
            customerFname.append(row[1])
            customerLname.append(row[2])
    for deptID in departID:
        cursor.execute("SELECT * FROM departure WHERE id='%d'" % departID[deptID])
        rows = cursor.fetchall()
        for row in rows:
            departureLocID.append(row[1])
            arriveLocID.append(row[2])
            departTime.append(row[3])
            arriveTime.append(row[4])
    for locID in departureLocID:
        cursor.execute("SELECT * FROM location WHERE id='%d'" % departureLocID[locID])
        rows = cursor.fetchall()
        for row in rows:
            departureLoc.append(row[1])
    for locID in arriveLocID:
        cursor.execute("SELECT * FROM location WHERE id='%d'" % arriveLocID[locID])
        rows = cursor.fetchall()
        for row in rows:
            arriveLoc.append(row[1])
    return customerFname, customerLname, departureLoc, arriveLoc, departTime, arriveTime, adults, children, travelDate

def getPermission(id):

    #get permission from ID.
    connection = mysql.connector.connect(host='localhost',
                              database='webtravel',
                              user='root',
                              password='')
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM customer WHERE id='%d' AND permission='1'" % id)
    rows = cursor.fetchall()
    for row in rows:
        #Use to check like a boolean.
        if (row[7] == 0):
            return 0
        else:
            return 1