How to import the Excel sheet data into MySql database

Hi, In this tutorial, I am going to explain  How to import the Excel sheet data into MySql database. Some of the organizations are uses the Excel sheets to save their data. When they want to upgrade their system with new technologies. Then we need to convert the entire Excel sheets data into SQL format. For example, consider the one of the...

How to enable php intl extension in XAMPP / WAMP

What is the php intl extension. It is a Internationalization extension. It is useful for formatting currency, number and date or time as well as UCA-conformant collations, for message formatting and normalizing text..etc If you want to enable the php intl extension .Follow these steps. Step #1: Open the [xampp / Wamp path]/php/php.ini file Now search...

How to delete the entire directory with in its files in php

Generally we use the remove directory rmdir() method. In this case the directory will be removed when it has no files on it. another way is unlink() method. This method can be used for removing the single file from the directory location. How to download the multiple directories as a zip file in PHP If you want to remove the directory and its all...

How to include CSS and JS files via HTTPS

Generally we include the CSS and JS files are in the below format. <link rel="stylesheet" href="http://example.com/style.css"> <script src="http://example.com/script.js"> The links are works perfect in the normal protocal like http://example.com .when we move to the SSL enabled site i.e https://example.com. In this case above inlcuded...

How to increase the php file upload limits

PHP has several configuration options to limit resources consumed by scripts. By default, PHP is set to allow uploads of files with a size of 2MB or less. Now you can change these configuaration. Follow these steps Step 1: open your server root directory Step 2: open the php directory Step 3: open the php.ini file Try increasing the following values...