Skip to main content

Python Flask tutorial Setting up a Flask and SQL Database Connection

Image
By

 

In this tutorial, we are going to learn how to Python Flask tutorial Setting up a Flask and SQL Database Connection and how to use templates for HTML pages to show the fetch data in the SQL server database.

Python Flask tutorial

First of all, we need to install flask and it's too simple to install just "pip install flask" once on your terminal on pycharm or any code editor on your computer, and here am using pycharm.
 

Setting up a Flask



pip install flask


ok, once the flask is installed, let's check the flask is installed correctly. just type "flask --version" it shows the version on the terminal.

Let's make to create a file named main.py and call the flask application "from flask import Flask" and "app = Flask(__name__)" and test the flask with some example code like "hello world".

ok, Let's run the flask using terminals like "set FLASK_APP = file_name" and here, "set FLASK_APP = main.py". And "flask run".

so, if that worked and you don't have any errors the should see this message that the serving link of the flask app on http://127.0.0.1:5000/ on your local machine with the port number. 


set FLASK_APP=main.py




set FLASK_DEBUG=1




  flask run


Python Flask tutorial


Just copy the URL link and paste it into your browser to run the flask application.

ok, Now you will see the output of "hello world" on your browser and know we will be learning how to use templates to return more on HTML code with this sample script and function and route.

we need to create a templates directory within our project folder and right-click on my project and create a new folder and name templates in lowercase and create an HTML file template for the home page. 
 

Here, I am taking the bootstrap framework for the template and copying, paste the actual use of the HTML codes. 

Now, back to the main.py and add render_template top of the import flask like "from flask import Flask, render_template" and return render_template serving up on HTML file.

Python Flask - Use Templates for HTML pages



from flask import Flask




app = Flask(__name__)


@app.route("/")
@app.route("/home")
def home_page():
    items= [{'id': 1, 'name' : 'priya' , 'class': 'six'}
           ,{'id': 2, 'name' : 'ramesh' , 'class': 'six'}]
    return render_template('home.html', items=items)




<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">

    <title>Python Tutorials</title>
  </head>
  <body>
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark">
  <div class="container-fluid">
    <a class="navbar-brand" href="#">Dailyaspirants</a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarSupportedContent">
      <ul class="navbar-nav ms-auto mb-2 mb-lg-0">
        <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Home</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Gallery</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">About us</a>
        </li>
         <li class="nav-item">
          <button class="btn btn-primary" aria-current="page" href="#">Login</button>
        </li>
      </ul>
    </div>
  </div>
</nav>
  <div class="container py-5">
   {{items}}
  
  </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>
  </body>
</html>


Python Flask tutorial



<table class="table table-dark">
  <thead>
    <tr>
      <th scope="col">Id</th>
      <th scope="col">Name</th>
      <th scope="col">Class</th>
    </tr>
  </thead>
  <tbody>
     
    {% for i in items %}
    <tr scopr="row">
      <td>{{i.id}}</td>
      <td>{{i.name}}</td>
      <td>{{i.class}}</td>
    </tr>
  {% endfor %}</p>
  </tbody>
</table>





<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">

    <title>Python Tutorials</title>
  </head>
  <body>
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark">
  <div class="container-fluid">
    <a class="navbar-brand" href="#">Dailyaspirants</a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarSupportedContent">
      <ul class="navbar-nav ms-auto mb-2 mb-lg-0">
        <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Home</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Gallery</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">About us</a>
        </li>
         <li class="nav-item">
          <button class="btn btn-primary" aria-current="page" href="#">Login</button>
        </li>
      </ul>
    </div>
  </div>
</nav>
  <div class="container py-5">
<table class="table table-dark">
  <thead>
    <tr>
      <th scope="col">Id</th>
      <th scope="col">Name</th>
      <th scope="col">Class</th>
    </tr>
  </thead>
  <tbody>
     
    {% for i in items %}
    <tr scopr="row">
      <td>{{i.id}}</td>
      <td>{{i.name}}</td>
      <td>{{i.class}}</td>
    </tr>
  {% endfor %}</p>
  </tbody>
</table>
  
  </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>
  </body>
</html>


Python Flask tutorial


Here, using of sql server database connection to fetch the data and display in the html template. and use the import pyodbc for connection string.
 



pip install pyodbc




from flask import Flask, render_template
import pyodbc

connection = pyodbc.connect("""DRIVER={SQL Server};
SERVER=.;DATABASE=school;Trusted_Connection=yes;""")
table = "select student_id, student_name, student_class from class"
cursor = connection.cursor()

app = Flask(__name__)


@app.route("/")
@app.route("/home")
def home_page():
    cursor.execute(table)
    result = cursor.fetchall()
    return render_template('home.html', result=result)





<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">

    <title>Python Tutorials</title>
  </head>
  <body>
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark">
  <div class="container-fluid">
    <a class="navbar-brand" href="#">Dailyaspirants</a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarSupportedContent">
      <ul class="navbar-nav ms-auto mb-2 mb-lg-0">
        <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Home</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">Gallery</a>
        </li>
         <li class="nav-item">
          <a class="nav-link active" aria-current="page" href="#">About us</a>
        </li>
         <li class="nav-item">
          <button class="btn btn-primary" aria-current="page" href="#">Login</button>
        </li>
      </ul>
    </div>
  </div>
