Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. function getTotals($empID,$conf,$conn) {
  2.   $string = "";
  3.  
  4.   $sql = "SELECT hours FROM {$conf['db_prefix']}_employees WHERE `id`='{$empID}' LIMIT 1";
  5.   $result = mysql_query($sql);
  6.  
  7.   $row = mysql_fetch_assoc($result);
  8.   $hours = $row['hours'];
  9.   $string = "<p>Total Hours: {$hours} Hours";
  10.  
  11.   $sql2 = "SELECT hours FROM {$conf['db_prefix']}_time WHERE `empid`='{$empID}'";
  12.   $result2 = mysql_query($sql2);
  13.  
  14.   $row2 = mysql_fetch_assoc($result2);
  15.   $used = 0;
  16.  
  17.   foreach($row2 as $time) {
  18.     $used = $used+$time;
  19.   }
  20.  
  21.   $string .= "<br />\nUsed Hours: {$used} Hours";
  22.   $left = $hours-$used;
  23.   $string .= "<br />\nHours Left: {$left}</p>";
  24.  
  25.   return $string;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement