Muxammad al-xorazmiy nomidagi toshkent axborot texnologiyalari universiteti urganch

return redirect(url_for('customers'))
cur = mysql.connection.cursor()
cur.execute("DELETE FROM `customers` WHERE id=%s", (idn))
mysql.connection.commit()
flash("Ma'lumot muvaffaqiyatli o'chirildi")
return redirect(url_for('customers'))


@app.route('/products', methods=['POST','GET'])
def products() :
cur=mysql.connection.cursor()
sql="SELECT * FROM `types`"
cur.execute(sql)
types = cur.fetchall()
if request.method=="POST" :
cur = mysql.connection.cursor()
search=request.form['search']
sql="SELECT ice_cream.id, ice_cream.name, ice_cream.price,types.type FROM ice_cream INNER JOIN types ON ice_cream.type_id=types.id WHERE `ice_cream`.`name` LIKE '%"+search+"%' OR `types`.`type` LIKE '%"+search+"%' ORDER BY ice_cream.id ASC"
cur.execute(sql)
data=cur.fetchall()
cur.close()
return render_template('products.html',products=data,types=types)
cur=mysql.connection.cursor()
sql="SELECT ice_cream.id, ice_cream.name, ice_cream.price,types.type FROM ice_cream INNER JOIN types ON ice_cream.type_id=types.id ORDER BY ice_cream.id ASC;"
cur.execute(sql)
data = cur.fetchall()
cur.close()
return render_template('products.html',products=data,types=types)


@app.route('/products/insert_type', methods = ['POST'])
def add_type():
if request.method == "POST":
data = request.form['name']
cur = mysql.connection.cursor()
cur.execute("INSERT INTO `types` (id, type) VALUES (%s, %s)", ('NULL',data))
mysql.connection.commit()
cur.close()
flash("Ma'lumotlar muvaffaqiyatli kiritildi")
return redirect(url_for('products'))