PHP - Issue In Getting The Time Difference Between Two Variables

Hey guys,

Say I have two variables, the first being $level_1 = '100'; and $level_2 = '1000';

is there anyway to work out the difference between the two and output it?

hello, im trying to figure out the difference between 2 numbers in minutes.  here is what i have:

Code: [Select]
$tsignin="09-05 10:30:00";
$tsignina="09-06 11:30:00";

$log_in_time_stringsa = strtotime($tsignin);
$log_out_time_stringsa = strtotime($tsignina);
$difference_in_secondssa = ($log_out_time_stringsa - $log_in_time_stringsa);
$tsigna = ($difference_in_secondssa / 60);
 
  $tsigna2 = number_format(round($tsigna));
the 09-05 is sept 5, and 09-06 is sept 6.

this works if the month and date are not included.  any ideas for me so i can figure out the total difference between date/times?

Hi,

Trying to figure out a way to get a time difference between two times assuming they are in order..

For example; in the array below the days is easy.. because the time happens later, however nights it becomes a little more confusing.

The method I'm using now is;

if the dates are in order just stick a reference date on there, and get a difference. If they seem to be reversed, I stick a reference date on the first one and a reference date +1 days on the second and get the difference.

Can you all think of a better way?

I will use the assumption that the times will NEVER be more than 24 hrs apart..

 

