هذا الكود اللي تحتاج .. واضح ويشرح نفسه واذا فيه شي يحتاج توضيح مافيه مانع من السؤال
بالتوفيقكود PHP:$link = mysql_connect( "localhost", "user", "password" );
mysql_select_db( "database_name" ) or die ( "Couldnt Select $database" );
$result = mysql_query("SELECT *,UNIX_TIMESTAMP(startdate) AS date1
,UNIX_TIMESTAMP(expiredate) AS date2
FROM table_name WHERE username='code4arab'");
$row = mysql_fetch_array($result);
$date1 =$row["date1"];
$date2 =$row["date2"];
Function DateDiff ($interval, $date1,$date2) {
// return the number of seconds between the two dates
$timedifference = $date2 - $date1;
switch ($interval) {
case "d": //days
$retval = bcdiv( $timedifference,86400);
break;
case "h": //hours
$retval = bcdiv ($timedifference,3600);
break;
case "n": //months
$retval = bcdiv( $timedifference,60);
break;
case "s": //seconds
$retval = $timedifference;
break;
}
return $retval;
}
// difference in days
$diff = DateDiff ("d",$date1 ,$date2);
