[PHP] SESSION VARIABLES

[Ronald Ramos]

Hi All,

I've created 3 sample scripts, pls see below.
My problem is that page3.php can't display the value $username and
$password
Or is it because it the variables were not importe to that page, that's
why
$username and $password has no value? If it is, how can I import it?

Thank you

- login.php -






  
  USERNAME: 
  PASSWORD: 
  






-- auth.php -






function bukas() {
window.open(\"page3.php\",\"_new\");
};



$username

";
}

else {
echo "INVALID, TRY AGAIN";
};
?>

--- page3.php --



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] I think this is a mysql question

[Ronald Ramos]

How can I use PHP to compute the difference between two dates(with
time)?
Let's say in mysql, I have field 1, login, and on field 2, I have
logout.

How can I compute the diffrence between login and logut and output it on
field 3 let's say totaltime.

Is this a mysql question? Or can PHP actually do this?

TIA

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Re: I think this is a mysql question

[Ronald Ramos]

create table oras(
NameVARCHAR(30),
TimeIn DATETIME,
TimeOut DATETIME,
Total   DATETIME
);

insert into oras values('Nhadie','2004-10-10 10:10:00','2004-11-11
12:12:00','TIMEDIFF(TimeIn,TImeOut)');

Hi,

Are those correct? Because the value on the Total field is 000-00-00
00:00:00.
I think there's something wrong. I'm using 4.0.


mysql> select * from oras;
++-+-+--
---+
| Name   | TimeIn  | TimeOut | Total
|
++-+-+--
---+
| Nhadie | 2004-10-10 10:10:00 | 2004-11-11 12:12:00 | -00-00
00:00:00 |
++-+-+--
---+
1 row in set (0.01 sec)

TIA












-Original Message-
From: Justin Patrin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 12, 2004 9:08 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: I think this is a mysql question


Ronald Ramos wrote:

> How can I use PHP to compute the difference between two dates(with 
> time)? Let's say in mysql, I have field 1, login, and on field 2, I 
> have logout.
> 
> How can I compute the diffrence between login and logut and output it 
> on field 3 let's say totaltime.
> 
> Is this a mysql question? Or can PHP actually do this?
> 
> TIA

Both can do it, but it depends heavily on what type of date format it 
is. If it's a normal mysql date or datetime (not a timestamp) then you 
can grab it, then do:

$seconds = strtotime($field1) - strtotime($field2);

strtotime() does a good job of converting just about every type of 
formatted date.

If you're using a timestamp, there aren't any deliminators. I'm not sure

if strtotime() will parse those as you want. In this case (and the 
other, actually) you can easily use SQL.

SELECT UNIX_TIMESTAMP(field1) - UNIX_TIMESTAMP(field2) AS secondsBetween

FROM table

--
paperCrane 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php