AJAX is use to communicate with the server and perform action like – database manipulation, file upload, etc. without the need to refresh whole page.
AJAX pagination makes it easier to display the large list of records in multiple pages without refreshing the whole page when navigating.
While navigating pages if you refreshed the webpage then it will load record from 1st instead of page position before the refresh.
E.g. If you are on 5 page then it will again start from 1 when webpage reload.
To retain the position, I am using COOKIE to store the page number and use it after page successfully load to fetch records in CodeIgniter.
By storing media files to MySQL database make easier to retrieve files uploaded by the user or in the specific category.
For this require storing file to the server and save the reference to the database.
In the tutorial, I show how you can upload and store video to MySQL database table with PHP.
If you are using MySQL database in your web project then there is always possibility that you need to insert, update, and delete records instead of just fetching and displaying records.
In this tutorial, I show how you can insert, update, and delete a record from MySQL database table in Laravel.
A model is a PHP class where perform data logic and database manipulation like – retrieve data, insert, update, and delete.
In Laravel models classes are stored in app/ directory.
This mainly loads from the controller.
In this tutorial, I show how you create and load Model in the controller and fetch records from MySQL database in Laravel.
Live username availability checking on the registration page is the common feature in most of the website.
This will notify the user whether the username is already been taken or not before submitting.
To do this require AJAX.
Send a request to check the username on the bases of response perform the action.
In this tutorial, I show how you can check username availability using Vue.js and PHP.
Add, edit, and delete functionality mostly requires on every dynamic based web project.
With AJAX you can improve user experience and do these operations without page reload.
For this, I am using Axios package.
In this tutorial, I show how you can select, insert, update, and delete records from MySQL database with Vue.js and PHP.
Data selection is one of the basic requirement when creating a dynamic website.
Mainly data is fetched from the database on page refresh but for without page refresh require to send AJAX request.
I am using Axios package to send AJAX request.
In this tutorial, I show how you can fetch records from MySQL database using Vue.js and PHP with Axios package.