Math problems (No not high school math!)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



So I'm trying to figure out how to do a little math in php to add up the number of hours that people have worked (Still on the timecard for anyone following along at home)

I have it inserting time in and timeout as timestamps into a MySQL database, from there, I use a while loop to display the total hours for the day which works perfectly, now though, they want it to total for the week...

I think what I need to do is create an array of my total time for the day then add that up in another loop to display the total... That seems like overkill to me though... is there a better way to do it?

Here is the relevant part of the code:

while ($row = mysql_fetch_assoc($result)){
			$timein = date("m/d/y h:i:s", $row['timein']);
			$timeout = date("m/d/y h:i:s", $row['timeout']);
			$totalday = ($row['timeout'] - $row['timein']);
			$totalday = $totalday/60/60;
			$totalday = round($totalday, 2);
			$totalweek = ?!@?#!@#?!@#!$%^!23?!@#!@#?!@#?#$&*^
			
			echo <<<ADMIN
			
		
			<tr>
			<td>{$row['Name']}</td>
			<td>{$timein}</td>
			<td>{$timeout}</td>
			<td>{$totalday}</td>
			
			</tr>
			
ADMIN;
		}	
		echo "</table>
		</div>
		</body>";

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux