In this tutorial I will explain you two methods to import csv file into MySQL database. First this requires a MySQL database with same numbers of column as csv file. Import csv with LOAD DATA INFILE Import csv file with mysqlimport
I was working on PHP project that require to get a text from MySQL and display only 50 character. Thus I used php substr function to truncate a text to first 50 character.
Some time web server response very slow due to multiple concurrent connection to Apache. As we know that each web server has different Apache configuration depends upon its hardware (Processor and RAM). Maximum allowed Apache concurrent connection can be configured by ServerLimit directive in apache2.conf file. After exceeding this limit new apache connection goes in […]
When uploading your website to new server or migrating a website to different server then you are require to copy some file from one machine to another. There are various ways to do this like web-base uploading and FTP etc. But in this article I will introduce you with two more Linux command to copy […]
An Envato Affiliate WordPress plugin to display envato market place item in WordPress Post and Page with your referral link. This plugin has inbuilt click counter that help to track click on different envato item.
I was working on php script that requires translation in multi-language, So I found two ways to make it translation ready with PO and MO files. Here are the two methods to translate a php project using gettext PO/MO files. PHP core Gettext library PHP Gettext class (Mainly written for wordpress) PHP core Gettext requires GNU […]
Referrer spam is a technique involves making repeated web site requests using a fake referer URL to the site the spammer wishes to advertise. Now a days I am getting to much referrer spam on 99webtools that causes inaccurate stats at Google analytics. You can also find some of these referrer in your analytic. Here is the […]
In php creating zip file is very easy. PHP 5.2 has an inbuilt class ZipArchive to manipulate zip file, if you are using a older version of php then you can install PECL zip on your server. To make this task more handy I have created a simple function to make zip archive that anyone can use in […]
An useful resource for developer that requires profile images from various social network website. In this article you will learn how to get profile picture URL from Facebook, Google, Twitter and Gravatar.
PHP widely used for web development. More than 80% websites on internet are built using php. In this article i’ll tell you 10 most useful tips for php.