#!/usr/bin/env python3
import matplotlib.pyplot as plt,cgi,pymysql
form=cgi.FieldStorage()
print("Content-type:text/html\n")
print("""
<form action="python.py" method=post>
name <input type=text name=name><br>
age <input type=text name=age><br>
<input type=submit value=send>
</form>
""")
name=form.getfirst("name","")
age=form.getfirst("age","")
con=pymysql.connect(host='127.0.0.1',
user='root',
password='',
db='test',
cursorclass=pymysql.cursors.DictCursor)
with con.cursor() as cur:
sql="insert into users (name,age) values('"+name+"','"+age+"')"
cur.execute(sql)
con.commit()
sql="select * from users"
cur.execute(sql)
sotr=[];vozr=[]
print("<table border=1>")
for row in cur:
print("<tr><td>",row['name'],"</td><td>",row['age'],"</td></tr>")
sotr.append(row['name'])
vozr.append(row['age'])
print("</table>")
plt.bar(sotr,vozr)
plt.title("People")
plt.xlabel("Employee")
plt.ylabel("Age")
plt.savefig("sotr.png")
print("<img src='../sotr.png' width=100>")
con.close()
Сообщение отредактировал zavuch: 06.11.2021, 01:33:00