php-windows Digest 4 Feb 2002 16:40:30 -0000 Issue 985
Topics (messages 11817 through 11833):
Re: Windows NT SMTP Set Up Help Needed
11817 by: Steve Yates
11830 by: DL Neil
Re: Apache variables
11818 by: Steve Yates
Can't pass variables to PHP scripts?! Please help.
11819 by: Travis Wyatt
11822 by: Ross Fleming
11823 by: Mike Maltese
11824 by: Ross Fleming
Re: how to build php4.1.1 on VC6
11820 by: David
11826 by: Nobuhide Tsuda
R: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
11821 by: Darvin Andrioli
Re: Export MySQL --> DBF, CSV, MS Access, or MS Excel?
11825 by: Svensson, B.A.T. (HKG)
11827 by: Piotr Pluciennik
11828 by: Svensson, B.A.T. (HKG)
Re: Event Viewer Entries
11829 by: Gary Pullis
odbc functions
11831 by: Richard Black
Re: [PHP-DB] odbc functions
11832 by: Andrew Hill
Re:[PHP-WIN] and now?
11833 by: Michel Laine
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 ---
> > A client is having trouble setting up SMTP services on their
> > Windows NT machine so PHP can access it through the mail() function.
> >
> > SMTP is set to mail.theserver.com in the php.ini.
> > Mail() works when set to a different mail server.
> If they're on the same machine, why dont you use
> localhost instead?
Try a newer version of PHP. This was a known issue with older
versions, and should be fixed in 4.0.2. This was my report, although in
truth I can't recall if I ever went back and tried it with 4.1:
http://bugs.php.net/bug.php?id=5743
The symptom was that it would hang trying to connect.
- Steve Yates
- WWhhaatt ddooeess ""DDUUPPLLEEXX"" mmeeaann??
/ Taglines by Taglinator - www.srtware.com /
--- End Message ---
--- Begin Message ---
> > > A client is having trouble setting up SMTP services on their
> > > Windows NT machine so PHP can access it through the mail() function.
> > >
> > > SMTP is set to mail.theserver.com in the php.ini.
> > > Mail() works when set to a different mail server.
>
> > If they're on the same machine, why dont you use
> > localhost instead?
>
> Try a newer version of PHP. This was a known issue with older
> versions, and should be fixed in 4.0.2. This was my report, although in
> truth I can't recall if I ever went back and tried it with 4.1:
>
> http://bugs.php.net/bug.php?id=5743
>
> The symptom was that it would hang trying to connect.
=assume you've tried PINGing the mail server address/name resolution.
=try using IP address (if static)
=local SMTP server not needed (on Win - different for *nix)
- on Windows you may use any server, eg ISP's
(in case that's any help - from the first para, it seems that you may only be
installing the server to use PHP
mail() facility)
=Regards,
=dn
--- End Message ---
--- Begin Message ---
"B Thomas" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> echo $SCRIPT_NAME;
>
> Returns: nothing.
What does phpinfo() show? There are some variables that are
web-server dependent.
- Steve Yates
- Debrief: Wife listening while you talk in your sleep.
/ Taglines by Taglinator - www.srtware.com /
--- End Message ---
--- Begin Message ---
Here is my situation...I can't seem to get variables to pass from a GET or POST method
to a PHP script. To see for yourself go to:
http://www.socopc.com/test.php?testvar=hello_world
The source of "test.php" is...
<html>
<? for ($x=0;$x<5;$x++) { echo $x; } ?>
<br><? print "testvar=\"".$testvar."\""; ?>
<br><br><br><? phpinfo(); ?>
</html>
And as you will see, I get the error.
Warning: Undefined variable: testvar in c:\root\domains\socopc.com\test.php on line 3
testvar=""
Indicating that the variable is empty and has not been passed?!
I'm running Win2k Server w/ Apache and PHP 4.1.1.
If someone could look at that page (included are most of my settings). And help me
fix my PHP configuration? Thanks!
~ Travis
--- End Message ---
--- Begin Message ---
Also, just another point:
http://www.socopc.com/test.php?testvar=hello_world will not work (at least
it shouldn't), you can't have a space in a URL. It should be URL encoded to
:
http://www.socopc.com/test.php?testvar=hello%20world
Ross
-----Original Message-----
From: Travis Wyatt [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 06:51
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
Here is my situation...I can't seem to get variables to pass from a
GET or POST method to a PHP script. To see for yourself go to:
http://www.socopc.com/test.php?testvar=hello_world
The source of "test.php" is...
<html>
<? for ($x=0;$x<5;$x++) { echo $x; } ?>
<br><? print "testvar=\"".$testvar."\""; ?>
<br><br><br><? phpinfo(); ?>
</html>
And as you will see, I get the error.
Warning: Undefined variable: testvar in
c:\root\domains\socopc.com\test.php on line 3
testvar=""
Indicating that the variable is empty and has not been passed?!
I'm running Win2k Server w/ Apache and PHP 4.1.1.
If someone could look at that page (included are most of my
settings). And help me fix my PHP configuration? Thanks!
~ Travis
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
The space is an underscore.
----- Original Message -----
From: "Ross Fleming" <[EMAIL PROTECTED]>
To: "Travis Wyatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 1:01 AM
Subject: RE: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
> Also, just another point:
> http://www.socopc.com/test.php?testvar=hello_world will not work (at least
> it shouldn't), you can't have a space in a URL. It should be URL encoded
to
> :
> http://www.socopc.com/test.php?testvar=hello%20world
>
> Ross
>
> -----Original Message-----
> From: Travis Wyatt [mailto:[EMAIL PROTECTED]]
> Sent: 04 February 2002 06:51
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
>
>
> Here is my situation...I can't seem to get variables to pass from a
> GET or POST method to a PHP script. To see for yourself go to:
> http://www.socopc.com/test.php?testvar=hello_world
>
> The source of "test.php" is...
> <html>
> <? for ($x=0;$x<5;$x++) { echo $x; } ?>
> <br><? print "testvar=\"".$testvar."\""; ?>
> <br><br><br><? phpinfo(); ?>
> </html>
>
>
> And as you will see, I get the error.
> Warning: Undefined variable: testvar in
> c:\root\domains\socopc.com\test.php on line 3
> testvar=""
>
> Indicating that the variable is empty and has not been passed?!
> I'm running Win2k Server w/ Apache and PHP 4.1.1.
>
> If someone could look at that page (included are most of my
> settings). And help me fix my PHP configuration? Thanks!
> ~ Travis
>
>
>
> --
> 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 ---
Indeed you are right, my apologies.
My thanks go to Mr Gates and his pointless ambiguous underlining of URLs. :)
Ross
-----Original Message-----
From: Mike Maltese [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 09:12
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Can't pass variables to PHP scripts?! Please
help.
The space is an underscore.
----- Original Message -----
From: "Ross Fleming" <[EMAIL PROTECTED]>
To: "Travis Wyatt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 1:01 AM
Subject: RE: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
> Also, just another point:
> http://www.socopc.com/test.php?testvar=hello_world will not work (at least
> it shouldn't), you can't have a space in a URL. It should be URL encoded
to
> :
> http://www.socopc.com/test.php?testvar=hello%20world
>
> Ross
>
> -----Original Message-----
> From: Travis Wyatt [mailto:[EMAIL PROTECTED]]
> Sent: 04 February 2002 06:51
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
>
>
> Here is my situation...I can't seem to get variables to pass from a
> GET or POST method to a PHP script. To see for yourself go to:
> http://www.socopc.com/test.php?testvar=hello_world
>
> The source of "test.php" is...
> <html>
> <? for ($x=0;$x<5;$x++) { echo $x; } ?>
> <br><? print "testvar=\"".$testvar."\""; ?>
> <br><br><br><? phpinfo(); ?>
> </html>
>
>
> And as you will see, I get the error.
> Warning: Undefined variable: testvar in
> c:\root\domains\socopc.com\test.php on line 3
> testvar=""
>
> Indicating that the variable is empty and has not been passed?!
> I'm running Win2k Server w/ Apache and PHP 4.1.1.
>
> If someone could look at that page (included are most of my
> settings). And help me fix my PHP configuration? Thanks!
> ~ Travis
>
>
>
> --
> 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
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
[posted and mailed]
Nobuhide Tsuda said something on 04 Feb 2002, in php.windows:
>
> I downloaded php-4.1.1 and found *.dsw files.
> It seems that I could be able to build PHP4.1.1 on VC6.
> But, I came up against too many errors with build php4.
>
> Could someone tell me How to build PHP4.1.1 on VC
http://www.php.net/manual/en/install.windows.php
David
--- End Message ---
--- Begin Message ---
Hi, David-san,
on 4 Feb 2002 07:28:23 -0000
David wrote:
> http://www.php.net/manual/en/install.windows.php
Thank you for your advice.
I missed the page...
BTW, I succeeded to build php_ctype.dll on VC, and to add
a new function, of which speed is 5 times faster than defined
using PHP. :-)
Then, I struggly tried to add new project to php_modules work-space,
and finally got php_my.dll. But Warning dialog (Invalid library)
appeares when the php_my.dll is called.
I guess it's project settings is wrong, but I don't know how to
settind.
So, could someone tell me how to add a new poject to php_modules
work-space ?
regards,
N.Tsuda
http://vivi.dyndns.org/
--- End Message ---
--- Begin Message ---
Travis, you hve register_globals set to off. You my turn it on, or,
according to security issue, use $_REQUEST["testvar"].
Regards
Darvin Andrioli
> -----Messaggio originale-----
> Da: Travis Wyatt [mailto:[EMAIL PROTECTED]]
> Inviato: luned́ 4 febbraio 2002 7.51
> A: [EMAIL PROTECTED]
> Oggetto: [PHP-WIN] Can't pass variables to PHP scripts?! Please help.
>
>
> Here is my situation...I can't seem to get variables to pass from
> a GET or POST method to a PHP script. To see for yourself go to:
> http://www.socopc.com/test.php?testvar=hello_world
>
> The source of "test.php" is...
> <html>
> <? for ($x=0;$x<5;$x++) { echo $x; } ?>
> <br><? print "testvar=\"".$testvar."\""; ?>
> <br><br><br><? phpinfo(); ?>
> </html>
>
>
> And as you will see, I get the error.
> Warning: Undefined variable: testvar in
> c:\root\domains\socopc.com\test.php on line 3
> testvar=""
>
> Indicating that the variable is empty and has not been passed?!
> I'm running Win2k Server w/ Apache and PHP 4.1.1.
>
> If someone could look at that page (included are most of my
> settings). And help me fix my PHP configuration? Thanks!
> ~ Travis
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
>Where should I look for information to dump MySql tables to
>other formats so the client can download the data?
>
>dBase, comma-delimited, Access, and Excel are formats I find useful.
Has MS published the file format of MS Excel files???
--- End Message ---
--- Begin Message ---
You don't need to know formats of these files.
Reasonable way is to use ODBC interface or in case of
Access and Excel - COM model. ODBC will be easier.
Greetings
Piotr
--- "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
wrote: > >Where should I look for information to dump
MySql
> tables to
> >other formats so the client can download the data?
> >
> >dBase, comma-delimited, Access, and Excel are
> formats I find useful.
>
> Has MS published the file format of MS Excel
> files???
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--- End Message ---
--- Begin Message ---
"Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]> wrote:
>> >Where should I look for information to dump MySql tables to
>> >other formats so the client can download the data?
>> >
>> >dBase, comma-delimited, Access, and Excel are
>> >formats I find useful.
[REMARK: BELOW IS WHAT _I_ (BAT Svensson) DID WROTE]
>> Has MS published the file format of MS Excel files???
From: Piotr Pluciennik
>
>You don't need to know formats of these files.
Just as I can't tell what you need and not need to know, you can tell what I
need an not need to know. ;)
>Reasonable way is to use ODBC interface or in case of
>Access and Excel - COM model.
Thanks for you answer, but you did not answer my question, considering
weather MS has published the file format of MS Excel or not.
If one is happy to treat MS Excel files as lumps of binary data, fine with
me, but I am curious about weather MS actually has published the file format
of MS Excel, mainly because end users that requires me to process data
continues to send these binary junk files, a.k.a. MS Excel files, and it
would be nice to write a parser that could extract the data in some usable
form.
It would be nice to have a file format in order to write a program to
extract data from those junk files.
> ODBC will be easier.
Here me now and belive me later: ODBC it self wont make it easier...
/Anders
--- End Message ---
--- Begin Message ---
Maybe the problem was that my question was at end of my last message.
Does anyone know if there's an Eventmessagefile DLL in the PHP Win32
binary distribution?
Gary Pullis wrote:
> When I use the syslog() function under Win2K, I get the following from
> Event Viewer:
>
> "The description for Event ID ( 2000 ) in Source ( c-client ) cannot be
> found. The local computer may not have the necessary registry
> information or message DLL files to display messages from a remote
> computer. The following information is part of the event:
> c-client[2052], foo."
>
> This is already a known bug:
> http://bugs.php.net/bug.php?id=8314
>
> The problem seems to be that, either the Windows port of PHP does not
> have an eventmessagefile dll, or the existence of the dll is not getting
> noted in the system registry.
>
> BTW, here is a great (and pretty short) read about event messages under
> NT/2K:
> http://www.johnjohnston.com/w2kevtlog.html
>
> Is there anyone who could confirm or deny the existence of an
> eventmessagefile dll for PHP?
>
> Thanks!
>
--
Gary Pullis
Supporting: Sage MAS90/MAS200 | Linux | Windows NT | Novell Netware
Office Management Technologies
http://www.omt.cc
--- End Message ---
--- Begin Message ---
Does anyone have experience of using odbc_primarykeys???
I'm writing a script to let me port a database from Access to MySQL without
having to write all the table definitions by hand. But I can't get
odbc_primarykeys to work - it comes back with:
Warning: SQL error: , SQL state 00000 in SQLPrimaryKeys
I don't really know what the modifier and owner parameters should do, and
suspect thats where the problem lies. I tried them as "", "%" and " ".
Running PHP 4.0.4 on NT 4.0 Workstation, with Access 97
Richy.
==========================================
Richard Black
Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com
Tel: 0141 435 3504
Email: [EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
Richard,
Simple example using MS SQL Server:
<?php
$dsn="Northwind";
$usr="sa";
$pwd="";
$qual="Northwind";
$owner="dbo";
$table="Orders";
$conn_id = odbc_connect($dsn, $usr, $pwd) or die (odbc_error());
$result_id = odbc_primarykeys($conn_id, $qual, $owner, $table) or die
(odbc_error());
odbc_result_all($result_id);
?>
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Richard Black [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 04, 2002 10:36 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Subject: [PHP-DB] odbc functions
>
>
> Does anyone have experience of using odbc_primarykeys???
>
> I'm writing a script to let me port a database from Access to
> MySQL without
> having to write all the table definitions by hand. But I can't get
> odbc_primarykeys to work - it comes back with:
>
> Warning: SQL error: , SQL state 00000 in SQLPrimaryKeys
>
> I don't really know what the modifier and owner parameters should do, and
> suspect thats where the problem lies. I tried them as "", "%" and " ".
>
> Running PHP 4.0.4 on NT 4.0 Workstation, with Access 97
>
> Richy.
>
>
> ==========================================
> Richard Black
> Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com
> Tel: 0141 435 3504
> Email: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--- End Message ---
--- Begin Message ---
Bram Somers wrote:
> hello ppl,
>
> PHP is installed on my computer (finally) but how can I open a *.php file
> now?
> Internet explorer still say that he can't open the file can, does somebody
> know
> what to do?
>
> thanks
>
> B.S.
Didn't you get the reply i sent to you (directly to you) on friday 1/2-2002?
I did say *exactly* the same thing in my reply as 'Piotr Pluciennik' say here.
Makes one wonder if you do read your messages.
--
Michel Laine
--- End Message ---
