Author: <span class="vcard">Yogesh Singh</span>

CSV (Comma Separated Values ) is the most popular file format for data import and export within the project.

In PHP for creating CSV file, you can either use fputcsv() method or directly write the comma-separated content on the file.

In this tutorial, I will show you how you can export MySQL data in CSV file format in your CodeIgniter project.

Export MySQL data to CSV file in CodeIgniter

PHP

Search filter makes easier to filter the list of records and view the only required records. This saves time when there is the huge number of records are available on the list.

There is already an orderBy filter is available on AngularJS which will be used for sorting the list.

In this tutorial, I am filtering MySQL table records while fetching data using AngularJS and PHP.

Table with search and sort using AngularJS and PHP

AJAX AngularJS PHP

You normally store the user selected files in the specific directory but the same directory is also used by all other users.

If you are allowing to upload multiple types of files like – image, videos, doc, etc then it becomes a mess.

To avoid this you can create separate directories for the store in an organized way.

But for storing it in a more organized way you can dynamically create directories for each user for storing their files. This makes traversing to file easier.

Make destination directory on file upload with PHP

PHP

Sometimes it requires to quickly create a clone of the MySQL database while working on the project either for the backup purpose, using it on a copy of the project or moving the project.

With phpMyAdmin, this process is easier.

In this tutorial, I am assuming that you already have a cPanel enabled web hosting server.

Create a copy of MySQL database using phpMyAdmin

DataBase How To

By enabling the social login on the website it is easier for the user to easily register or sign in on the website without entering its details.

In this tutorial, I am adding LinkedIn Login on the webpage.

LinkedIn provides a very simple JavaScript API for developers to fetch the user details after successfully authorization and use it for registration or login.

How to Login LinkedIn with JavaScript API

How To Javascript Jquery PHP

Normally a WordPress theme shows the same sidebar content on each page or posts and not allow to define unique sidebars.

Sometimes you may want to display different sidebar according to the content to get more conversion from the page.

In this tutorial, I am using Content Aware Sidebars plugin to set up an entire sidebar that will populate with widgets and assign to posts and pages.

It’s pretty simple to use.

How to Display Different Sidebar on Specific Pages in WordPress

How To

Dynamically dependent dropdown commonly seen in the country, state, and city selection on the webpage. The data on the child element changes according to the value of the parent element.

The process follows the same way if there are more than 2 dropdown elements.

To do this you can either use only PHP or jQuery AJAX.

In this tutorial, I am using jQuery AJAX to make dynamic dependent dropdown.

Dynamic dependent dropdown in CodeIgniter with AJAX

AJAX Jquery PHP

A Sticky sidebar widget is a great option to highlight a widget. By doing this the widget will stick and float while scrolling the page.

This improves the conversion rate of the website.

Mainly the visitor doesn’t view the sidebar content but you can grab attention on it by making sticky some of the widgets like – newsletter, ads, etc.

In this tutorial, I am using  Q2W3 Fixed Widget plugin to make sticky sidebar widget.

How to make any widget sticky in WordPress sidebar

How To

Bootstrap Modal is a popup box which is customizable and responsive.

It can be used in many different ways – display login or registration form, terms and conditions, information, image etc.

In this tutorial, I am using AJAX to update user information on the Bootstrap Modal according to the requested data.

Dynamically load content in Bootstrap Modal with AJAX

AJAX Jquery PHP

Zip file creation is a better way to enable the user to download multiple files in one package. This may affect the page load time according to the number of files and their size.

Arises more problem when need to create multiple zip files on page load for download.

To avoid this type of problem you can either use only PHP or jQuery AJAX to create and download the zip file when it’s required.

In this tutorial, I am using jQuery AJAX.

Create and download zip file with AJAX

AJAX Jquery PHP