PHP - Calculating Time Left Using 2x Int Values

Hi!
I have this to check if now is between start time and end time:


[date_default_timezone_set('Europe/Belgrade');



$TimeNow = date("H:i" ,time());
$today_date = date('d-m-y');
$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";
$ConnectTimeTable = $database->query($GetTimeTable);
$TimeTable = mysql_fetch_array($ConnectTimeTable);

$Subject = $TimeTable['Subject'];

$Start_time = $TimeTable['Start_Time'];
$End_time = $TimeTable['End_Time'];

?><br><?



if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;
echo "<br><br>";
// a START time value
$start = $TimeNow;
// an END time value
$end   = $End_time;

// what is the time difference between $end and $start?
if( $diff=@get_time_difference($start, $end) )
{
  echo "Time left: " .
       sprintf( '%02d:%02d', $diff['hours'], $diff['minutes'] );
}
else
{
  echo "Hours: Error";
}



}
else{
echo "No class. :)";
}


Start time and end time is displayed in the format like 14:26.

For some reason this code doesn't work though, I don't get why.

I am in need of suggestions on how too achive this:

I have a surf exchange and whenever a member has viewv a site, it ads this members Id and time to a table called vtp_tracking.

I have now created a team script, so I can count the total of surf for members within this team from the vtp_table.

What I am in need of is this:
I would like to add a bonus for the teams, so my idea was this: every hour run a cronjob to get the results for the last hour by team id lik so:

Code: [Select]
WHERE vtp_members.team_id="teamid" AND vtp_tracking.credit_members_id=vtp_members.id AND vtp_tracking.action_date>date_sub(NOW(),interval 60 minute
I believe the above code will work fine and get me the results for team members for the last hour.

Problem: how can I get this result, multiple it with the value from another field and divide by 100  and add this to a third field?

eg: (result from above * value from other field / 100) then add to a third field.

Anyone willing to try and answer this one?

Hi,

I'm inserting hours and minutes per user into a database where they have their own fields.
(userid, hours, mins)

I've a small issue when displaying the data.

When I run my query I sum the total hours and minutes per user which results in data such as the following

userid1 - 2  hours 15 mins
userid2 - 1 hour 100 mins

The query orders by hours and then mins desc

When I'm displaying the data (as I'm looping through the results array) I perform a calculation to convert the mins to hours so it now reads

userid1 - 2 hours 15 mins
userid2 - 2 hours 40 mins

so the webpage displays userid1 first when i want userid2 to be the first record displayed (Hours desc)

Can anyone recommend a solution to this ?
Will I need to create another table and update it as hours and minutes are being entered and display results from that table instead ?
Can I order the data after I carry out the mins to hours calculation ?

many thanks in advance for any suggestions....

tmfl

Is there a recommended way to code in order to have a dual language support, especially when one is English (left to right), and the other is Hebrew (right to left)?

Should I design every page twice or is there a ready made solution?

Not asking someone to do this for me. Just looking for someone to help me get going, and show me how to do this.


Need helping calculating text boxes on a form. I want my form to display the premium of $10,000 health insurance. What I mean by this is that I have a form that involves filling out life insurance information.

This is the table I'm basing this off of...

                                                      Age <=30
#health conditions <=2                   $0.90
2 <= #health conditions <=5           $1.20



The number of health conditions is equivalent to the number of check boxes that were checked. Additionally,
the following conditions apply:

- Men are charged a 5% gender risk
- Students receive an 8% discount

For example, if you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm new to php and haven't really calculated forms before...


here is my form codes....



Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>

I have a form that I will post the code for. In my form I have a few things that need to be filled out.... Age, Gender, Coverage Amount, and Health Conditions.

The Health Conditions are 5 check boxes the user can select.

Now what I'm trying to do is make it so that when the user hits submit the Age and number of Health Conditions checked off will do this...

if # of Health Conditions <=2 and Age is <= 30 then = $0.90

if # of Health Conditions =>2 but <=5 and Age is <= 30 then = $1.20

Then after those are calculated I need these to apply to the code...


- Men are charged a 5% gender risk
- Students receive an 8% discount


Here is a example of what I'm trying to get this to do...

If you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm doing a life insurance form and these are some of the calculations that need to go into it. I'm not sure how I would code these. If someone could help me get started that would be great.



Here is my form code and the display page.


Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>



