[Resolved] Adding-Up Variables

[partypete]

Hello AGAIN 😃 ,

Is there a way to add-up variables when sent to a page via a url like below:

http://www.mydomain.com/project/hours.php?time_worked=173&time_worked=18182&time_worked=66206&time_worked=90574....con't....

All the variables are named "time_worked" and represent seconds. I would like to add-up all the variables into one big number which I will then convert into hours and minutes.

Keep in mind that the NUMBER of variables in the url will change all the time. There could only be 2 variables one time, and 15 the next.

Any way to total these numbers up?

THANKS!!

[craigh]

that is poor design. all the variable names on any page should be unique. In your case I would suggest an array. Then adding is easy because you can loop the array and add all the values.

[bubblenut]

You can't have more than one variable with the same name, each subsequent setting of the variable will overwrite the previous.
HTH
Rob

[partypete]

Hi Craigh and bubblenut,

The reason they are all named the same is because they come from a hidden field which is created as several records repeat down the page. I can easily give them unique names by adding the record id to the front of the variable name such as 12time_worked, 15time_worked etc if that would help?

Basically I have "seconds" for each record that appears on the page, and what I need to do is add them all up and then convert them to hours and minutes. If these seconds came from the database, that'd be no problem, but each records "seconds" is generated on the page. The only way I can thing of to add them up is to now submit all the seconds back to the page and add them up, then convert them to hours and minutes. Know what I mean? If I knew of an easier way... :-)

Don't suppose you know of a tutorial which would explain how to add these up using an array?

Thank ya kindly!

[HalfLife]

I don't quite understand what you want to do with this, but to add the variables you can do this:

Make sure to add a numerical id to each variable and to link a variable (let's say, $repeats) which will count the amount of the variables.

for (i=0; i <= $_GET['repeats']; i++){
     $secs = $_GET['repeats'.$i];
     $total_secs += $secs;
}

[partypete]

Hey HalfLife,

All I'm trying to do is gather up all the "seconds" that an employee has worked, so I can add them together, and display exactly how many hours and minutes that employee has worked in a week for example.

You can see what I'm working on here:

http://www.johans.com/intranet/timesheet/hours.php?un=peter&date_from=2003-11-23&date_to=2003-11-29&Submit=Search

I just want to gather up all the time in the right hand column so I can put a Total at the bottom. Sounds easy huh? 😕

Could you help me understand your code a bit more?
1- Do the numbers I attach to my variables have to be in any specific order? or is 35time_worked 982time_worked ok? How will the loop know which variables to add?

2- How would I link a variable? (Saw that one comin' didn't ya?)

Sorry, the implementation of this code just isn't clear to me yet.

Thanks everyone for your help so far.

[drawmack]

instead of adding the record id just increment them so you get variables named time_worked_1 through time_worked_n (where n is the number of time worked variables. So you'll have a query string that looks like this:

?time_worked_1=x_1&time_worked_2=x_2&...&time_worked_n=x_n

where x_n is the number of seconds worked. Then you can do this:

<?
$iteratore = 1;
$total = 0;
while(isset($_GET['time_worked_'.$iterator])) {
    $total += $_GET['time_worked_'.iterator];
    $iterator++;
} //end while

//calculate hours worked
$hours = (int)($total/3600);
//calculate minutes worked
$minutes = (int)(($total - (3600 * $hours))/60);
//calculate the seconds worked
$seconds = $total - (3600 * $hours) - (60 * $minutes);

echo "You worked " . $total . " seconds (" . $hours . ":" . $minutes . "." . $seconds . ")<br />\n";
?>

[HalfLife]

I see.
Well, the numbers you attach must be in an order: 1time_worked 2time_worked 3time_worked 4time_worked 5time_worked..etc...

The For loop uses the $i variable and increases it each time it goes through the loop.
Then I'm calling the variable $time_worked but I'm adding it $i,
then I simply add $time_worked+i to another $total_secs variable which counts the total seconds.

But I don't think it's a good way to get what you wanted.

[partypete]

HalfLife,

Thanks for tryin', I'm not the best student. :rolleyes:

Drawmack,

Well I did as you instructed, but unfortunately it results in all 0's. This is what I have....

Ok, so now when I submit the form, the url looks like:

http://www.--------------/hours.php?tw_1=173&tw_2=18182&tw_3=66206

I also tried:

http://www.--------------/hours.php?tw_1=173_1&tw_2=18182_2&tw_3=66206_3

I am sending a couple extra variables, could this cause a problem?

http://www.--------------/hours.php?tw_1=173_1&tw_2=18182_2&tw_3=66206_3&un=peter&date_from=2003-11-23&date_to=2003-11-29&count_hours=Y&Submit2=Calculate+Hours

The PHP code I altered to match as follows:

<? 
$iteratore = 1; 
$total = 0; 
while(isset($_GET['tw_'.$iterator])) { 
    $total += $_GET['tw_'.iterator]; 
    $iterator++; 
} //end while 

//calculate hours worked 
$hours = (int)($total/3600); 
//calculate minutes worked 
$minutes = (int)(($total - (3600 * $hours))/60); 
//calculate the seconds worked 
$seconds = $total - (3600 * $hours) - (60 * $minutes); 

echo "You worked " . $total . " seconds (" . $hours . ":" . $minutes . "." . $seconds . ")<br />\n"; 
?>

The output is just "You worked 0 seconds (0:0.0)"

Not sure where the heck I went wrong. Do you see anything wrong with this?

Thanks again,

[partypete]

Ok, so this is actually what I have now:

<?php 
$iteratore = 1; 
$total = 0; 
while(isset($_GET['tw_'.$iterator])) { 
$total += $_GET['tw_'.iterator]; 
$iterator++; 
} //end while
$hours = floor($total/3600);
$remaining_seconds = $total - $hours*3600;
$minutes = floor($remaining_seconds/60);
if ($minutes < 10) { echo "<strong>$hours:0$minutes</strong>"; } else { echo "<strong>$hours:$minutes</strong>"; }
?>

Still no clue why it isn't working... All this outputs is 0:00

Thanks for your help, and patience!

[drawmack]

<?php 
$iteratore = 1; 
$total = 0; 
while(isset($_GET['tw_'.$iterator])) { 
//you're appending iterator not $iterator try this
$total += $_GET['tw_'.$iterator]; 
$iterator++; 
} //end while
$hours = floor($total/3600);
$remaining_seconds = $total - $hours*3600;
$minutes = floor($remaining_seconds/60);
if ($minutes < 10) { echo "<strong>$hours:0$minutes</strong>"; } else { echo "<strong>$hours:$minutes</strong>"; }
?>

[partypete]

Hey thanks for the help.

I had caught the missing $ earlier but it didn't change anything but it was part of the solution. The other problem was a simple typo at $iteratore = 1; . Iteratore instead of itorator!!! :rolleyes:

I changed both of these and now it appears to be working!

Thank you all for your help. This finished up my current project!

Happy Holidays!

Peter