On Sep 25, 2008, at 11:24 AM, Jason Pruim wrote:
On Sep 25, 2008, at 11:19 AM, Nathan Rixham wrote:
Jason Pruim wrote:
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
sounds like a mysql job.. whats the SQL?
Actually where this is displayed, it is just a display portion, but
when I do the insert here is my SQL:
switch ($_GET['opt']){
case "signin";
//$sqlopt = "INSERT INTO `timeStore` ('timein', 'timeout',
'empID') VALUES('{$timenow}', 'NULL', '{$auth['empID']}')";
$sqlopt = "INSERT INTO `timeStore` VALUES(\"{$timenow}\", \"NULL
\", \"{$_SESSION['userInfo']['empID']}\", \"\",
\"{$_SESSION['userInfo']['fullname']}\")";
break;
case "signout";
$sqlopt = "UPDATE `timeStore` SET `timeout`=\"{$timenow}\"
WHERE `empID`=\"{$_SESSION['userInfo']['empID']}\" AND `timeout`=
\"NULL\"";
break;
}
if(isset($_GET['opt'])){
mysql_query($sqlopt) or die("sqlopt failed: " .mysql_error());
echo "<BR>SQL OPT: ".$sqlopt."<BR>";
header("Location: timecard.php");
echo "BReaking at opt get";
}
Yes I know it's ugly with all the escaping but I'm working my way
through that :P
Per an e-mail I just received suggesting that it may be wise to
include the select SQL here it is:
$sql = "SELECT * from `timestore` order by `empID`";
$row[]= mysql_query($sql) or die("Could not perform query: " .
mysql_error());
$result = $row[0];
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
