Ajax Pagination with Tabular Records using PHP and jQuery

Ajax-Pagination

Pagination feature is for limiting the number of results instead of loading all in a list page. Loading multiple records with pagination will increase efficiency to load result page by page. We have seen several examples for PHP pagination with database results. For the pagination functionality, a perpage result count will be configured. This configured […]

Access MySQL from PHP

php-mysql-files

In this tutorial, we are going to access the MySQL database from PHP. Accessing MySQL from PHP is very simple and easy to implement. PHP contains MySQLi class functions to connect and access the database. Some of those are used in this article. prepare() – To prepare query statement object fetch_row() – To read row […]

Split and Export into Multiple Excel Sheet Files using PHP

Split and Export into Multiple Excel Sheet Files using PHP

When we are dealing with huge volume of records export into excel or CSV, we cannot blindly export them into a file. Imagine we have a million records, what would happen if we export those records into a single excel file! In this kind of situation, we should group the records and split them into […]

Access MySQL from PHP

Access MySQL from PHP

In this tutorial, we are going to access MySQL database from PHP. Accessing MySQL from PHP is very simple and easy to implement. PHP contains built-in functions to connect the MySQL database and to access the data. Those functions are, mysqli_connect – To connect the database by using the specified configuration. mysqli_query – To execute […]

jQuery AJAX Autocomplete – Country Example

jQuery-AJAX-Autocomplete

Autocomplete feature is used to provide the auto suggestion for users while entering input. In this tutorial, we are going to suggest country names for the users based on the keyword they entered into the input field by using jQuery AJAX. jQuery Autocomplete function is called on the key-up event of the input field. This […]

How to Pass Data with Ajax to a PHP file

Pass-Data-with-Ajax-to-a-PHP-file

In today’s tutorial, I’m going to show you, how to Pass Data with Ajax to a PHP file and process it. Using this method, you can retrieve data from a database, and run other PHP scripts using the values of the forms and fields.

PayPal Standard Payment Gateway Integration in PHP

php_paypal

PayPal is an American international e-commerce business allowing payments and money transfers to be made through the Internet. PayPal is the most popular payment gateway to send and receive payment worldwide. PayPal is a widely used payment gateway to accept payment in the web application. PayPal payment gateway is the easiest option for the web […]

Load Data Dynamically on Page Scroll using jQuery and PHP

scroll page load data

In this tutorial, we are going to see about loading data into a web page dynamically as the user scrolls it. We will be using jQuery and AJAX for the dynamic load on the scroll. Initially, we will show a limited number of results on page load. The subsequent bunch of records will be shown […]

Cookie Consent warning strap with HTML-CSS-JS

cookies law warning strap

We know there are many pointless, dumb laws out there that make no sense. The European Cookie Law is also annoying because you have to start by closing a popup every single time you visit a website. This law is a privacy legislation that requires sites to get consent from visitors to store or retrieve […]