🌐 Versi Web (Flask)
1. Instalasi
pip install flask flask_sqlalchemy
3. File app.py
from flask import Flask, render_template, request, redirect
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.db'
db = SQLAlchemy(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
email = db.Column(db.String(100))
with app.app_context():
db.create_all()
@app.route('/')
def index():
users = User.query.all()
return render_template('index.html', users=users)
@app.route('/add', methods=['POST'])
def add_user():
name = request.form['name']
email = request.form['email']
new_user = User(name=name, email=email)
db.session.add(new_user)
db.session.commit()
return redirect('/')
@app.route('/delete/')
def delete_user(id):
user = User.query.get(id)
db.session.delete(user)
db.session.commit()
return redirect('/')
if __name__ == '__main__':
app.run(debug=True)
4. File templates/index.html
<!DOCTYPE html>
<html lang="id">
<head>
<meta charset="UTF-8">
<title>Aplikasi Web Database Python (Flask)</title>
<style>
body { font-family: Arial; background: #f7f7f7; margin: 40px; }
table { border-collapse: collapse; width: 100%; background: white; }
th, td { padding: 10px; border: 1px solid #ccc; text-align: left; }
form { margin-bottom: 20px; }
input { padding: 6px; margin-right: 10px; }
button { padding: 6px 12px; cursor: pointer; }
</style>
</head>
<body>
<h2>Aplikasi Web Database Python (Flask)</h2>
<form action="/add" method="post">
<input type="text" name="name" placeholder="Nama" required>
<input type="email" name="email" placeholder="Email" required>
<button type="submit">Tambah</button>
</form>
<table>
<tr><th>ID</th><th>Nama</th><th>Email</th><th>Aksi</th></tr>
{% for user in users %}
<tr>
<td>{{ user.id }}</td>
<td>{{ user.name }}</td>
<td>{{ user.email }}</td>
<td><a href="/delete/{{ user.id }}">Hapus</a></td>
</tr>
{% endfor %}
</table>
</body>
</html>
