[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

[getsiete]

Gracias, al fin encontré un video con MySQL y pude hacer la paginación