Display Page




Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

   

    <head>

        <title>Lab4</title>

       

    </head>

    <body>

    <div id="page">

        <div id="main">






        <div id="content">

           

            <h2>Life Insurance</h2>

            <table>

                <tr>

                    <th>Coverage Amount</th>

                    <th>Name</th>

                    <th>Gender</th>

<th>Age</th>

<th>Health Conditions</th>

<th>Employment Status</th>

<th>Comments</th>



                </tr>

<?php

$coverage_amount = $_POST['coverage_amount'];
$age = $_POST['age'];
$health = $_POST['health'];


if $age = 



?>










                                <tr>



                    <td><?php echo $_POST['coverage_amount'];?></td>

                    <td><?php echo $_POST['first_name'];?></td>

                    <td><?php echo $_POST['gender'];?></td>

<td><?php echo $age?></td>

<td class="right"><?php echo $_POST['health'];?></td>

<td class="right"><?php echo $_POST['employment'];?></td>

<td><?php echo $_POST['comments'];?></td>



                </tr>

                 

                            </table>

        </div>

        </div>

        <div id="footer"></div>

    </div>

    </body>

</html>

Hi everyone,
I'm trying to add up the current time with a specified amount of seconds and insert it in a database afterwards.
When I add say: 500 seconds to the current time it adds a whole lot more and I get a number few thousands higher than I want. Can anyone help me???.
Gr Ryflex

I have a timestamp field in my mySQL table and need to check if it's 14 day or older.  What's the best way to do this?

Any help will be appreciated

Okay guys, I figured out how to calculate monthly subscriptions into days, but I am stuck on calculating multiple monthly subscriptions.. for example

Heres my mysql table:


How would I calculate this:
Subscription Start: February 21, 2011, 12:00 am
Subscription End: April 22, 2011, 12:00 am
Subscription Left: 60 days

My trouble is that when the user buys another month, it calculates the end time based on the new "Subscription Start Date". Or vice versa.

Any ideas guys?
Thanks.

Hi, im trying to calculate and display a time elapsed from known date in db. however im having trouble displaying it. other values display no problem, just cant calculate and display date on the fly. does anyone see a problem with my query? thank you.

Code: [Select]
<?php
include('config.php');
$uname=$_SESSION['username'];
if($_SESSION['username']){
$sql="SELECT country, nationality, passportDate FROM country WHERE uname='$uname'";
$result = mysql_query($sql) or die(mysql_error());
$passportDate _ts = strtotime($row['passportDate ']);
$passportDate _str = date("M-d-Y", $passportDate _ts);
$TotalTime = floor((time() - $passportDate _ts)/(60*60*24)) . ' days'; 

while($row=mysql_fetch_array($result))  {

 echo "<table border='0'>
  <tr>
  <th>Nationality</font></th>
  <th>Country</font></th>
  <th>Passport Seent Date</font></th>
  <th>Time Elapsed</font></th>
  </tr>";

  echo "<tr>";
  echo "<td>" . $row['nationality']."</td>";
  echo "<td>" . $row['country'] . "</td>";
  echo "<td>" . $row['passportDate '] . "</td>";
  echo "<td>" . ('$TotalTime') . "</td>"; 
  echo "</tr>";
  }
  echo "</table>"; 
  }
?>

I tried using a for loop but I'm trying to think of a way to calculate interest for a number of years but after I have the amount of interest for one year I'm unsure of how to add the interest to the principle then calculate it again for the next year, to hold that number like $Principle + $Interest = $NewPrinciple then $NewPrinciple + $Interest for multiple years.  

<?php
if (isset($_POST['submit'])) {
	$InvestmentFrequency = $_POST['InvestmentFrequency'];
	$CompoundFrequency = $_POST['CompoundFrequency'];
	$InitialInvestment = preg_replace("/[^0-9]/", '', $_POST['InitialInvestment']);
	$Contributions = preg_replace("/[^0-9]/", '', $_POST['Contributions']);
	$InvestmentLength = preg_replace("/[^0-9]/", '', $_POST['InvestmentLength']);
	$InterestRate =  $_POST['InterestRate'];
	
	if ($InvestmentFrequency == "Weekly") {
	$InvestmentFrequency = "52";
	} elseif ($InvestmentFrequency == "Monthly") {
	$InvestmentFrequency = "12";
	} else {
	$InvestmentFrequency = "1";
	}
	
	if ($CompoundFrequency == "Annually") {
	$CompoundFrequency = "1";
	} elseif ($CompoundFrequency == "Semiannually") {
	$CompoundFrequency = "2";
	} elseif ($CompoundFrequency == "Monthly") {
	$CompoundFrequency = "12";
	} elseif ($CompoundFrequency == "Weekly") {
	$CompoundFrequency = "52";
	} else {
	$CompoundFrequency = "365";
	}
	
	if ($CompoundFrequency == "1") {
	$AdditionalInvestments = $Contributions * $InvestmentFrequency;
	$Principle = $InitialInvestment + $AdditionalInvestments;
	$Interest = $Principle * $InterestRate;
	$NewPrinciple = $Principle + $Interest;
	
		for ($x = 0; $x <= $InvestmentLength; $x++){
			echo "$x - $NewPrinciple</br>";
		}
	}
	
}

