php-windows Digest 12 Aug 2003 10:18:26 -0000 Issue 1866
Topics (messages 21120 through 21123):
Re: Subject: date question
21120 by: Neil Smith
Re: Randomize mySQL result array
21121 by: H Marc Bower
Can anyone suggest a user authentication script that works?
21122 by: Acorn Tutors
Re: Zip archive & File Encryption
21123 by: Miha Nedok
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
You need to pass date() a serial time value, a timestamp. This is quite
clearly documented in the PHP manual under date(). If you get stuck , try
date("Y-m-d",time()) and work from there.
Also, you need to use the SQL function UNIX_TIMESTAMP(day) to return a
timestamp in the way you are trying to do this. You may as well calculate a
days worth of seconds and add that to the value which is returned from the
SQL. Many other (better) ways exist using SQL to do what you want and they
are all well documented.
Cheers - Neil.
At 16:46 11/08/2003 +0000, you wrote:
Message-ID: <[EMAIL PROTECTED]>
From: "Harpreet" <[EMAIL PROTECTED]>
Subject: date question
I use the below sql statement to add one day to the date
select DATEADD(day,1,'2003-08-11 23:59:59') as datered
It returns
$expir="Aug 12 2003 11:59PM"
To convert the format to YYYY-MM-DD I use
$expir=date('Y-m-d', $expir);
The new value returned is 1969-12-31. What am i doing wrong. The only thing
I want to do is convert my date to a YYYY-MM-DD format.
Please help.
Thanks,
Harpreet
========================================================
CaptionKit http://www.captionkit.com : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every
day at http://www.fresh-toast.net : NetMeeting solutions
for a connected world.
--- End Message ---
--- Begin Message ---
heheh... Thank you, Ignatius and B.A.T. I guessed there had to be a simple
way.
(V)
----- Original Message -----
From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
> > BTW there is a nice MySQL Windows mailing list.
>
> I wouldn't say that. Some of the authers there really need a lay... ;)
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
HI folks, Ive been trying to get a user authentication script to work, but
they seem to error on my system. Anyone know of one (and where to get it)
that works on Win XP Pro, IIS, MySQL, PHP 4? (Or a web site where I can get
help with getting one to work)
TIA,
Doug
--- End Message ---
--- Begin Message ---
Look at PhpMyAdmin they have a ZIP file class. But no encryption, you
would have to implement it yourself. But ZIP file encryption is weak and
easy breakable. I'm recommind you to encrypt your data with some
encryption that is provided by Mcrypt (check for libmcrypt).
-Mike
On Mon, 11 Aug 2003, UHL Fabrice wrote:
> Date: Mon, 11 Aug 2003 17:20:53 +0200
> From: UHL Fabrice <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Zip archive & File Encryption
>
> hi all,
>
> I am looking for a php class for creating zip encrypted files archives.
>
> does anyone have an idea ?
>
> thanks
>
> UF
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
