How to Show Timestamp like Seconds and Minutes Ago

Here i am talking about the timestamp which looks like Twitter or Facebook timestamp , 2 Days ago or 4 Days ago or 2 Minutes ago. Same like here is the simple tutorial which will show you how to implement same like this. Once you need to call this function timeAgo($timestamp);and you will just see this stamp one more thing change your timezone according to your taste or server as you wish. Also for the simple way just make your date like "2014-04-11 11:10:20" and take this in $timestamp variable and just call your function you will see these type of timestamp.

function timeAgo($timestamp){
date_default_timezone_set("Asia/Karachi");
    $datetime1=new DateTime("now");
    $datetime2=date_create($timestamp);
    $diff=date_diff($datetime1, $datetime2);
    $timemsg='';
    if($diff->y > 0){
        $timemsg = $diff->y .' year'. ($diff->y > 1?"'s":'');

    }
    else if($diff->m > 0){
     $timemsg = $diff->m . ' month'. ($diff->m > 1?"'s":'');
    }
    else if($diff->d > 0){
     $timemsg = $diff->d .' day'. ($diff->d > 1?"'s":'');
    }
    else if($diff->h > 0){
     $timemsg = $diff->h .' hour'.($diff->h > 1 ? "'s":'');
    }
    else if($diff->i > 0){
     $timemsg = $diff->i .' minute'. ($diff->i > 1?"'s":'');
    }
    else if($diff->s > 0){
     $timemsg = $diff->s .' second'. ($diff->s > 1?"'s":'');
    }

$timemsg = $timemsg.' ago';
echo $timemsg;
}

If you love this tutorials please share it or comment below.

Read More

How to Write Sql in Phpmyadmin also Make Tables in MYSQL

How to Write SQL query in  Phpmyadmin:

One of my friend ask on how to write sql query in phpmyadmin so i decided to write a small tutorial with screen shots so you can work your own self.

Step 1: If you don't have phpmyadmin then go to this website and download XAMPP

Step 2: Install Xampp Click to see how to install.

Step 3: Go to Start >> Programs >> Xampp >> Xampp Control Panel and Start it.

Step 4: Now Start two services (Apache and Mysql) see in screen shot.

How to start Xampp

Step 5: Go to your Web Browser and write http://localhost/phpmyadmin

Step 6: you will see a windows Click on Database. See in screen shot.

how to create database

Step 7: Write your desired database name and then click create like screen shot below.

How to Create database in phpmyadmin

Step 8: Now on the left side pan there is your database pateltutes select it.

Step 9: Click on SQL and then write your sql query and click GO. see in screen shot.

How to and where to Write SQL query

Sql Query Example

Step 10: We do and example above which shows how to write example query you can design table in xampp

How to Design Table Using Phpmyadmin

Click the Structure button at the left of SQL and write your table name and designed it.

Design of Table using Xampp

Read More