server.py

from flask import Flask, render_template, request
import MySQLdb, MySQLdb.cursors 
import utils

app = Flask(__name__)
	

@app.route('/')
def mainIndex():
    return render_template('index.html', selected='Home')

#@app.route('/review.html')
#def review():
#    return render_template('review.html')

#@app.route('/submit', methods=['POST'])
#def submit():
#    r = {'Food': request.form['Food'],
#               'Location': request.form['Location'],
#               'Number': request.form['Number'],
#               'Description': request.form['Description']} 
#    db = utils.db_connect()
#    cur = db.cursor()
#    query = 'INSERT INTO reviews VALUES (\'' + r['Food'] + '\',\'' + r['Location'] + '\',' + r['Number'] + ',\'' + r['Description'] + '\');'
#    cur.execute(query)
#    db.commit()
#    query = 'SELECT * from reviews'
#    cur.execute(query)
#    rows = cur.fetchall()
#    return render_template('reviews.html', reviews=rows, selectedMenu='Reviews')


@app.route('/reviews.html')
def reviews():
    db = utils.db_connect()
    cur = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
    query = 'SELECT * FROM reviewView'
    cur.execute(query)
    rows = cur.fetchall()
    return render_template('reviews.html', reviews=rows, selectedMenu='Reviews')

@app.route('/locations.html')
def locations():
    db = utils.db_connect()
    cur = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
    query = 'SELECT name, description, image FROM locations WHERE name <> \'Home Team\''
    cur.execute(query)
    rows = cur.fetchall()
    return render_template('locations.html', locations=rows, selectedMenu='Locations')

@app.route('/foods.html') #need to change to foods!!
def foods():
    db = utils.db_connect()
    cur = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
    query = 'SELECT f.name Food, f.description Descriptions, l.name Location from foods f inner join food_location fl on fl.foodkey = f.foodkey inner join locations l on fl.locationkey = l.locationkey'
    cur.execute(query)
    rows = cur.fetchall()
    print rows
    return render_template('foods.html', foods=rows, selectedMenu='Foods')


@app.route('/contact.html')
def contact():
    return render_template('contact.html', selectedMenu='Contact Us')

@app.route('/future.html')
def future():
    return render_template('future.html', selectedMenu='Future Plans')
  
if __name__ == '__main__':
  app.debug=True
  app.run(host='0.0.0.0', port=3000)