Delete Multiple Rows from Table using Flask, AJAX, jQuery, MySQL

In this tutorial we build an application using Python based Flask framework to fetch all products from MySQL database and display on the HTML table. This example is all about to delete multiple rows from HTML as well as database tables. We will use IN clause with WHERE condition in MySQL query to delete multiple rows from database table. We will put checkbox against each row on the table so that user will be able to select a particular row for deletion. We will also put a checkbox on the…

Continue

jQuery AJAX based Voting or Rating System using Flask and MySQL

Introduction In this post we will see how to create voting or rating system using Flask, MySQL and AJAX. We post tutorials, articles or blogs either on our own blog site or as a guest user to other sites. Sometimes we need to let user rate on our tutorials or articles or blogs so that we know how much that blog is famous or how much that blog is intended to be accepted by readers. In this example I have given one sample content on which you can rate this.…

Continue

AJAX jQuery based XChart Example using Python Flask MySQL

Introduction In this example we will see how to display data on XChart using AJAX, jQuery, Python Flask and MySQL. XChart displays different statistical data on different chart types such as column chart, bar chart, line chart, pie chart etc. This tutorial shows step by step so that we can understand how it happens. It displays the data for site visitors log in line chart. I have also put a calendar for date-picker so that you can pick a custom range of dates and get the visitor statistics in xchart.…

Continue

Securing REST API: JWT Authentication using Python Flask

Introduction In this post we will see how to secure REST API with JWT authentication using Python Flask. JWT is an acronym for JSON Web Token. In previous example we have seen how to secure REST API using HTTP Basic Authentication which is not recommended for most of the time. Recommended Reading REST API CRUD Example using Python Flask and MySQL REST API CRUD Example using Python Flask and MongoDB

Continue

Securing REST API: Python Flask HTTP Basic Authentication

Introduction We will see an example on how to secure REST API using Python Flask. We will create a Python Flask HTTP Basic Authentication. Most of the web services that require authentication accept HTTP Basic Authentication. This is the simplest one, and request supports it straight out of the box. This HTTP basic authentication is not recommended as it is vulnerable to security threats. Recommended reading Securing Python Flask REST API with JWT

Continue

Query Parameter in REST API: GET Request with Python Flask

Introduction We will create an example on how to use query parameter in REST API GET request with Python Flask. HTTP GET method is used to fetch data from the server. So here we will use GET method to fetch data from server and send to the client. Query parameter is used with GET method to fetch data from server based on such query parameter’s value. Actually when you need to search or filter data from server side instead of fetching all data then you can use such query parameter.

Continue

Angular + Python Flask REST API MongoDB CRUD Example

Introduction In this post we will see Angualr + Python Flask REST API MongoDB CRUD Example. We will use our existing tutorial on Python Flask REST API MongoDB CRUD Example for server side and we will introduce Angular on UI or front end side. You can also use any UI technologies, such as React JS, HTML, JavaScript, jQuery etc., for front end to suit your requirements.

Continue