How to import the Excel sheet data into MySql database

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 replace all occurrences of a string in JavaScript

How to replace all occurrences of a string in JavaScript

Generally, we use the replace() function to replace the particular word phrase. This does not work for replacing all occurrences of a string. i.e replace() is replaces only first matching word phrase only. For example "How to replace all occurrences of a string in JavaScript". Here I want to replace the space with "-" 'in all occurrences....
CURD operations using PHP Functions with Bootstrap

CURD operations using PHP Functions with Bootstrap

Hi, In this tutorial, I am going to teach you how to perform the CURD operations using PHP Functions with Bootstrap. What do you mean by CRUD operations ? CRUD operations are the basic operations in database C - Create R - Read U - Update D - Delete Generally, we implement the CURD operations normal way. But we implement these operations by using...
How to save the image from url directly

How to save the image from url directly

Hi, In this tutorial, I am going to teach you how to save the image from url directly. Suppose in your web application user picture to be taken from the external URL. for example if a user signup / login using facebook in this case user profile picture url is return from the facebook. then you have to save the image from the external source in this...
How to detect the mobile device in PHP

How to detect the mobile device in PHP

Hi, In this tutorial, I am going to explain How to detect the mobile device in PHP. This is the simplest way to identify the users mobile device.In many cases, the site owner wants to redirect the mobile users to some other location. For example, http://www.example.com is the main website URL and one more URL is http://m.example.com . Here http://www.example.com...