Array
(
    [2] => Array
        (
            [days] => Array
                (
                    [0] => 07:00:00
                    [1] => 15:45:00
                )

            [nights] => Array
                (
                    [0] => 15:30:00
                    [1] => 02:15:00
                )

        )

 

Hey guys,

What i would like to create is the ability to calculate the difference between two dates / times.

For example: 2010-12-13 10:00:00 to 2010-12-17 17:00:00

In a format of days / hours and minutes / seconds.

However, I only want to calculate for an 9-5 work day, not the hours outside. Is this possible? If so, how would I go about creating something like this.

if($_POST['Submit']=="Check"){

        $issueid=(int)$_POST['issueid'];
        $returndate=mysql_real_escape_string($_POST['returndate']);

        list($temp)=
                    mysql_fetch_row(mysql_query("select issueid FROM issue where issueid='$issueid'"));
         if($temp!=NULL){

        $insert_query="insert into returning values($issueid,'$returndate')";
        $result=mysql_query($insert_query,$linkID1);

        if($result){
            list($bookid,$account,$issuedate,$duedate)=
                    mysql_fetch_row(mysql_query("select bookid,account,issuedate,duedate FROM issue where issueid='$issueid'"));
            list($title,$name,$fine)=
                    mysql_fetch_row(mysql_query("select title,name,fine FROM book,user where bookid='$bookid' AND acc='$account'"));

            $insert_book="update book set copies=copies+1 where bookid='$bookid'";
            $result=mysql_query($update_book,$linkID1);

    



Quote

i want to take difference of

$duedate and $returndate

and store it to another variable 

checks that variable for number of days in it

 

Hey guys,
How would I go about subtracting Today from a previous day to find the difference?

For example, I want to subtract TODAY from a previous date in my database, to determine if the difference is greater than 1 day.

Any ideas? I tried doing the subraction in TIMESTAMPS, but when I convert the date back to Y-m-d H:i:s, I got some weird year and time.
 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=310181.0

Hi everyone,

I have this php code, which connects to a mysql database (through dbconnect.php) and is meant to select the lowest difference between two variables. I can't get very far. The most valuable differences are not the lowest per se, as much as the closest to 0, either positive or negative. Both numbers are positive integers. The page dictates the relative 'ranking' of the page, by multiplying the rank by 20, so that with each successive page, the retrospective line is 20 higher in ranking. The section 20*$page+x is not a value, but a ranking, so the instance would by, in words 'select the lowest difference between two numbers. If the number closest to 0 cannot be selected, can we find the highest value out of the two variables and subtract the lower (they are interchangeable)
Code: [Select]
<?php
 $page = $_GET['page'];
 include("dbc.php") //connect to mysql database
 $result = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +1}"); // { indicates my unsure section
while($row = mysql_fetch_array($result)){
 $id = $row['id'];
 $username = $row['id'];
 $sum1 = $row['id'];
 $sum2 = $row['id'];
}
 $result1 = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +2}"); // { indicates my unsure section
while($row1 = mysql_fetch_array($result1)){
 $id2 = $row['id'];
 $username2 = $row['id'];
 $2sum1 = $row['id'];
 $2sum2 = $row['id'];
}
//this continues with the mysql $page+x increasing successively 
?>
Also, could we apply a formula that would increase the weighting of those with a higher sum.

Thanks a lot, this is really over my head

Jack

Hi.

Need some help on one simple task yet so hard. I have puzzled on this for days and no luck. I have a great script i got from somewhere.

Code: [Select]
function get_time_difference( $start, $end )
{
    $uts['start']      =    strtotime( $start );
    $uts['end']        =    strtotime( $end );
    if( $uts['start']!==-1 && $uts['end']!==-1 )
    {
        if( $uts['end'] >= $uts['start'] )
        {
            $diff    =    $uts['end'] - $uts['start'];
            if( $days=intval((floor($diff/86400))) )
                $diff = $diff % 86400;
            if( $hours=intval((floor($diff/3600))) )
                $diff = $diff % 3600;
            if( $minutes=intval((floor($diff/60))) )
                $diff = $diff % 60;
            $diff    =    intval( $diff );           
            return( array('days'=>$days, 'hours'=>$hours, 'minutes'=>$minutes, 'seconds'=>$diff) );
        }
        else
        {
            trigger_error( "Ending date/time is earlier than the start date/time", E_USER_WARNING );
        }
    }
    else
    {
        trigger_error( "Invalid date/time data detected", E_USER_WARNING );
    }
    return( false );
}
Now the other part is that i have 3 textboxes and i woul like to add the first one like 15:00:00 the second one 18:30:00 and the third would display the difference in
lets say seconds. At least the function displays the results in seconds. But the problem is how to get the textbox to work whitout posting the info but to use onchange

Any ideas?
Code: [Select]
<input type="text" value="" name="start_time"/>
<input type="text" value="" name="end_time"/>
<input type="text" value="______" name="difference"/>

The below works for ?rma=non-returned and &year=$year, however once it's get down to month it doesn't work. Everything seems to be in the proper brackets, but it's still not working. It goes to a blank page when month=$month is added to the URL. The URL looks like this : ?rma=calander&year=2011&month=5
Code: [Select]
elseif($_GET['rma']=="calender"){
$sql101010="SELECT DISTINCT rma_year_issued FROM $tbl_name4 WHERE rma_issued='y' ORDER BY rma_year_issued";
$result101010=mysql_query($sql101010);
while($row101010=mysql_fetch_array($result101010)){
extract($row101010);
$content.='<a href="./acp_admincp.php?rma=calender&year='.$rma_year_issued.'">'.$rma_year_issued.'</a>
<br />';
}

if(isset($_GET['year'])){
$content="";
$logout.=' | <a href="./acp_admincp.php?rma=calender">Back to RMA Calender</a>';
$rma_year_issued=$_GET['year'];
$sql111010="SELECT DISTINCT rma_month_issued FROM $tbl_name4 WHERE rma_year_issued='$rma_year_issued' ORDER BY rma_month_issued";
$result111010=mysql_query($sql111010);
while($row111010=mysql_fetch_array($result111010)){
extract($row111010);
if($rma_month_issued=="1"){$rma_month_issued2="January";}
if($rma_month_issued=="2"){$rma_month_issued2="February";}
if($rma_month_issued=="3"){$rma_month_issued2="March";}
if($rma_month_issued=="4"){$rma_month_issued2="April";}
if($rma_month_issued=="5"){$rma_month_issued2="May";}
if($rma_month_issued=="6"){$rma_month_issued2="June";}
if($rma_month_issued=="7"){$rma_month_issued2="July";}
if($rma_month_issued=="8"){$rma_month_issued2="August";}
if($rma_month_issued=="9"){$rma_month_issued2="September";}
if($rma_month_issued=="10"){$rma_month_issued2="October";}
if($rma_month_issued=="11"){$rma_month_issued2="November";}
if($rma_month_issued=="12"){$rma_month_issued2="December";}
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'&month='.$rma_month_issued.'">'.$rma_month_issued2.'</a>
<br />';
}
if(isset($_GET['month'])){
$content="";
$logout.=' | <a href="./acp_admincp.php?rma=calender&year='.$rma_year_issued.'">Back to RMA Calender Year</a>';
$rma_month_issued=$_GET['month'];
$sql211010="SELECT * FROM $tbl_name4 WHERE rma_year_issued='$rma_year_issued' AND rma_month_issued='$rma_month_issued' ORDER BY rma_date_issued";
$result211010=mysql_query($sql211010);
while($row211010=mysql_fetch_array($result211010)){
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'&month='.$rma_month_issued.'&id='.$rma_id.'">'.$rma_number.'</a>
<br />';
}
}
}
}

The issue maybe the AND in the SQL query... however I need to be sure that the data pulled is of that specific month and that specific year. Not one or the other.

About to pull my hair out.  Looks simple, I think it's simple, but something is not behaving.  I have a simple login page (loginpage.php) which checks a database for the FamilyID and Password, if it is a match, then it redirects them to userspage.php.  I eventually want to use the FamilyID as a filter for my database so I only show the stuff relative to that FamilyID.  Using CS5 and the built in functions, and it looks to me that the session variable 'MM_Username' should contain the FamilyID which is "adminid" in my database.  It appears to work since it sends me to my userspage.php when I enter a valid FamilyID and Password, but it will not show me my session variable on the that page!!! PLEASE PLEASE HELP...Slap me in the face if it's a stupid question, but I have spent WAY too much time trying to figure what is wrong.  I have included my code:

 

CODE FOR LOGINPAGE.PHP

 

<?php require_once('Connections/MyTest.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
?>
<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['familyid'])) {
  $loginUsername=$_POST['familyid'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "userspage.php";
  $MM_redirectLoginFailed = "loginpage.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_MyTest, $MyTest);
 
  $LoginRS__query=sprintf("SELECT adminid, password FROM `admin` WHERE adminid=%s AND password=%s",
    GetSQLValueString($loginUsername, "int"), GetSQLValueString($password, "text"));
   
  $LoginRS = mysql_query($LoginRS__query, $MyTest) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
   
if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;     

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>">
  <p>
    <label for="familyid">FamilyID:</label>
    <input type="text" name="familyid" id="familyid" />
  </p>
  <p>
    <label for="password">Password:</label>
    <input type="text" name="password" id="password" />
  </p>
  <p>
    <input type="submit" name="Submit" id="Submit" value="Submit" />
  </p>
</form>
</body>
</html>

 

 

CODE FOR USERSPAGE.PHP

 

<?php
if (!isset($_SESSION)) {
  session_start();
}
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<strong>YOU MADE IT!
</strong>
<?php echo $_SESSION['MM_Username']; ?>
</body>
</html>

 

 

THANKS IN ADVANCED!!!

Hi,

I have time and date stored in variables in the following format...
08:00AM
and
03/07/2011

How do I go about converting those, to yyyy-mm-dd hh:mm:ss format.. to then insert into a sql table...

Any help would be appreciated thank you..

jeff

When a user logs into my site I was to store the user_name, user_role, and user_id in a session variable, then store this in a regular variable to make querying easier, but I am having issues with my code as its causing issues with my queries.

Code: [Select]

if (mysqli_num_rows($data) > 0) {
  //set sessions
    $row = mysqli_fetch_array($data);
    $_SESSION['username'] = $row['username'];
    $_SESSION['user_role'] = $row['role'];
    $_SESSION['user_id'] = $row['user_id'];
         
           
  //set variables
    $username = $_SESSION['username'];
    $user_role = $_SESSION['user_role'];
    $user_id = $_SESSION['user_id'];

}


Any ideas whats wrong?!
Thanks for the help!!

ARRAY Example scaled down to two (renamed example only) fields

$data = array(
"field1" => "Text within quotes processes OK",
"field2" => "Text within quotes processes OK"
);

The frustating thing has been trying to figure out how to
substitute actual text data contained in these 2 example
variables to use data from a MySQL query:

$text1 = $db_field['sampletext1'];
$text2 = $db_field['sampletext2'];

I have tried:

$data = array(
"field1" => $text1,
"field2" => $text2
);

*** (AND) ***

$data = array(
"field1 => '$text1',
"field2 => '$text2'
);

But neither approach works, even though the text in both
$text1 and $text absolutely works IF I (manually) type the
actual text within double-quotes like this:

$data = array(
"field1 => "text1",
"field2 => "text2"
);

I also tried using strval but that did not work.

So how on earth to get the (actual) text from $text1 and
$text2 into the two array fields as-if the contained text
would  (manually) be typed in double-quotes is the Mystery.

It is probably something simple, so maybe I don't know
exactly what to search for in seeking code snippet examples?

Thanks for any enlightenent.

-FreakingOUT

 

 

Edited January 28, 2019 by FreakingOUT

Hello I am trying to only display results within the time period last sunday too next sunday. my code:
Code: [Select]
<?php
$today = date('Y-m-d H:i:s');
$time = strtotime($today);
$last_sunday = strtotime('last sunday', $time);
$next_sunday = strtotime('next sunday', $time);
$format = 'Y-m-d H:i:s';
$last_sunday = date($format, $last_sunday);
$next_sunday = date($format, $next_sunday);
?>
<?php
$sql_totalsurfs = ("SELECT vtp_members.id, vtp_members.name, vtp_members.teamleader, vtp_tracking.Timber, vtp_tracking.Stone, vtp_tracking.Marble, teams.team_name, count(vtp_tracking.id) surfs
FROM vtp_members, vtp_tracking, teams
WHERE vtp_members.team_id=".$_GET['t']." AND vtp_tracking.credit_members_id=vtp_members.id AND vtp_tracking.action_date>'$last_sunday' AND vtp_tracking.action_date<'$next_sunday'
GROUP BY vtp_members.id
ORDER BY surfs DESC LIMIT 0, 10");
$rstotalsurfs = mysql_query($sql_totalsurfs);
$numrows = mysql_num_rows($rstotalsurfs);
.......
Is there and error somwhere in the code?