</nav>
  <div class="container py-5">
<table class="table table-dark">
  <thead>
    <tr>
      <th scope="col">Id</th>
      <th scope="col">Name</th>
      <th scope="col">Class</th>
    </tr>
  </thead>
  <tbody>
     
    {% for i in result %}
    <tr scopr="row">
      <td>{{i[0]}}</td>
      <td>{{i[1]}}</td>
      <td>{{i[2]}}</td>
    </tr>
  {% endfor %}</p>
  </tbody>
</table>
  
  </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p" crossorigin="anonymous"></script>
  </body>
</html>


Python Flask tutorial

Labels:

Comments

Post a Comment

Popular posts from this blog

Contact Management System project using C with source code

By
Contact Management System (CMS)   A Contact Management System (CMS) is an essential application for organizing and managing contacts efficiently. Here's a simple implementation of a Contact Management System using C, allows users to perform operations such as adding, viewing, searching, modifying, and deleting contacts through a simple and user-friendly console interface. The CMS provides a practical demonstration of fundamental programming concepts such as arrays, structures, and string manipulation, making it an excellent project for students and beginners in C programming.   Project Overview The Contact Management System is designed to store basic information about contacts, including: Name: name of the person. Phone Number: phone number of the contact. Email Address: email address of the contact.   With this information, the program offers the following functionalities: Add New Contact...
Post a Comment
Show more »

Implementing Basic Add to Cart Functionality in Python Using Flask

By
In e-commerce websites, the "Add to Cart" feature allows users to select products they want to purchase and store them temporarily while they continue shopping. Implementing this functionality in a web application using Python and Flask is straightforward and can be done with a few simple steps.       Setting Up the Project: First, create a new directory for your project and set up a virtual environment to manage dependencies. Install Flask using pip and create three main files: `app.py`, `index.html`, and `cart.html`.   Read also:   Unlocking the Power of Free Google Tools for Seo Success Ultimate Guide: Google Search Console Crawl Reports you need to know Monitor What is dofollow backlinks: The ultimate 5 Benefit for your websites SEO Schema markup and How can you use schema markup for seo      Creating HTML Templates: Create HTML templates for displaying products (`index.html`) and the shopping cart (`cart.html`). These templates will use ...
Post a Comment
Show more »

Advanced HTML Concepts: Techniques and Examples for Modern Web Development

By
Advanced HTML goes beyond the basics of creating simple web pages, delving into powerful features and techniques that improve web interactivity, accessibility, and performance. It includes concepts such as semantic HTML, custom data attributes, responsive images with <picture> , enhanced forms, interactive content using <details> and <summary> , and embedding external resources with <iframe> .          Furthermore, advanced HTML focuses on SEO optimization through meta tags, accessibility improvements using ARIA, creating reusable Web Components, and optimizing performance with async and defer scripts.    Semantic HTML   Semantic elements clearly describe their meaning in a human- and machine-readable way.   <header> <h1>Welcome to My Website</h1> </header> <nav> <ul> <li><a href="home">Home...
Post a Comment
Show more »

Python Flask Student List CRUD System Using MySQL Database for Beginners

By
  In this tutorial, we are going to learn the python flask student list crud system using MySQL database for beginners. Before you have to learn how to python flask setting up and connect MySQL database connection and templates uses.    Read also: Python Flask tutorial Setting up a Flask and Sql Database on the create project folder you have to install two things to fetch data and flask. Here, below code to install using python terminal, and for MySQL, am using xampp software and database inside environment to turn on the apache server and MySQL database.   Read also: Python Flask with Mysql Database Import Flask and MySQL: from flask import Flask, render_template, request, redirect, url_for from flask_mysqldb import MySQL MySQL Database Connection: app = Flask(__name__) app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = 'root' app.config['MYSQL_PASSWORD'] = '' app.config['MYSQL_DB'] ...
2 comments
Show more »

Microdata Schema : How can Microdata schema Improve SEO with Examples

By
In this article, we will explore what microdata schema is, how it works, and provide some examples to help you better understand its importance. What is Microdata Schema? Microdata schema is a markup language that provides a standardized way of adding structured data to web pages. It uses HTML tags to describe information about the content on a web page, such as product reviews, events, recipes, and more. This makes it easier for search engines to crawl and index the content on a web page, which can help improve the visibility and ranking of the website. How Does Microdata Schema Work? Microdata schema uses a set of properties and item types to describe the content on a web page. Properties describe specific attributes of an item, while item types describe the type of item being described. For example, the property "name" might be used to describe the name of a person, while the item type "Person" would be used to indicate that the content being describ...
Post a Comment
Show more »

How to Create a Personal details information program in HTML

By
In this tutorial, we are learning how you can create a personal details information program in HTML with the simple using of HTML tags. HTML Form: <div class="container"> <h1 style="text-align:center">Personal Details</h1> <form class="form-control"> <label for="name">Name:</label><br> <input type="text" id="name" name="name"><br> <label for="email">Email:</label><br> <input type="email" id="email" name="email"><br> <label for="dob">Date of Birth:</label><br> <input type="date" id="dob" name="dob"><br> <label for="gender">Gender:</label><br> <input type="radio" id="gender" name="gender" value="male...
Post a Comment
Show more »