Fetch records from MySQL Database with Vue.js and PHP

Data selection is one of the basic requirements when creating a dynamic website.

Mainly data is fetched from the database on page refresh but without page refresh require to send AJAX request.

I am using the Axios package to send the AJAX request.

In this tutorial, I show how you can fetch records from MySQL database using Vue.js and PHP with the Axios package.

Fetch records from MySQL Database with Vue.js and PHP

Read more

How to Search Multiple Words at a Time with jQuery AJAX

Sometimes requires searching for multiple words and select records according to words matched instead of the exact words.

With only a single like operator, it is not possible to search for multiple words.

Require to split the search term and use it with or and like operators.

In this tutorial, I am using the jQuery UI library for displaying a suggestion list according to the search input.

How to Search Multiple Words at a Time with jQuery AJAX

Read more

How to Create AJAX Pagination in CodeIgniter

AJAX based pagination load content without reloading the whole webpage and improve the user experience.

CodeIgniter has the pagination library to add pagination.

From the controller need to handle the AJAX request which sends from the view.

In this tutorial, I show how you can create AJAX pagination in CodeIgniter.

How to Create AJAX Pagination in CodeIgniter

Read more

Confirmation alert Before Delete record with jQuery AJAX

It is safe to display a confirmation alert before deleting a record from the MySQL database table.

If the user has accidentally clicked the delete button on the wrong record then it has a choice whether to delete or cancel it.

Confirm box can easily add using confirm() method.

But in this tutorial, I am using the Bootstrap Bootbox.js library to display the confirm box.

With jQuery AJAX delete a record from the MySQL database with PHP on the confirmation.

Confirmation alert Before Delete record with jQuery AJAX

Read more