Abituriyentlar ma'lumotlarini yuritish ma'lumotlar bazasi yaratish
![ILOVALAR
Ilova 1. Dastur kodining asosiy qismi (Python + Flask)
from flask import Flask, render_template, request, redirect
import sqlite3
app = Flask(__name__)
@app.route('/')
def index():
con = sqlite3.connect("abituriyentlar.db")
con.row_factory = sqlite3.Row
cur = con.cursor()
cur.execute("SELECT * FROM abituriyent")
rows = cur.fetchall()
con.close()
return render_template("index.html", rows=rows)
@app.route("/add", methods=["POST"])
def add():
ism = request.form["ism"]
familiya = request.form["familiya"]
yonalish = request.form["yonalish"]
con = sqlite3.connect("abituriyentlar.db")
cur = con.cursor()
cur.execute("INSERT INTO abituriyent (ism, familiya, yonalish) VALUES (?, ?,
?)", (ism, familiya, yonalish))
con.commit()
con.close()
18](https://docx.uz/documents/1786be47-e332-466a-aa04-c577c8583929/page_18.png?v=1)
Abituriyentlar ma'lumotlarini yuritish ma'lumotlar bazasi yaratish