Skip to main content

Advanced Ajax Pagination with PHP and MySQL

Pagination is an important feature of web applications to display huge data in chunks of pages instead of displaying all records. With pagination, we divide total records into chunks of pages with small number of record. We mostly loads pagination pages on each page request with same page reload. But now the ajax pagination is more improved and more user friendly which allow users to load next or previous pages without reloading page.

So if you’re a PHP developer and thinking to implement advanced ajax pagination with PHP, then you’re here at right place. in this tutorial you will learn how to implement ajax pagination with PHP and MySQL. In this tutorial we will use simple bootstrap pagination plugin to create advance pagination.

We will cover this tutorial in easy steps to live example to create advanced ajax pagination with PHP and MySQL. We will also allow you to download complete source code of live example.

(more…)

Exporting Data to Excel using PHP & MySQL

Export Data to Excel is a common feature of web applications to allow dynamic data export to Excel file to save locally for further use. If you’re a PHP developer and thinking to implement data export to excel, then you’re here at right place. You will learn here how to implement data export to excel using PHP & MySQL.

In our previous tutorial you have learned how to export data to excel in CodeIgniter, now in this tutorial we will explain how to export data to excel with PHP and MySQL.

We will cover this tutorial step by step to create live demo to implement data export to excel with PHP and MySQL. You can also download complete source code of live.

(more…)

Export Data to Excel in CodeIgniter with Example

In our previous Python tutorial, we have explained how to Create RESTful API using CodeIgniter. In this tutorial, we will explain how to Export Data to Excel using CodeIgniter with Example.

Data Export to Excel (xls or xlsx) format is a feature of web applications to allow users to save data from MySQL table into Excel format for further use.

If you’re PHP developer and looking for solution to implement data export to excel in CodeIgniter, then you’re here at right place.

In this post you will learn how to export dynamic data into Excel format using CodeIgniter. We will use PHP library PhpSpreadsheet to create and save dynamic Excel file to export and save data.

(more…)

Ajax CRUD Operation in CodeIgniter with Example

CRUD (Create, Read, Update, Delete) is a common part of any dynamic web application. We generally add new records into database or display records from database and then perform further operations like update, delete on same records.

So if you’re developing web applications using CodeIgniter then you have certainly handled CRUD operations in your application. But its not very user friendly if you have handled this with pure CodeIgniter because it loads page every time when you perform actions.

So here in this tutorial, we have handled CRUD operations using Ajax with CodeIgniter. You would also like to checkout tutorial about Multiple Image Upload in CodeIgniter with example.

We will cover this tutorial in easy steps with live example with ajax CRUD operations in CodeIgniter.

So let’s start.

ajax CRUD operations in CodeIgniter (more…)

Form Validation in CodeIgniter with Example

The Form fields validation is an essential part of any web application to validate input values before storing into database. The Form input validated when form submitted.

If you’re working with CodeIgniter framework and created Forms and wants to add validation to form inputs, then its very easy. CodeIgniter framework has form validation library form_validation to validate various form fields.

So here in this tutorial, you will learn how to implement Form Validation in CodeIgniter.

We will cover this tutorial in easy steps with live demo. There are also a download link at the end of tutorial to download source code of live demo.

Form Validation in CodeIgniter (more…)

Create Ajax Pagination in CodeIgniter with Example

Pagination is a feature of web applications to load large dynamic data into multiple pages by displaying next and previous link to view dynamic data.

As a PHP developer, you have definitely implemented pagination with PHP and now looking for implementing pagination in CodeIgniter. It’s very easy to implement pagination in CodeIgniter as it has default Pagination class to implement pagination but it’s not user friendly.

So here in this tutorial you will learn how to implement Ajax pagination in CodeIgniter framework. The pagination with Ajax is simple and user friendly can be used in any CodeIgniter project.

We will cover this tutorial in easy steps with live demo to implement Ajax based pagination in CodeIgniter. You can also download complete source of live demo.

(more…)