Sending PHP array in Url

Send data array foreach ($data as $d1){ $userType=$d1['iduserType']; } $MySelect = urlencode(serialize($d1)); switch ($userType) { case 1: header("Location: Admin.php?uname=$MySelect"); break; case 2: header("Location: TechLead.php?uname=$MySelect"); break; case 3: header("Location: Processor.php?uname=$MySelect"); break; } Retrieve data array $rData = unserialize(urldecode($_GET["uname"]));

Add time,day to date in mysql

mysql> SELECT TIMESTAMPADD(MINUTE,1,'2003-01-02');
-> '2003-01-02 00:01:00'
mysql> SELECT TIMESTAMPADD(WEEK,1,'2003-01-02');
-> '2003-01-09'

Calculate date difference in mysql

mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
-> 3
mysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');
-> -1
mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
-> 128885