#Insert into mysql flask code#

#Insert into mysql flask code#

query = 'select * from tbl_user where user_email = %s'ĭebugging the code with print statements in console: for what is worth, I've a also tried printing the values like shown below and nothing will print in my console.which seems very strange to me. query = 'insert into tbl_user (user_name,user_username,user_password,user_email) values (%s,%s,%s,%s)'Ī simple query with 1 parameter: In the code below, works fine with the parameter and it returns the expected results, so I am confused why the other query is not working. Ok I am trying to insert a new row into an existing mysql database table using a restful API application based on Flask and sqlalchemy. When I use parameters it does not work, but when I use harcoded values it does.

We then create a new cursor, by default a MySQLCursor. Hardcoded values work.The specific problem I am having is with this query. We first open a connection to the MySQL server and store the connection object in the variable cnx. Query = 'insert into tbl_user (user_name,user_username,user_password,user_email) values (%s,%s,%s,%s)'Ĭursor.execute(query, (_name, _username, _hashed_password, _email)) _hashed_password = generate_password_hash(_password) Query = 'select * from tbl_user where user_email = %s' If _name and _email and _password and _username: Here is my app.py code: from flask import Flask, render_template, request, jsonįrom werkzeug import generate_password_hash, check_password_hashĪpp.config = configĪpp.config = main(): I am not having much success when using parameterized queries.

I am trying to build a sign up form with Flask and trying to submit the user entries to MySQL database. def insert (data): crsr getcursor () executeandlog ( crsr, ''' INSERT INTO Table1 ( Id, column2, column3, column4, column5, column6 ) VALUES (,, ,, ,, ,, ,, ) ''', data 'Id', data 'column2', data 'column3', data 'column4', data 'column5', data 'column6', ) executeandlog ( crsr, '''.