时间戳

首页 > 解决方案 > 我在代码中做错了什么，通过 Flask 应用程序向 MySQL 提交表单值？

python - 我在代码中做错了什么，通过 Flask 应用程序向 MySQL 提交表单值？

问题描述

我正在尝试考虑表单输入来生成随机代码，例如用户想要生成的随机代码的数量。然后将这些数据添加到 MySQL 表中。

这是HTML：

<HTML>
<BODY bgcolor="cyan">
<form method="POST" action="">
    <center>
    <H1>Enter your details </H1> <br>
    Code-Attribute (eg. itsa19) <input type = "text" name= "code_attribute" /> <br>
    Max Usage <input type = "number" name = "max_usage" /> <br>
    Max No of Users <input type = "number" name = "users" /> <br>
    Data Volume (in GB) <input type = "number" name = "data_volume" /> <br>
    How many codes you want to create? <input type = "number" name = "number_of_codes" /> <br>
    <input type="submit" value="Upload code in Database">
    </center>
</form>
</BODY>
</HTML>

烧瓶应用程序将获取这些数据，并将随机代码附加到代码属性。然后它执行游标将数据插入表中。

这是烧瓶应用程序：

from flask import Flask, render_template, request
from flask_mysqldb import MySQL
app = Flask(__name__)


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

mysql = MySQL(app)


@app.route('/', methods=['GET', 'POST'])
def index():
    if request.method == "POST":  // Gets the form inputs
        details = request.form
        AttributeCode = details['code_attribute']
        MaxUsage = details['max_usage']
        NumberOfUsers= details['users']
        UsageVol = details['data_volume']  
        NumberOfCodes = details['number_of_codes']

    import string 
    import random

    def random_numbers():    // Generate Random Codes (Column 1)
            N = 7
            res = ''.join(random.choices(string.ascii_lowercase +
                             string.digits, k = N)) 

            prefix = AttributeCode
            DiscountCode = prefix + res
            columns = [MaxUsage, NumberOfUsers, UsageVol]
            randoms.append(DiscountCode)     // appends column values
            randoms.extend(columns)   
            cur = mysql.connection.cursor()
            cur.execute("INSERT INTO discount_codes(codes, max_usage, users, data_volume) VALUES (%s, %s, %s, %s)", (randoms[0],randoms[1],randoms[2],randoms[3]))  # I have also tried puting ('TestCode', 2 ,3 ,4)
            mysql.connection.commit()
            cur.close()

        for _ in range(NumberOfCodes):
            random_numbers()   
        return 'success'

    return render_template('index.html')


if __name__ == '__main__':
    app.run()

请帮忙。提前致谢。

标签： pythonmysqlflask

解决方案

推荐阅读