This is the output I get the principle and interest added together for the number of years I entered.

Edited July 26, 2020 by dataxspy

hi all,

i'm trying to calculate the time difference between two dates in hours, for example: 2010-12-13 15:26:56 and 2011-12-13 15:26:56
i tried mktime but wasn't able to get a working function.

Thanks for the help

Hi,

This query will show match stats of a user, the query is the output in the attatchment.
I want to calculate the streak if score1 is greater than score2. So basically, in the attatchment I have selected 3 rows, these 3 rows should be a 3 streak because the user won 3 matches in a row (according to date)

Code: [Select]
SELECT * FROM webs_cup_matches WHERE ladID='17' AND (clan1 != '0' AND clan2 != '0') AND (clan1='2630' || clan2='2630') AND (clan1 != '2147483647' AND clan2 != '2147483647') ORDER BY date DESC
any help appreciated.

I have a table with Territory Representative Sales.  It has columns that go back 26 months.  The columns are SALES_OLDEST_PD_1, SALES_PD_2, SALES_PD_3, ..... SALES_PD_25, SALES_LAST_PD_26, & SALES_CURR_PD_27.   SALES_CURR_PD_27 is the current month.

I want to build a table with "Last Year To Date Sales" (LYTD), "Current Year To Date Sales" (CYTD), (May 2011), and (May 2010).  I know that (May 2011) will be SALES_CURR_PD_27 and (May 2010) will be SALES_PD_15.

The trick is that the sales year starts in November.  So, I need to figure out a way to match the table columns with "Nov. 09 - May. 10 TOTAL" for (LYTD) and "Nov. 10 - May. 2011 TOTAL" for (CYTD). I am familiar with using mktime() to subtract months.  But, I am not sure where to start yet on this project.

Jake
Code: [Select]
while (odbc_fetch_row($rs))
  {
$M1 += odbc_result($rs,"SALES_OLDEST_PD1");
$M2 += odbc_result($rs,"SALES_PD2");
$M3 += odbc_result($rs,"SALES_PD3");
$M4 += odbc_result($rs,"SALES_PD4");
$M5 += odbc_result($rs,"SALES_PD5");
$M6 += odbc_result($rs,"SALES_PD6");
$M7 += odbc_result($rs,"SALES_PD7");
$mate += odbc_result($rs,"SALES_PD8");
$M9 += odbc_result($rs,"SALES_PD9");
$M10 += odbc_result($rs,"SALES_PD10");
$M11 += odbc_result($rs,"SALES_PD11");
$M12 += odbc_result($rs,"SALES_PD12");
$M13 += odbc_result($rs,"SALES_PD13");
$M14 += odbc_result($rs,"SALES_PD14");
$M15 += odbc_result($rs,"SALES_PD15");
$M16 += odbc_result($rs,"SALES_PD16");
$M17 += odbc_result($rs,"SALES_PD17");
$M18 += odbc_result($rs,"SALES_PD18");
$M19 += odbc_result($rs,"SALES_PD19");
$M20 += odbc_result($rs,"SALES_PD20");
$M21 += odbc_result($rs,"SALES_PD21");
$M22 += odbc_result($rs,"SALES_PD22");
$M23 += odbc_result($rs,"SALES_PD23");
$M24 += odbc_result($rs,"SALES_PD24");
$M25 += odbc_result($rs,"SALES_PD25");
$M26 += odbc_result($rs,"SALES_LAST_PD26");
$M27 += odbc_result($rs,"SALES_CURR_PD27");
  }
Note: By the way SMF is changing $M"8" to $M"ate". lol

Hello,

I am having a heck of a time trying to get time right on my website lol  When a user logs in, they select what timezone they are in (UTC -1,-2,-3,-4,-5,-6....)  Now this is great an all, but with daylight savings time my times are off by one hour in either direction.  How do sites like this get times to work for users so easily?

Thanks!
weee