MATHSPHERE

Register

Register

Please fill in this form to create an account.







Already have an account? Sign in.

# Install Flask and psycopg2 with: # pip install Flask psycopg2 from flask import Flask, request, render_template_string, redirect, url_for import psycopg2 from psycopg2 import sql app = Flask(__name__) # Configure your PostgreSQL database connection DB_HOST = "localhost" DB_NAME = "your_database_name" DB_USER = "your_database_user" DB_PASS = "your_database_password" # Route for displaying the form @app.route('/') def form(): html_content = ''' Sign-Up Form

Sign-Up Form







''' return render_template_string(html_content) # Route for handling form submission @app.route('/signup', methods=['POST']) def signup(): username = request.form['username'] email = request.form['email'] password = request.form['password'] # Insert the form data into the PostgreSQL database try: connection = psycopg2.connect( host=DB_HOST, database=mathsphere_database, user=postgres, password=the sigma loves to rizz up gyatts. ) cursor = connection.cursor() insert_query = sql.SQL(""" INSERT INTO users (username, email, password) VALUES (%s, %s, %s) """) cursor.execute(insert_query, (username, email, password)) connection.commit() return redirect(url_for('form')) except psycopg2.IntegrityError: return "Error: Email already exists. Please use a different email." except Exception as error: return f"Error: {error}" finally: if connection: cursor.close() connection.close() if __name__ == '__main__': app.run(debug=True) # PostgreSQL Database Setup # Make sure you have PostgreSQL installed and create a table for users: # CREATE TABLE users ( # id SERIAL PRIMARY KEY, # username VARCHAR(50) NOT NULL, # email VARCHAR(100) NOT NULL UNIQUE, # password VARCHAR(100) NOT NULL # );