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

Introduction In this tutorial we will see how to delete multiple rows from table using PHP, MySQL, AJAX, jQuery. We are going to delete rows from HTML as well as MySQL database table. 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 table header and selecting this checkbox all rows on the table will…

Continue

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

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

PHP REST API AJAX jQuery CRUD Example

Introduction In this example we will see an example on PHP AJAX jQuery CRUD. CRUD is an acronym for four operations such as Create, Read, Update and Delete. We are going to perform CRUD operations on company details. We will use here MySQL database to store company detail information. We will perform each operation asynchronously through AJAX technique using jQuery on client side and PHP in server side. We will create here REST APIs using PHP and call those REST APIs through jQuery AJAX from front-end. I am going to…

Continue

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. We will determine registration process based on various http status codes such as 200 – success, 400 – bad request, 409 – conflict. We will also use template from Flask API to render the sign up page where input fields will be displayed for entering user details. We…

Continue

jQuery ajaxStop

This AJAXEvent ajaxStop registers a handler to be executed when all Ajax requests have completed. Whenever an Ajax request completes, jQuery checks whether there are any other outstanding Ajax requests. If none remain, jQuery triggers the ajaxStop event. Any and all handlers that have been registered with the .ajaxStop() method are executed at this time. The ajaxStop event is also triggered if the last outstanding Ajax request is cancelled by returning false within the beforeSend callback function.

Continue

jQuery ajaxStart

This AJAXEvent ajaxStart registers a handler to be executed when the first Ajax request begins. Whenever an Ajax request is about to be sent, jQuery checks whether there are any other outstanding Ajax requests. If none are in progress, jQuery triggers the ajaxStart event. Any and all handlers that have been registered with the .ajaxStart() method are executed at this time. To observe this method in action, do the following

Continue

HighChart using AJAX, Codeigniter

We know that highchart basically displays different statistical data on different chart types such as column chart, bar chart, line chart, pie chart etc. You can have a look at the URL http://www.highcharts.com/ for more information. You can integrate highchart with any server side tehnology but here I will show you how to integrate highchart with Codeigniter framework. 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…

Continue