[thelist] Convert string to date

[~kristina]

Mia

//comments below....

on Wednesday, July 10, 2002, 11:48:09 AM, mia declared:

<:>
> If you're going to convert those into a date, you need to build a string
> to give to the function that makes a date from a string first.  I've given
> an example below.

> You can use strtotime() (http://www.php.net/strtotime) or mktime()
> (http://www.php.net/mktime) with time() to get the current time, or date.
> There's a list of acceptable date formats at
> http://www.gnu.org/manual/tar-1.12/html_chapter/tar_7.html you can check
> if your string isn't working.

> Have you looked up the function definitions at php.net to check what input
> (arguments) you should be using, and what you should be getting back from
> the function?  You can get information about any function by going to
> http://www.php.net/functionname.

> You'd want to check the format, but once I've got the my date into date
> format, I use date() to format it again and compare it to today.

> (Probably horribly inefficient) example:

> // get today's date, format it for comparison
> $today = date("j n Y", time())

> // get the data from the form usable, format it for comparison
> $expirydate = mktime(0,0,0, $deletemonth, $deleteday, $deleteyear);
> $expirydate = date("j n Y", $expirydate);

> // then use it like this
> if ($today == $expirydate) {
>         // This is from your example
>         // but note that you don't need '*' in a DELETE
>         $query = "DELETE FROM tableName WHERE expirydate=$expirydate";

>         // uncomment the line below to print your query to the
>         // screen for easier testing
>         //echo $query;

>         // whatever database calls you need to send the query
> }
<:>

Thanks for your reply, I think I may have forgotten to mention that
I'm a complete newbie at all of this php/mysql stuff..!!

Hence I didn't fully understand your reply, any chance you can give me
a 'simpleton's version...?

--
tia
~kristina

kristina at kfx-design.co.uk
http://kfx-design.co.uk/