Author Archive

4 Aug 2015

Ago function in PHP

We always required time ago in our website. Here we have function for the same. You can enjoy with the embed in your website. Example of Ago function in PHP as below $datetime = '2015-07-31 22:00:00'; $time
3 Jun 2015

How to handle deleted files in GIT

Git – Very useful and latest version control system. Now a days we use git for version control. Sometimes we stuck in error when we face following case 1) I have created new file and commited &
11 Apr 2015

How to setup Corporate Gmail in Android Email App without Gmail App

Here are steps which can guide to setup Google email account in Android Email App without Gmail App. Here I mentioned Google Email account which is Corporate Gmail account with corporate domain name. 1) Open Android email app
3 Apr 2015

List all triggers and views

Here is simple query to find list of triggers on chosen database Example:  SHOW TRIGGERS; If you want like to find list of views for particular database, then here you can go with. Syntax: SHOW FULL TABLES IN
1 Apr 2015

List tables which has fulltext index

If you have to get list of tables for specific database which table has FULLTEXT index use following command: # SELECT TABLE_NAME FROM information_Schema.STATISTICS WHERE table_schema = 'DATABASE_NAME' AND index_type = 'FULLTEXT' ORDER BY index_name; Example: SELECT TABLE_NAME FROM information_Schema.STATISTICS
19 Mar 2015

Convert any video using FFMPEG

Always we need something which simplify our task/job. Here I have attached code which can convert video using ffmpeg. # ffmpeg -i /path/to/inputfilename /path/to/outputfilename Example: ffmpeg -i /usr/local/public_html/abc.flv  /usr/local/public_html/abc.mp4 It will convert abc.flv file to abc.mp4 without any