jQuery AJAX based Registration System using Python Flask MySQL

Introduction This guide will walk you through how to build jQuery AJAX based registration system using Python Flask MySQL. In this example I am going to build REST API that will be called from front-end technologies – jQuery, HTML including AJAX technique. I will determine registration process based on various http status codes such as 200 – success, 400 – bad request, 409 – conflict. I will also use template from Flask API to render the sign up page where input fields will be displayed for entering user details. I…

Continue

How to Backup and Restore MySQL Database using command line tool and PhpMyAdmin

Introduction This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may need to restore your site’s data into MySQL database. The PhpMyAdmin tool may be found on your cpanel, webuzo or any other control panel.

Continue

Bootstrap Calendar Events Demo using Python Flask MySQL

Introduction We will create bootstrap calendar events demo using Python Flask MySQL. We had created similar example using Codeigniter (PHP framework) and MySQL. We will use the same version of bootsrap library 2.3.2 because using bootstrap version 4.3.1 the layout becomes a little messy. It helps users to track easily what all upcoming events are or past events were there by navigating through the calendar dates.

Continue

Building Simple Shopping Cart using Python, Flask, MySQL

Introduction In this tutorial I will show you here how to build a simple shopping cart using Python, Flask, MySQL. This shopping cart is very simple and it does not have checkout option, payment option. This is about to display products in an online shopping portal, add item to cart, remove item from cart and remove all items from cart at once or empty cart.

Continue

Installing MySQL 8 Zip Archive in Windows

Introduction In this tutorial you will see here how to install MySQL zip archive in Windows operating system. I will download MySQL community version for showing this example. You will also see how to connect to MySQL server using default user root. The advantage of installing zip archive version of MySQL server is that later if you find this server is not required for your application then it would be easier to remove the zip version of MySQL installation any time. You do not need to check in the registry…

Continue

Bootstrap Datatable CRUD using Codeigniter, MySQL, AJAX

Introduction In this post we will see Bootstrap Datatable CRUD using Codeigniter, MySQL and AJAX. We have also seen similar implementation in our previous post on DataTable CRUD Example using Codeigniter, MySQL and AJAX, but here we will use Bootstrap Datatable to implement the similar functionalities, where we have the following features: Loading data from MySQL database in HTML table Pagination – each page shows 10 records Searching Filtering Sorting Creating new record Updating the existing record Deleting the existing record In this example we will use Bootstrap 4 Datatable API…

Continue

Codeigniter MySQL Stored Procedure CRUD Example

Introduction Here I am going to show you an example on Codeigniter MySQL Stored Procedure CRUD. You may also read my previous tutorial on Call Stored Procedure using Codeigniter. CRUD means, Create, Read, Update Delete operations. We can perform the similar the CRUD operations by executing individual SQL statement for each operation.

Continue

Python REST API CRUD Example using Flask and MySQL

Introduction Here you will see Python REST API CRUD Example using Flask and MySQL. You might have also seen how to create web application CRUD example using Python, Flak and MySQL. You may also like to read REST APIs in Java and Spring Technologies. What is REST or RESTful? The most important concept in REST is resources, which are identified by global IDs — typically using URIs. Client applications use HTTP methods (GET/ POST/ PUT/ DELETE) to manipulate the resource or collection of resources. A RESTful Web service is implemented…

Continue

Call Stored Procedure using Python

Introduction This tutorial will show you how to call stored procedure using Python programming language. Here I will use MySQL database server to store the data for this example. You may also want to read How to call stored procedure using Codeigniter framework. A stored procedure is a set of Structured Query Language (SQL) statements with a given name so it can be reused and shared by multiple programs. It is always better to write a stored procedure when you want to execute multiple SQL statements for performing operation on…

Continue