Debug Mode Ajax Javascript Pagination in Nodejs MySQL Server RestAPIs Express + Sequelize ORM

#nodejsmysqlpaginationexample​
#ajaxnodejspaginationexample​ #nodejspagination​ #ajaxpagination​
#nodejsmysqlpagination​ #nodejsrestapipagination​ #nodejs​ #ajax​ #mysql​

[Debug Mode] Ajax Javascript Pagination in Nodejs MySQL Server RestAPIs - Express + Sequelize ORM

- To do pagination filtering and sorting queries with MySQL database, We use Sequelize ORM.

II. Pagination Ajax Javascript with Bootstrap Table

We define the view page with 4 parts:

- Bootstrap Table is used to display Customer list with table format
- Pagination Bar is used to list all data pages
- Filtering Selection is used to select a specific salary to do the pagination with filtering
- Sorting Checkboxes is used to determine whether the sorting with age field or Not and sorting with descending or ascending(default value) direction

- Signature of the function: function fetchCustomers(page, size, salary, agesorting, desc)

1. page: number of page for requesting
2. size: a size of a data page for requesting
3. salary: a selected salary for filtering
4. agesorting: a flag to determine to do the sorting by age field or not
5. desc: a flag to determine the direction for sorting, desc = true for descending sorting direction and desc = false for ascending sorting direction (default value)

III. Video Structure:

0:0 Demo Overview Nodejs Pagination RestAPI
0:26​ Overview Article for the video
0:58​ - Download Nodejs Sourcecode
1:11​ - Install Nodejs Dependencies
1:28​ - Import Nodejs Project to Visual Studio Code
1:37​ - Review coding of Nodejs Project
3:06​ - Run Debug Mode Nodejs application
3:14​ - Check MySQL database - prepare data for created table customers
3:44​ - DEBUG pagination RESTAPI with nodejs project
5:12​ - Debug GET Salaries of Nodejs Application
6:04​ - Check Ajax Pagination Client in Browser
7:20​ - Start Debug with Ajax Client - FullStack Debug
7:47​ - Start Debug the first time fetching of Ajax Client Pagination
9:43​ - Start Debug with Pagination and Filtering Age - Full Start from Ajax Client to Nodejs Coding
11:08​ - Start Debug with Pagination Filtering and Sorting by Age Asc - Full Start Debug from Frontend to Backend
11:35​ - Start Debug with Pagination Filtering and Sorting with Age by DESC direction - Full flow frontend to backend
12:51​ - Debug the NEXT button of Pagination Bar with Full Flow from Frontend to Backend


IV. Related Posts
1. Angular 10 Nodejs Pagination RestAPIs + Filtering Sorting Example – Fullstack: Angular + Nodejs RestAPIs+ MySQL Tutorial

2. Angular Nodejs Fullstack CRUD Application with MySQL/PostgreSQL – Angular 10-9-8 HttpClient + Nodejs Express, Sequelize ORM

3. Angular 10 Spring Boot JWT Authentication Example – Angular 6, 8, 9, 10 + Spring Security + MySQL/PostgreSQL

4. Django RestAPIs Tutorial – Build Post/Get/Put/Delete request Examples to MySQL/PostgreSQL databases

Article for the video:

V. Sourcecode

--------------------------------
Youtube loizenai