Insert into mysql flask how to#

route( '/projectreg' ,methods = ) def projectreg (): msg = '' #applying empty validation if request. config = 'projectreporting' #database name mysql = MySQL(app). config = '' #password #in my case password is null so i am keeping empty app. #import libraries from flask import Flask, render_template, request from flask_mysqldb import MySQL import MySQLdb.cursors app = Flask(_name_) #code for connection app. F ollowing is the query of creating ' ProjectReporting' database in MySQL If you want to create database using query then copy the code below. Open your MySQL and create a database ' ProjectReporting' or you can any name for database.

Insert into mysql flask how to#

Run HTML Page in Python įirst of all i am going to tell you how to create database and table inside the database. If you don't know how to run HTML page in Python using Flask then first visit the below link first. Now i am going to explain this one by one so to get complete knowledge just go through this post step by step. This is not compulsory for you to use Pycharm IDE and Wamp Server for MySQL, you can use any other IDE or application that support Python and MySQL, But i will suggest you to use these because i these application are very easy in use. Here i am using Pycharm IDE for python and Wamp Server for MySQL Database to create this particular page of registration. I will also make a post on How to create a website in Django using Python in next post.

If You want to create a project or Website in Python then this post will help you definitely.įlask is a popular web Framework which is used to create website using Python code and We can also use Django framework to create a website in Python. Here i will use Flask Web Framework for doing this. Hello friends how are you, Today in this blog i will teach you how to store data in MySQL using Python.