Input from html to mysql using flask; only accepts single character inputs

Question

So I am using Flask to pass an input from html to a mysql db. However it only works for single characters ie can only input "5" and "a", however it cannot input "55" or "at". Here is my code.

__init__.py :
@app.route('/statistics',methods=['GET','POST'])
def statsinput():
        if request.method=='GET':
                return render_template("statsinput.html")
        else:
                first_name=(request.form['fname'])
                c, conn = connection()
                query="INSERT INTO test VALUES(%s)"
                c.execute(query,first_name)
                conn.commit()
                return ('working')

statsinput.html:
<!DOCTYPE html>
<html>
   <body>
    <form method="POST">
      First name: <input type="text" name="fname"><br>
      <input type="submit" value="Submit">
    </form>
  </body>
</html>

Here is the description for my mysql table:
mysql> DESCRIBE test;
 +--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| ticker | char(50) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+

Raja Simon · Accepted Answer · 2017-05-29 14:57:00Z

1

Insert correctly in the query string.

query="INSERT INTO test VALUES({})".format(first_name)
c.execute(query)

answered May 29, 2017 at 14:57

Raja Simon

10.3k5 gold badges46 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Raja Simon Over a year ago

@GuyMowbray What is doesn't work. This will work sure.

Guy Mowbray Over a year ago

unfortunately not, dont know whats wrong with it; ive tried to follow instructions from this (stackoverflow.com/questions/42662502/…)

Collectives™ on Stack Overflow

Input from html to mysql using flask; only accepts single character inputs

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related