Add files via upload

gokulcoder7 · web-flow · commit c846ae16e505 · 2025-01-15T22:03:28.000+05:30
diff --git a/PythonProject/app.py b/PythonProject/app.py
@@ -0,0 +1,100 @@
+from flask import Flask, request, render_template, redirect, url_for
+import mysql.connector as ms
+
+app = Flask(__name__)
+
+# Create a connection to the database
+def get_db_connection():
+    print('to be Connected....')
+    try:
+        conn = ms.connect(user='root',password='pwd',host='localhost',database='python01')
+        print('Connected....')
+        return conn
+    except ms.Error as err:
+        print('Error:',err)
+        return None
+
+
+
+# Initialize the database
+def init_db():
+    conn = get_db_connection()
+    mycursor = conn.cursor()
+    mycursor.execute('select * from users;')
+    res=mycursor.fetchall()
+    for user in res:
+        print(user)
+
+    conn.close()
+
+init_db()
+
+# Route for the home page with the form
+@app.route('/', methods=('GET', 'POST'))
+def index():
+    print("esfawsf",request.form)
+    print("method", request.method)
+    if request.method == 'POST':
+        name = request.form['name']
+        email = request.form['email']
+        #dob = request.form['dateofbirth']
+        dob='2024-10-16'
+
+
+
+
+
+        # Insert the data into the database
+        conn = get_db_connection()
+        mycursor = conn.cursor()
+
+
+        mycursor.execute("SELECT count(username) from users where username='"+name+"'")
+        x=mycursor.fetchone()
+
+        print("count=",x[0])
+        if(x[0]>=1):
+            print("user already exists")
+            return redirect(url_for('already'))
+
+
+
+
+        mycursor.execute("INSERT INTO users(username, email,dob,status) VALUES (%s,%s, %s,'Active')", (name, email,dob))
+        conn.commit()
+        mycursor.close()
+       # conn.commit()
+        conn.close()
+
+        return redirect(url_for('userlist'))
+    else:
+        return render_template('index.html')
+
+
+# Route to display success message
+@app.route('/success')
+def success():
+    return 'Data successfully submitted!'
+
+
+
+@app.route('/already')
+def already():
+    return 'user already exists!'
+
+
+# Route to display success message
+@app.route('/userlist')
+def userlist():
+    conn = get_db_connection()
+    mycursor = conn.cursor()
+    mycursor.execute('select * from users;')
+    users = mycursor.fetchall()
+
+    mycursor.close()
+    # conn.commit()
+    conn.close()
+    return render_template('userlist.html',users=users)
+
+if __name__ == '__main__':
+    app.run()
diff --git a/PythonProject/form.py b/PythonProject/form.py
@@ -0,0 +1,38 @@
+from flask import Flask, render_template, request
+import sqlite3
+
+app = Flask(__name__)
+
+# Database setup (creates the table if it doesn't exist)
+conn = sqlite3.connect('mydatabase.db')  # Replace 'mydatabase.db' with your desired name
+cursor = conn.cursor()
+cursor.execute('''
+    CREATE TABLE IF NOT EXISTS entries (
+        id INTEGER PRIMARY KEY AUTOINCREMENT,
+        name TEXT,
+        email TEXT
+    )
+''')
+conn.commit()
+conn.close()
+
+
+@app.route('/', methods=['GET', 'POST'])
+def index():
+    if request.method == 'POST':
+        name = request.form['name']
+        email = request.form['email']
+
+        conn = sqlite3.connect('mydatabase.db')
+        cursor = conn.cursor()
+        cursor.execute("INSERT INTO entries (name, email) VALUES (?, ?)", (name, email))
+        conn.commit()
+        conn.close()
+
+        return "Data submitted successfully!"  # You might want a more sophisticated response
+
+    return render_template('form.html')
+
+
+if __name__ == '__main__':
+    app.run(debug=True)
diff --git a/PythonProject/main.py b/PythonProject/main.py
@@ -0,0 +1,16 @@
+# This is a sample Python script.
+
+# Press Shift+F10 to execute it or replace it with your code.
+# Press Double Shift to search everywhere for classes, files, tool windows, actions, and settings.
+
+
+def print_hi(name):
+    # Use a breakpoint in the code line below to debug your script.
+    print(f'Hi, {name}')  # Press Ctrl+F8 to toggle the breakpoint.
+
+
+# Press the green button in the gutter to run the script.
+if __name__ == '__main__':
+    print_hi('PyCharm')
+
+# See PyCharm help at https://www.jetbrains.com/help/pycharm/
diff --git a/PythonProject/templates/index.html b/PythonProject/templates/index.html
@@ -0,0 +1,21 @@
+<!doctype html>
+<html>
+<head>
+    <meta charset="utf-8">
+    <title>Submit Form</title>
+</head>
+<body>
+    <h1>Submit Your Information</h1>
+    <form method="POST" action="{{ url_for('index') }}">
+
+        <label for="name">Name:</label><br>
+        <input type="text" id="name" name="name" required><br>
+        <label for="email">Email:</label><br>
+        <input type="email" id="email" name="email"><br><br>
+
+        <button type="submit"> submit it</button>
+
+<!--        <input type="submit" value="Submit">-->
+    </form>
+</body>
+</html>
diff --git a/PythonProject/templates/userlist.html b/PythonProject/templates/userlist.html
@@ -0,0 +1,23 @@
+<!DOCTYPE html>
+<html>
+<body>
+<table border="1">
+  <tr>
+    <th>Name</th>
+    <th>Emmail</th>
+    <th>Date of Birth</th>
+      <th>Status</th>
+  </tr>
+     {% for user in users %}
+  <tr>
+          <td>{{user[1]}}</td>
+    <td>{{user[5]}}</td>
+    <td>{{user[3]}}</td>
+       <td>{{user[4]}}</td>
+  </tr>
+      {% endfor %}
+
+
+ </table>
+</body>
+</html>
