Help for PHP time() function

[paispatin]

Dear all,

As we know we could use time() function, but I have some problem with it :

this is my code :

<?

$linux_time=time();
$normal_date=gmdate("d-m-Y",$linux_time);
$normal_time=gmdate("h:i A",$linux_time);

echo "unix time = $linux_time";
echo "<p>normal date = $normal_date";
echo "<p>normal time = $normal_time";

?>

The Problem is :
How to determine the first time of this day (with linux time)?

Something like this, if I have log all visitors web and save it at mysql (I save the time() output), than how to make a script to filter only the visitor at this day only could be show?

Thank you in advance.

 

[sleipnir214]

I would pass MySQL a query which had a clause:

where date(log_date_column_name) = '<needed_date>'


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[DRJ478]

Have you looked at the mysql column type TIMESTAMP? The first column of that type automatically sets itself when a new record is entered. It also updates when the record is altered.

 

[paispatin]

Thank for reply.
I try to make my problem simple, run that script at php server, the value is :


unix time = 1092634919
normal date = 16-08-2004
normal time = 05:41 AM


Well, at the unix time, how do I make it as 16-08-2004, 00:00 AM?

Thank you in advance.

 

[DRJ478]

Your solution lies in the following function:

http://www.php.net/manual/en/function.mktime.php

You have the day, month, and year for the nromal date available, so feed it into the mktime function with hour=0, minute=0, and second=0:

$midnight = mktime(date("m"), date("d"),  date("Y"));\