Advertisement
sayanriju

Shashibhushan

Jul 5th, 2012
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2. // IMPORTANT: First, make sure you are connecting to the database properly.
  3. // (Like  using mysql_connect() and mysql_select_db())
  4.  
  5. $sql_sel="SELECT `dateofbirth`,`Date`,`Month`,`Year` FROM `member_reg`";
  6. $result=mysql_query($sql_sel);    // N.B.: mysql_query() returns a resultset resource
  7. $row0=mysql_fetch_row($result);   // Fetch first row of  resultset    
  8.  
  9. $date1 = $row0["dateofbirth"];    // 1950-01-01
  10. echo "DEBUG: ".$date1; // Debugging purposes
  11.  
  12. $date2 = date("Y-m-d");
  13.  
  14. $diff = abs(strtotime($date2) - strtotime($date1));
  15.  
  16. $years = floor($diff / (365*60*60*24));
  17. //$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
  18. //$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
  19.  
  20. printf("%d years\n", $years);
  21.            
  22.             ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement