Muxammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti urganch

Dasturiy ta'minot arxitekturasi
Ma'lumotlarni o'zgartirish
Zaxiralash usullari va dasturiy ta'minot bitta mahsulot ustida
ishlayotgan bo'lishiga qaramay, juda aniq ko'nikmalar to'plamiga ega bo'linadi.

Flask kodi:
from flask import Flask, render_template, request, url_for, flash
from werkzeug.utils import redirect
from flask_mysqldb import MySQL
import datetime
app = Flask(__name__)
app.secret_key = 'mykey'


app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'root'
app.config['MYSQL_DB'] = 'icedb'


mysql = MySQL(app)


@app.route('/')
def index():
cur = mysql.connection.cursor()
cur.execute("SELECT (SELECT COUNT(id) FROM employees) AS `emp`, (SELECT COUNT(id) FROM customers) AS `cust`, (SELECT COUNT(id) FROM ice_cream) AS `ice` , (SELECT COUNT(id) FROM sales) AS `sales`")
info = cur.fetchone()
cur.close()
return render_template('index.html', info=info)


@app.route('/employees', methods=['POST','GET'])
def employees() :
if request.method=="POST" :
cur = mysql.connection.cursor()
search=request.form['search']
sql="SELECT * FROM `employees` WHERE `name` LIKE '%"+search+"%' OR `address` LIKE '"+search+"'"
cur.execute(sql)
data=cur.fetchall()
cur.close()
return render_template('employees.html',employees=data)


cur=mysql.connection.cursor()
sql="SELECT * FROM `employees`"
cur.execute(sql)
data = cur.fetchall()
cur.close()
return render_template('employees.html',employees=data)