Backup of important data or website is crucial if a system crash or hard drive failure occurs. There many software are available on internet to backup data. Some of those are paid or not easy to use, So I decided to create my own bash script to backup MySQL database and directories on Linux. This script also uploads backups to Dropbox account.
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 queue. Thus web server response very slow.
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 files between two Linux server. Which are more powerful then ftp.
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. Continue reading
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 gettext package to be installed on system. Whereas PHP gettext class doesn’t have any dependency. It can directly ready MO file and extract translation text from that. Also It works on windows server without problem. So in this article I will guide you how to use php-gettext class. Continue reading
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 list of referrer that spamming 99webtools. Continue reading
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 their web application. Continue reading
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. Continue reading