Date function in php?

Dakkar

I want to add a date funtion in my php script but i dont know how can i do it

I have an online account system and i want my account system store for every user when they registered to our database.And then i want to show a list who registered today and who registered yesterday etc....
is that possible? if it is how ? can you help me?

olaf

Look for info about 'NOW()' in the mysql documentation

Dakkar

Can you give me the url please

and is it possible to enter a date function for every user who registered today without php (only mysql)

olaf

do you know the website of mysql?

just www.mysql.com/now

how do you want to handle mysql via the webrowser without PHP?

phpprogrammer

hi,

you can use the following code

<?php

$uname=$GET["username"];
$pword=$GET["password"];

mysql_connect("servername","username","password");
mysql_select_db("databasename");

$query="insert into tablename(username,password,registereddate) values('".$uname."','".$pword."',now())";
$result=mysql_query($query);

regards
bvsureshbabu

Dakkar

Thanks it works
but i want one more thing.I am doing this account system for showing how many times(They register to my account system after 3 months their account close if they dont pay) of customers has left since they registered.Because of this can i erase the time part i want only date time to be show.But when i use now() it is showing like this

2004-03-18 11:08:54

is it possible to delete time part

my second question is if i can delete the time part can i show the accounts which will be close today in a table is it possible?

Thanks

Weedpacket

Originally posted by Dakkar
is it possible to delete time part

If it is then I'm sure the MySQL documentation will have something on the subject. Probably listed under Date and Time functions (you know, those functions that NOW() is one of? You know, that function olaf gave you the link for?).

Dakkar

I tried this but it didnt work

$tarih = select date(now());

$query="insert into tablename(username,password,registereddate) values('".$uname."','".$pword."','$tarih')";

prinzcy

just use NOW() if you just want the date without time.

it's like $tarih=NOW()

try it

cahva

You probaply have field registereddate as DATETIME type. Change it to DATE only. Then it inserts only 2004-03-18 with NOW().

Dakkar

Thanks it works fine now.
I want one more thing to do.
I want my account sistem to show the accounts which will close today(because of expiration of 90 days period)
How can i check it.Can i do something like this

if (now() == ($registerdate+90)) {

is it possiible if it is not how can i do something like this?

PurpleMonkey

Another way to do it is to use the date() function. If you supply it with specific arguements, then it will return a date in the format you want it, like:

$mydate = date('D');
echo($mydate);

Would return the shorthand version of the day of the week, so Thur. Have a look at [man]date()[/man] for more info.

Dakkar

if (now() == ($registerdate+90)) {

is it possiible if it is not how can i do something like this?

Dakkar

any idea?

prinzcy

have you try that?

Dakkar

I tried but it didnt work.
Are there any solution?

prinzcy

maybe you could try using something like add in your select statement INTERVAL 90 DAY or something like that

i can't remember the code but try search for it using mysql or read this manual

Dakkar

I tried this

$ek1 ="select adddate(now(), INTERVAL 90 DAY)";
$ektarih = mysql_query($ek1) OR die(mysql_error());


 @mysql_query("insert into accounts values('','$u_name','$pass','$momname','$anne','$ektarih',now(),'$mail','0','0','0','0','0','0','0')");

but it s showing like this in mysql 0000-00-00

where is the problem?

mrhappiness

mysql_query provides you with a resource id you can use with mysql_fetch_assoc for example

it does not give youthe result of the query itself

try

mysql_query("insert into accounts
  values('','$u_name','$pass','$momname','$anne',
    NOW() + INTERVAL 90 DAY, now(), '$mail', '0', '0', '0','0','0','0','0');

instead of the code you posted just above my replay

Dakkar

Thanks