php-windows Digest 6 Oct 2002 15:03:16 -0000 Issue 1374
Topics (messages 16195 through 16208):
Re: What do I need to do?
16195 by: Uttam
Re: PHP 4.2.3 and Apache 2.0.36
16196 by: Dash McElroy
16199 by: Davy Obdam
16208 by: Tim Cottle
Re: Mail problem
16197 by: Uttam
Win Apache problem
16198 by: konchim
Using date() function
16200 by: Davy Obdam
16201 by: H Marc Bower
16202 by: nicos.php.net
16203 by: Davy Obdam
16205 by: . Edwin
Re: [PHP] Re: Using date() function
16204 by: Davy Obdam
16206 by: John W. Holmes
16207 by: Davy Obdam
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 ---
these are required only if you are going to use the mail function through
PHP, i.e. you want to send mail message through your PHP script. If you are
not going to use the mail function it does not matters.
these values can also be later changed in php.ini file (in windows
directory):
//*php.ini
[mail function]
; For Win32 only.
SMTP=<name or ip of your smtp server> ; for Win32 only
; For Win32 only.
sendmail_from=<your mail address> ; for Win32 only
//php.ini*/
regds,
-----Original Message-----
From: Douglas F. Keim
To: [EMAIL PROTECTED]
Sent: 4-10-02 19:59
Subject: Re: [PHP-WIN] What do I need to do?
I am in the process of installing PHP. One of the screens is asking for
my
SMTP server and the from address for the mail function. I am assuming
that
the SMTP server is the one that I use for getting and sending mail
currently
in Outlook. It is the one provided by my ISP. The from address is my
associated email address.
The screen defaults to "localhost" and me@localhost. Are these just
examples?
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
000b01c26bc4$c5b91b80$[EMAIL PROTECTED]">news:000b01c26bc4$c5b91b80$[EMAIL PROTECTED]...
> Ok, so your question is basically "How do I install php?"
>
> The answer top this question is:
>
> consult www.php.net/manual which will cover most
> things you need to know to get php up and running.
>
>
> > -----Original Message-----
> > From: Douglas F. Keim [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, October 04, 2002 6:15 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [PHP-WIN] What do I need to do?
> >
> >
> > As I stated in the first message, I am interested in phpbb. This is
a
> > pre-designed BBS as far as I know. I needs PHP in order to run I
think.
So
> > all I want to do is install what is necessary and run the canned
BBS.
> >
> > "B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
> > 000a01c26bb0$efa24340$[EMAIL PROTECTED]">news:000a01c26bb0$efa24340$[EMAIL PROTECTED]...
> > > > Ok! I am really in the dark here. I have tried several
different
things
> > and
> > > > none of them have worked.
> > >
> > > It is a bit unclear what you want to do. Do you want to:
> > >
> > > a) develop a BBS your self?
> > > b) install a pre-existing BBS?
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Upgrade your Apache version. Worked for me like a charm.
I've tried it (successfully) with 2.0.40. I have not yet tried 2.0.42.
-Dash
And so, men, we can see that human skin is an even more complex and
fascinating organ than we thought it was, and if we want to keep it
looking good, we have to care for it as though it were our own. One
approach is to undergo a painful surgical procedure wherein your skin
is turned inside-out, so the young cells are on the outside, but then
of course you have the unpleasant side effect that your insides
gradually fill up with dead old cells and you explode. So this
procedure is pretty much limited to top Hollywood stars for whom
youthful beauty is a career necessity, such as Elizabeth Taylor and
Orson Welles.
-- Dave Barry, "Saving Face"
On Sat, 5 Oct 2002, Miguel A. Charneco wrote:
> I've changed form php 4.2.1 to 4.2.3 and when i try to run Apache i get an
> error when loading php4apache2.dll but everything seems correct when using
> the old file php4apache.dll from php 4.2.1... is there something wrong with
> this file?
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi people,..
I have tried Apache 2.0.42 and PHP 4.2.3 and i didn`t get it to work at
all. I had to reinstal apache 2.0.40 again and PHP. I would recomend
Apache 2.0.40 and PHP 4.2.3;-) as they work well together.
Best regards,
Davy Obdam
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: Dash McElroy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 8:24 AM
To: Miguel A. Charneco
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP 4.2.3 and Apache 2.0.36
Upgrade your Apache version. Worked for me like a charm.
I've tried it (successfully) with 2.0.40. I have not yet tried 2.0.42.
-Dash
And so, men, we can see that human skin is an even more complex and
fascinating organ than we thought it was, and if we want to keep it
looking good, we have to care for it as though it were our own. One
approach is to undergo a painful surgical procedure wherein your skin is
turned inside-out, so the young cells are on the outside, but then of
course you have the unpleasant side effect that your insides gradually
fill up with dead old cells and you explode. So this procedure is
pretty much limited to top Hollywood stars for whom youthful beauty is a
career necessity, such as Elizabeth Taylor and Orson Welles.
-- Dave Barry, "Saving Face"
On Sat, 5 Oct 2002, Miguel A. Charneco wrote:
> I've changed form php 4.2.1 to 4.2.3 and when i try to run Apache i
> get an error when loading php4apache2.dll but everything seems correct
> when using the old file php4apache.dll from php 4.2.1... is there
> something wrong with this file?
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
================================================================
Deze e-mail is door E-mail VirusScanner van Planet Internet
gecontroleerd op virussen. Op http://www.planet.nl/evs staat een
verwijzing naar de actuele lijst waar op wordt gecontroleerd.
--- End Message ---
--- Begin Message ---
I actually had the same problem, the php4apache2.dll file that comes with
4.2.3 is sketchy, i had to get the latest version from snaps.php.net to get
it to work, 4.3.xx-dev, and php is working like a charm now
----- Original Message -----
From: "Dash McElroy" <[EMAIL PROTECTED]>
To: "Miguel A. Charneco" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, October 06, 2002 2:24 AM
Subject: Re: [PHP-WIN] PHP 4.2.3 and Apache 2.0.36
> Upgrade your Apache version. Worked for me like a charm.
>
> I've tried it (successfully) with 2.0.40. I have not yet tried 2.0.42.
>
> -Dash
>
> And so, men, we can see that human skin is an even more complex and
> fascinating organ than we thought it was, and if we want to keep it
> looking good, we have to care for it as though it were our own. One
> approach is to undergo a painful surgical procedure wherein your skin
> is turned inside-out, so the young cells are on the outside, but then
> of course you have the unpleasant side effect that your insides
> gradually fill up with dead old cells and you explode. So this
> procedure is pretty much limited to top Hollywood stars for whom
> youthful beauty is a career necessity, such as Elizabeth Taylor and
> Orson Welles.
> -- Dave Barry, "Saving Face"
>
> On Sat, 5 Oct 2002, Miguel A. Charneco wrote:
>
> > I've changed form php 4.2.1 to 4.2.3 and when i try to run Apache i get
an
> > error when loading php4apache2.dll but everything seems correct when
using
> > the old file php4apache.dll from php 4.2.1... is there something wrong
with
> > this file?
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
are you sure your mail settings in php.ini are correct:
[mail function]
; For Win32 only.
SMTP=<name of ip of your smtp server> ; for Win32 only
; For Win32 only.
sendmail_from=<your mail address> ; for Win32 only
regds,
-----Original Message-----
From: Francisco Murillo Montoya [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 05, 2002 22:51
To: [EMAIL PROTECTED]
Subject: Mail problem
Hello;
I have PHP 4.2.3 on Windows 2000 advanced, and when
I try to use the mail funtion, the server returns an error.
<?
mail("[EMAIL PROTECTED]","Formulario","cuerpo");
?>
The page sais: Warning: Server error in c:\url\file.php on line 2.
I have Imail as Mail Server. Do you know why this happen?
Thank you.
Francisco Murillo
--- End Message ---
--- Begin Message ---
How to Set Password and username in Win Apache?
Konchim
--- End Message ---
--- Begin Message ---
Hi people
I have a guestbook, and i need to convert the date and time from the
database into a normal readable date.. Like Sunday, 6 october 2002
13:30:00. I thought i could use the date() function here. I have done
this:
$entry_date = date('l, d F Y H:i:s','$sql["date"]');
echo $entry_date;
But then i dont get the date i need. It says Thursday, 01 January 1970
01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
guestbook. Any sugestions what i am doing wrong. Thanks for your time.
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Am I correct in assuming that $sql[] is the result of a mysql_fetch_array
(or similar call)? If so, you shouldn't need the " in $sql["date"].
(V)
----- Original Message -----
From: "Davy Obdam" <[EMAIL PROTECTED]>
> $entry_date = date('l, d F Y H:i:s','$sql["date"]');
> echo $entry_date;
>
> But then i dont get the date i need. It says Thursday, 01 January 1970
> 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
> guestbook. Any sugestions what i am doing wrong. Thanks for your time.
--- End Message ---
--- Begin Message ---
First you should use :
$entry_date = date('l, d F Y H:i:s',$sql['date']);
And $sql['date'] must be a TIMESTAMP.
--
Nicos - CHAILLAN Nicolas
[EMAIL PROTECTED]
www.WorldAKT.com - Hébergement de sites Internet
"Davy Obdam" <[EMAIL PROTECTED]> a écrit dans le message de news:
001601c26d2c$e5391ff0$[EMAIL PROTECTED]
> Hi people
>
> I have a guestbook, and i need to convert the date and time from the
> database into a normal readable date.. Like Sunday, 6 october 2002
> 13:30:00. I thought i could use the date() function here. I have done
> this:
>
> $entry_date = date('l, d F Y H:i:s','$sql["date"]');
> echo $entry_date;
>
> But then i dont get the date i need. It says Thursday, 01 January 1970
> 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
> guestbook. Any sugestions what i am doing wrong. Thanks for your time.
>
> Best regards,
>
> Davy Obdam,
> mailto:[EMAIL PROTECTED]
>
>
--- End Message ---
--- Begin Message ---
Hi Marc,
Yes thats true $sql['date'] comes from :
for ($i=0;$i<mysql_num_rows($sql_id);$i++)
{
//Get all entries from datebase
$sql = mysql_fetch_assoc($sql_id);
$bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
$entry_date = date('l, d F Y H:i:s','$sql["date"]');
echo "
<tr bgcolor=\"$bgcolor\">
<td height=\"100\" width=\"150\"
valign=\"top\">[".$sql['entryID']."]<br> ".$sql
['name']."<br>".$sql['email']."<br>".$sql['location']."<br></td>
<td width=\"450\" valign=\"top\">
<div class=\"date\">$enty_date</div>
<hr size=\"1\" width=\"100%\">
<div>".$sql['comments']."</div>
</td>
</tr>";
}
Do u have any sugestions. Now it just says Thursday, 01 January 1970 all
the time. The columm type i use in my mysql database is datetime. Thanks
already..
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: H Marc Bower [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 1:54 PM
To: Davy Obdam; Php Mailinglist; Php-Windows Mailing
Subject: Re: [PHP-WIN] Using date() function
Am I correct in assuming that $sql[] is the result of a
mysql_fetch_array (or similar call)? If so, you shouldn't need the " in
$sql["date"].
(V)
----- Original Message -----
From: "Davy Obdam" <[EMAIL PROTECTED]>
> $entry_date = date('l, d F Y H:i:s','$sql["date"]');
> echo $entry_date;
>
> But then i dont get the date i need. It says Thursday, 01 January 1970
> 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
> guestbook. Any sugestions what i am doing wrong. Thanks for your time.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello,
Why not just do it in your sql query?
If you're using MySQL perhaps this page would be helpful:
http://www.mysql.com/doc/en/Date_and_time_functions.html
Just an idea...
- E
On Sunday, October 6, 2002 10:01 PM
Davy Obdam wrote:
> Hi people
>
> I have a guestbook, and i need to convert the date and time from the
> database into a normal readable date.. Like Sunday, 6 october 2002
> 13:30:00. I thought i could use the date() function here. I have done
> this:
>
> $entry_date = date('l, d F Y H:i:s','$sql["date"]');
> echo $entry_date;
>
> But then i dont get the date i need. It says Thursday, 01 January 1970
> 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
> guestbook. Any sugestions what i am doing wrong. Thanks for your time.
>
> Best regards,
>
> Davy Obdam,
> mailto:[EMAIL PROTECTED]
>
>
--- End Message ---
--- Begin Message ---
Hi Nicos,
Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me
back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date'] is
a TIMESTAMP and looks like this 20021006141256 in the datebase. It
should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know a
solution?
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 1:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: Using date() function
First you should use :
$entry_date = date('l, d F Y H:i:s',$sql['date']);
And $sql['date'] must be a TIMESTAMP.
--
Nicos - CHAILLAN Nicolas
[EMAIL PROTECTED]
www.WorldAKT.com - Hébergement de sites Internet
--- End Message ---
--- Begin Message ---
> Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me
> back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date']
is
> a TIMESTAMP and looks like this 20021006141256 in the datebase. It
> should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know
a
> solution?
No, not weird. MySQL uses a timestamp in the YYYYMMDDHHMMSS format.
Date() is expecting a UNIX timestamp, which is the number of seconds
since Jan 1, 1970.
So... you can either use DATE_FORMAT() in your query, with is the MySQL
equivalent of date(). Look up the format in the manual. Or, you can use
UNIX_TIMESTAMP() in your query to select out the unix timestamp instead
of the mysql timestamp, and then use that value within date() in your
PHP script.
---John Holmes...
--- End Message ---
--- Begin Message ---
Hi John,
How do u use UNIX_TIMESTAMP or DATE_FORMAT in your query. My query now
looks like this:
"SELECT * FROM guestbook2002 ORDER BY entryID DESC LIMIT $entry, $show";
Can u help me;-) Thanks for your time
Best regards,
Davy Obdam,
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 3:31 PM
To: 'Davy Obdam'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [PHP-WIN] RE: [PHP] Re: Using date() function
> Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me
> back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date']
is
> a TIMESTAMP and looks like this 20021006141256 in the datebase. It
> should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know
a
> solution?
No, not weird. MySQL uses a timestamp in the YYYYMMDDHHMMSS format.
Date() is expecting a UNIX timestamp, which is the number of seconds
since Jan 1, 1970.
So... you can either use DATE_FORMAT() in your query, with is the MySQL
equivalent of date(). Look up the format in the manual. Or, you can use
UNIX_TIMESTAMP() in your query to select out the unix timestamp instead
of the mysql timestamp, and then use that value within date() in your
PHP script.
---John Holmes...
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
