Category: DataBase

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.

Check Username Availability with Vue.js and PHP

AJAX DataBase PHP Vue.js

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.

Insert Update and Delete records from MySQL with Vue.js

AJAX DataBase PHP Vue.js

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.

Fetch records from MySQL Database with Vue.js and PHP

AJAX DataBase PHP Vue.js

Date filter makes easier to list records according to specific date range selection.

The user can pick dates and search the list. Records will be displayed according to date selection.

To add datepicker you can use jQuery UI, Bootstrap, or any other jQuery plugin.

In this tutorial, I am using jQuery UI to add datepicker widget and filter the records with PHP MySQL.

jQuery Datepicker to filter records with PHP MySQL

DataBase PHP

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

AJAX CodeIgniter DataBase How To JQuery PHP

It is time-consuming to delete records one by one from the list.

To make deletion process easier for the users by allowing them to select multiple records using checkboxes.

Execute delete query according to the selected checkboxes.

In the demonstration, I am displaying records from the MySQL database table and add a checkbox on each row. Use single submit button to delete selected records with PHP.

Delete multiple selected records with PHP

DataBase PHP

A database is one of common requirement while building the dynamic application.

It uses to store related data in an organized manner.

You can use more than one database in your application.

If you are using CodeIgniter Framework then you need to define the database connection details separately for multiple databases and load it explicitly for performing operations on the database.

Connect with Multiple Databases in CodeIgniter

CodeIgniter DataBase PHP

CSV files are easier to maintain and can be used for export and import data in the web application.

For data import first, need to allow the users to browse and upload the file. In CodeIgniter, there is upload library available which makes easier to handle file uploads.

In this tutorial, I import data of CSV file in MySQL database table with CodeIgniter.

How to Import Data in MySQL with CodeIgniter

CodeIgniter DataBase PHP