from flask import Flask, session, redirect, url_for, request

app = Flask(__name__)

app.secret_key = 'your_secret_key'

@app.route('/')

def home():

if 'username' in session:

return f'Logged in as {session["username"]}'

return 'You are not logged in'

@app.route('/login', methods=['GET', 'POST'])

def login():

if request.method == 'POST':

session['username'] = request.form['username']

return redirect(url_for('home'))

return '''

'''

@app.route('/logout')

def logout():

輔導(dǎo)班排課軟件

session.pop('username', None)

return redirect(url_for('home'))

if __name__ == '__main__':

app.run(debug=True)

]]>

CREATE TABLE bids (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(255),

bid_amount DECIMAL(10, 2),

timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

]]>

SELECT username, bid_amount FROM bids ORDER BY bid_amount DESC LIMIT 10;

]]>