CREATE DATABASE alumni_platform;
USE alumni_platform;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
password_hash VARCHAR(255) NOT NULL,
graduation_year YEAR,
major VARCHAR(100),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
]]>
import mysql.connector
def register_user(name, email, password, grad_year, major):
try:
conn = mysql.connector.connect(
host="localhost",
user="root",
password="yourpassword",
database="alumni_platform"
)
cursor = conn.cursor()
query = "INSERT INTO users (name, email, password_hash, graduation_year, major) VALUES (%s, %s, %s, %s, %s)"
cursor.execute(query, (name, email, password, grad_year, major))
conn.commit()
print("User registered successfully!")
except Exception as e:
print(f"Error: {e}")
finally:
cursor.close()
conn.close()
# Example usage
register_user("John Doe", "johndoe@example.com", "hashedpassword", 2020, "Computer Science")
]]>