Date calculation from MySql table

I want to calculate the registed users today
Also total users this week
Total users this month
Total users this year

The Mysql table has a row of INT(11) with time() value inserted.

I did something like this
$today = strtotime("+1 day")
Then $sql = "SELECT COUNT(*) FROM table WHERE dateReg <= $today";

Same with year/months also, only I use strtotime("+1 week) for a week,
strtotime("+1 month) for a month,

Can someone help me with this calculation?

On 4/7/08, Bruno Lustosa wrote:
> On Mon, Apr 7, 2008 at 2:42 PM, Dee Ayy wrote:
> > I was thinking of using output buffering and then making 1 call to
> > utf8_encode, but I think a better question is, how do I stop using
> > utf8_encode completely?
>
> If all components are using utf-8, you should have no problems with
> charsets at all. By all components, I mean:
> - Script files in utf-8;
> - Database in utf-8;
> - Database connection using utf-8;
> - Content-type header set to utf-8.
> With all these, you're free of charset hell, and can enjoy the beauty
> of utf-8 completely without problems.
>
> > The rendered view I see in Firefox 2.0.0.12 is a question mark "?"
> > where the French character should have appeared. If I use
> > utf8_encode, the character appears as it should.
>
> Question mark means the character is not utf-8. Check where it comes
> from. Might be the database or the way you are connecting to it. I
> don't know much about mysql, I use postgresql. With it, you just have
> to call pg_set_client_encoding() to make the connection in utf-8 mode,
> and "create database with encoding='unicode'" to set up a database
> using utf-8.
>
> > Luckily I'm on PHP 4.3.10, so I can't see what mb_check_encoding would
> > report -- if that would even help normally.
>
> Shouls upgrade to PHP 5. PHP 4 is way out of date, is not getting
> updates anymore, and will not even get security bugfixes after august
> 8th. It's been almost 4 years since PHP 5 was released.
>
> http://www.php.net/archive/2007.php
>
> Check the PHP 4 end of life announcement.
>
> --
> Bruno Lustosa
> ZCE - Zend Certified Engineer - PHP!
> http://www.lustosa.net/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
I develop dynamic website with PHP & MySql, Let me know about your site

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

Re: Date calculation from MySql table

Something like this should work.

$today = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$tomorrow = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"));
$sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$today} AND
{$tomorrow}";

$thismonth = mktime(0, 0, 0, date("m"), 1, date("Y"));
$nextmonth = mktime(0, 0, 0, date("m") + 1, 1, date("Y"));
$sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$thismonth}
AND {$nextmonth}";

$thisyear = mktime(0, 0, 0, 1, 1, date("Y"));
$nextyear = mktime(0, 0, 0, 1, 1, date("Y") + 1);
$sql = "SELECT COUNT(*) FROM table WHERE regdate BETWEEN {$thisyear} AND
{$nextyear}";

HOWEVER, consider to use the mysql date functions instead of a unix
timestamp.

A. Joseph wrote:
> I want to calculate the registed users today
> Also total users this week
> Total users this month
> Total users this year
>
> The Mysql table has a row of INT(11) with time() value inserted.
>
> I did something like this
> $today = strtotime("+1 day")
> Then $sql = "SELECT COUNT(*) FROM table WHERE dateReg <= $today";
>
> Same with year/months also, only I use strtotime("+1 week) for a week,
> strtotime("+1 month) for a month,
>
> Can someone help me with this calculation?
>
> On 4/7/08, Bruno Lustosa wrote:
>
>> On Mon, Apr 7, 2008 at 2:42 PM, Dee Ayy wrote:
>>
>>> I was thinking of using output buffering and then making 1 call to
>>> utf8_encode, but I think a better question is, how do I stop using
>>> utf8_encode completely?
>>>
>> If all components are using utf-8, you should have no problems with
>> charsets at all. By all components, I mean:
>> - Script files in utf-8;
>> - Database in utf-8;
>> - Database connection using utf-8;
>> - Content-type header set to utf-8.
>> With all these, you're free of charset hell, and can enjoy the beauty
>> of utf-8 completely without problems.
>>
>>
>>> The rendered view I see in Firefox 2.0.0.12 is a question mark "?"
>>> where the French character should have appeared. If I use
>>> utf8_encode, the character appears as it should.
>>>
>> Question mark means the character is not utf-8. Check where it comes
>> from. Might be the database or the way you are connecting to it. I
>> don't know much about mysql, I use postgresql. With it, you just have
>> to call pg_set_client_encoding() to make the connection in utf-8 mode,
>> and "create database with encoding='unicode'" to set up a database
>> using utf-8.
>>
>>
>>> Luckily I'm on PHP 4.3.10, so I can't see what mb_check_encoding would
>>> report -- if that would even help normally.
>>>
>> Shouls upgrade to PHP 5. PHP 4 is way out of date, is not getting
>> updates anymore, and will not even get security bugfixes after august
>> 8th. It's been almost 4 years since PHP 5 was released.
>>
>> http://www.php.net/archive/2007.php
>>
>> Check the PHP 4 end of life announcement.
>>
>> --
>> Bruno Lustosa
>> ZCE - Zend Certified Engineer - PHP!
>> http://www.lustosa.net/
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>
>


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