practPythonApache/index.py - main - alesu1543/practPythonServ

practPythonApache/index.py
58 строк2 KB
Alexey Subbotin
app dop
21 май 2023, 08:46
21 май 2023, 08:466e7fc67
#! C:/Users/alex/AppData/Local/Programs/Python/Python310/python.exe

# работа с базой данных MySQL через mysql.connector.
import mysql.connector
myconn = mysql.connector.connect(host = '127.0.0.1', port = '3306', user = 'root', passwd = '', db = 'test', charset='utf8', use_unicode = True)
cur = myconn.cursor()
cur.execute("SET NAMES utf8")
cur.execute("USE test")

import os
query_string = os.environ['QUERY_STRING']
if 'col1' in query_string:
    import urllib.parse
    d = urllib.parse.parse_qs(query_string)
    col1 = d.get('col1', [''])[0]
    col2 = d.get('col2', [''])[0]
    col3 = d.get('col3', [''])[0]
    sql = "INSERT INTO myarttable (text, description, keywords) VALUES ('"+col1+"', '"+col2+"', '"+col3+"')"
    cur.execute(sql)
    myconn.commit()
    
# формирование файла для отправки в браузер.
file_out = open("out.html", "w")

with open('select.html') as file:
    for line in file:
    
        if ("@tr" not in line) and ("@ver" not in line):
            file_out.write(line)

        if ("@tr" in line):
            # формирование заголовка таблицы.
            cur.execute("SHOW COLUMNS FROM myarttable")
            file_out.write("<table><tr>")
            result = cur.fetchall()
            for line in result:
                file_out.write('<td>'+str(line[0])+'</td>')
            file_out.write("</tr>")
            # формирование строк таблицы.
            cur.execute("SELECT * FROM myarttable WHERE id>14 ORDER BY id DESC")
            result = cur.fetchall()
            for row in result:
                file_out.write("<tr>")
                for cell in row:
                    sCellNew = str(str(cell).strip().encode('utf-8'), 'cp1251')
                    file_out.write("<td>"+sCellNew+"</td>")
                file_out.write("</tr>")

        if ("@ver" in line):
            cur.execute("SELECT VERSION() AS ver")
            result = cur.fetchall()
            file_out.write(str(result[0][0]))
file_out.close()

print("Content-Type: text/html\n")
with open('out.html') as file:
    for line in file:
        print(line.rstrip())