php-windows Digest 13 Feb 2002 23:53:36 -0000 Issue 1000
Topics (messages 12052 through 12070):
Re: Searching MS Word Docs (ERRATA)
12052 by: Svensson, B.A.T. (HKG)
Re: Searching MS Word Docs
12053 by: DL Neil
12054 by: Svensson, B.A.T. (HKG)
12057 by: DL Neil
blob
12055 by: Sichta Daniel
Re: Form submit action type.
12056 by: Mike Flynn
Re: reading from an excel file..
12058 by: alain
Re: IP address reference
12059 by: Christian Blichmann
Re: htaccess password encryption
12060 by: Christian Blichmann
search engine
12061 by: Sandeep Murphy
Getting PHP to behave with MS SQL Server 7
12062 by: Todd WIlliamsen
12063 by: Nicole Amashta
12064 by: Nicole Amashta
12065 by: Nicole Amashta
12066 by: Nicole Amashta
12067 by: Todd WIlliamsen
12070 by: Frank M. Kromann
Loading DLL Extension
12068 by: Zach Curtis
12069 by: Shane Caraveo
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 ---
ERRATA:
>neither CC, cc, gcc or g++ does in this behavior.
Should be:
neither CC, cc, gcc or g++ does inherent this behavior.
--- End Message ---
--- Begin Message ---
Sorry B.A.T,
Alain's quote is taken directly from http://www.php.net/manual/en/function.fopen.php
Using/not "b" does make a difference under Windows - haven't tested it under *nix!
The 'end' of a Windows file can be defined in two ways: an ASCII file ends with
CTRL+Z, a 'binary' file ends
where the header/catalog entry says so (not sure if that terminology has 'traveled'
properly). Somewhat
obviously, the reason for the latter is that the ASCII code for CTRL+Z may
coincidentally appear within the
middle of some binary digit (where it doesn't mean either CTRL-Z or eof). Does *nix
take filesizes from the
catalog/file header information? and only there?
Regards,
=dn
> >From the manual - Last thing to read ;)
> >"Note: The mode may contain the letter 'b'. This is useful only on systems
> >which differentiate between binary and text files (i.e. Windows. It's
> >useless on Unix). If not needed, this will be ignored. "
>
> If UNIX system doesn't difference between binary and text files, how are for
> ex
>
> 'char *fgets()' respectively 'char *gets()'
>
> supposed to be working then?
>
> When opening a file in binary mode (b) Unix and MS Windows behaves more or
> less the same, on the other hand when opening a file in text write mode (w
> or a) then UNIX might differ from MS Windows. I've noticed that MS VC++
> appends an ctrl-Z on the end of text files while writing to them. If Borland
> C++ does the same, I don't know. But as far as my limited knowledge extends,
> neither CC, cc, gcc or g++ does in this behavior.
>
> Conclusion:
>
> Opening a file in binary mode works more or less the same on UNIX and
> Windows, but text mode works different on the both systems.
=dn
--- End Message ---
--- Begin Message ---
Dear Niel,
So the implication of this is that php cant (be trusted to) handled binary
files properly under windows?
While once step debugging with VC++ to see what fgets() returns as EOF. I
found it to be equal to -1. I don't remember if this was in binary or text
mode, but I think it was binary mode.
Regarding the EOF with Unix files, I am not quite sure how it works, but the
file size information is stored in a structure called 'icommon', so it would
make sense to read the info from there, and then just send and EOF to the
"application" when the file position pointer has reached that # of read
bytes. But to know for sure I would need to check the UNIX file system's
kernel source code, but I really don't have the time left for doing those
funny things today - actually I guess I would need to do at least some work
today to. :)
Cheers,
/Anders - who was tempted to sporadically insert some ctrl-Z in this
message. :)
>-----Original Message-----
>From: DL Neil [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 14, 2002 2:04 PM
>To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
>Cc: 'alain'
>Subject: Re: [PHP-WIN] Re: Searching MS Word Docs
>
>
>Sorry B.A.T,
>
>Alain's quote is taken directly from
>http://www.php.net/manual/en/function.fopen.php
>
>Using/not "b" does make a difference under Windows - haven't
>tested it under *nix!
>
>The 'end' of a Windows file can be defined in two ways: an
>ASCII file ends with CTRL+Z, a 'binary' file ends
>where the header/catalog entry says so (not sure if that
>terminology has 'traveled' properly). Somewhat
>obviously, the reason for the latter is that the ASCII code
>for CTRL+Z may coincidentally appear within the
>middle of some binary digit (where it doesn't mean either
>CTRL-Z or eof). Does *nix take filesizes from the
>catalog/file header information? and only there?
>
>Regards,
>=dn
>
>
>> >From the manual - Last thing to read ;)
>> >"Note: The mode may contain the letter 'b'. This is useful only on
systems
>> >which differentiate between binary and text files (i.e. Windows. It's
>> >useless on Unix). If not needed, this will be ignored. "
>>
>> If UNIX system doesn't difference between binary and text
>files, how are for
>> ex
>>
>> 'char *fgets()' respectively 'char *gets()'
>>
>> supposed to be working then?
>>
>> When opening a file in binary mode (b) Unix and MS Windows
>behaves more or
>> less the same, on the other hand when opening a file in text
>write mode (w
>> or a) then UNIX might differ from MS Windows. I've noticed
>that MS VC++
>> appends an ctrl-Z on the end of text files while writing to
>them. If Borland
>> C++ does the same, I don't know. But as far as my limited
>knowledge extends,
>> neither CC, cc, gcc or g++ does in this behavior.
>>
>> Conclusion:
>>
>> Opening a file in binary mode works more or less the same on UNIX and
>> Windows, but text mode works different on the both systems.
>
>=dn
>
--- End Message ---
--- Begin Message ---
Dear Anders,
> So the implication of this is that php cant (be trusted to) handled binary
> files properly under windows?
=In a way, yes - but not limited to, or the fault of PHP! Because Windows has these
two methods to 'delimit' a
file, programs need to know which one to use.
=However, it is not my experience that either format presents any problems to PHP
under Windows (today - it has
in the past!). Thus the PHP filesystem functions are clearly labeled when they are
"binary safe".
=A short experiment:
I asked Windows Explorer for the Properties of my php.ini file. It returned the
following information: "24.5KB
(25,170 bytes), 25,600 bytes used". That's a file in ASCII-format. A bit further down
the dir list was a file in
binary format - REGEDIT.EXE: "70.2KB (71,952 bytes), 72,192 bytes used"
=I then ran them through PHP's fopen(), fread(), and compared filesize() to strlen().
It made no difference if
the fopen used "rb" or just "r" (r=read, b=binary). The lengths reported, and the
strings read were
consistent/identical (25,170 and 71,952 bytes respectively).
> While once step debugging with VC++ to see what fgets() returns as EOF. I
> found it to be equal to -1. I don't remember if this was in binary or text
> mode, but I think it was binary mode.
=I'm sorry, I can't comment on what VC++ does. A lot of 'input' operations return TRUE
(-1) at end-of-data/when
they have 'nothing' to say, ie when EOF=TRUE. Similarly some return ^Z (CTRL+Z). At
least one DEC minicomputer
system could even return a string "EOF".
=Some binary-read commands allow a whole sector/block/whatever to be read. This
enables reading 'beyond' the
last (meaningful) byte in a file. PHP's read commands (I quickly checked) all seem to
be 'binary safe' and will
terminate at EOF - even if you ask for a 1MB string of data from a 1Byte file.
=I don't seem to have anything on my laptop at present which would let me binary-read
a specific number of
bytes - it to get into bytes 71,953-72,192 of the disk space allocated to REGEDIT.EXE.
=I have no difficulty using PHP (not quite sure why I'd want to) as a file copier. It
faithfully copied a local
.HTML file/web page (ASCII) and a .JPG graphic (binary). The .HTML file comes up
perfectly in a browser and
displays as-expected in NotePad. The .JPG copy displays in a graphics editor
faithfully, as well as showing on
directory listings as byte-perfect.
> Regarding the EOF with Unix files, I am not quite sure how it works, but the
> file size information is stored in a structure called 'icommon', so it would
> make sense to read the info from there, and then just send and EOF to the
> "application" when the file position pointer has reached that # of read
> bytes. But to know for sure I would need to check the UNIX file system's
> kernel source code, but I really don't have the time left for doing those
> funny things today - actually I guess I would need to do at least some work
> today to. :)
="work"? What's that?
=I had a feeling that was the case for *nix, but in which case why the need for
CTRL-Z? - or is CTRL-Z not used
under *nix? Any *nix bit-busters amongst us?
> /Anders - who was tempted to sporadically insert some ctrl-Z in this
> message. :)
=perversely enough, the RFC determines a different convention to denote the end of an
email msg!!!??? (probably
because of what CTRL-Z can do on non-safe systems!)
=dn
(who file-opened in binary, just in case!)
> >-----Original Message-----
> >From: DL Neil [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, February 14, 2002 2:04 PM
> >To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
> >Cc: 'alain'
> >Subject: Re: [PHP-WIN] Re: Searching MS Word Docs
> >
> >
> >Sorry B.A.T,
> >
> >Alain's quote is taken directly from
> >http://www.php.net/manual/en/function.fopen.php
> >
> >Using/not "b" does make a difference under Windows - haven't
> >tested it under *nix!
> >
> >The 'end' of a Windows file can be defined in two ways: an
> >ASCII file ends with CTRL+Z, a 'binary' file ends
> >where the header/catalog entry says so (not sure if that
> >terminology has 'traveled' properly). Somewhat
> >obviously, the reason for the latter is that the ASCII code
> >for CTRL+Z may coincidentally appear within the
> >middle of some binary digit (where it doesn't mean either
> >CTRL-Z or eof). Does *nix take filesizes from the
> >catalog/file header information? and only there?
> >
> >Regards,
> >=dn
> >
> >
> >> >From the manual - Last thing to read ;)
> >> >"Note: The mode may contain the letter 'b'. This is useful only on
> systems
> >> >which differentiate between binary and text files (i.e. Windows. It's
> >> >useless on Unix). If not needed, this will be ignored. "
> >>
> >> If UNIX system doesn't difference between binary and text
> >files, how are for
> >> ex
> >>
> >> 'char *fgets()' respectively 'char *gets()'
> >>
> >> supposed to be working then?
> >>
> >> When opening a file in binary mode (b) Unix and MS Windows
> >behaves more or
> >> less the same, on the other hand when opening a file in text
> >write mode (w
> >> or a) then UNIX might differ from MS Windows. I've noticed
> >that MS VC++
> >> appends an ctrl-Z on the end of text files while writing to
> >them. If Borland
> >> C++ does the same, I don't know. But as far as my limited
> >knowledge extends,
> >> neither CC, cc, gcc or g++ does in this behavior.
> >>
> >> Conclusion:
> >>
> >> Opening a file in binary mode works more or less the same on UNIX and
> >> Windows, but text mode works different on the both systems.
> >
> >=dn
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi,
cfg: w2k, Apache 1.3, php4.11, Mysql 3-23-40-max-nt
I'm using following code to insert images (gif, jpg) into table. Everything
worked fine until I switch to php4.11. Now this code is inserting only image
header or something similar.
BTW: pct_data is longblob !!!
Thank you for any help !!
Dan
<?
if ($submit) {
mysql_connect( "****", "*****", "********");
mysql_select_db( "****");
$data = addslashes(fread(fopen($form_data, "r"),
filesize($form_data)));
$size = GetImageSize ($form_data);
$result = mysql_query("INSERT INTO pictures VALUES
(0,'$data','$form_data_type','$size[0]','$size[1]')");
$id = mysql_insert_id();
print "<p>this file has the following database id: <b>$id</b>";
mysql_close();
} else {
?>
<form method="POST" action="<?$PHP_SELF;?>" enctype="multipart/form-data">
<input type="hidden" name="max_file_size" value="1000000">
<br>Meno súboru :<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>
<?
}
?>
--- End Message ---
--- Begin Message ---
At 09:17 PM 2/12/2002 -0800, you wrote:
>What server side script should I use, I was visiting hotscripts and they
>don't really have anything that will work for me.
You don't really need a script. Just use a PHP file as the form action,
and in the PHP file create an e-mail with all the form info and use the php
mail() function to send it. See the manual for more on mail().
-Mike
--- End Message ---
--- Begin Message ---
You can have a look at this class:
http://phpclasses.upperdesign.com/browse.html?package=86
A+
Alain
On Thu, Feb 14, 2002 at 04:35:02AM +0800, Brian Feliciano wrote:
> how can i read data from an excel file??
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi there!
I am using this code to get the users IP, it also allows you
to retrieve the IP of AOL users.
Btw, the @ before $_SERVER["HTTP_X_FORWARD_FOR"]
prevents an error message, if the user is not using AOL...
Oh, I almost forgot: The $ip variable is an integer (I did this for
efficiently storing the IP in an MySQL database).
// Get user's IP and user agent
$ip = ip2long(($tmp = @$_SERVER["HTTP_X_FORWARD_FOR"]) ? $tmp :
$_SERVER["REMOTE_ADDR"]);
Hope it helps,
--
Christian Blichmann
_____________________________________________
don't hesitate - email me with your thoughts:
e-mail: [EMAIL PROTECTED]
- please remove the ".nospam" from address.
_____________________________________________
do you want to know more?
web: http://www.blichmann.de
--- End Message ---
--- Begin Message ---
"Martin.Andrew" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone know how to encrypt a password for use in htaccess?
>
I'm not sure, but you may try to use the crypt()-function (see the docs),
since it implements the standard Unix DES-based algorithm...
--
Christian Blichmann
_____________________________________________
don't hesitate - email me with your thoughts:
e-mail: [EMAIL PROTECTED]
- please remove the ".nospam" from address.
_____________________________________________
do you want to know more?
web: http://www.blichmann.de
--- End Message ---
--- Begin Message ---
hi all,
not sure whether this is the right forum to ask this question.. wud however
appreciate if anyone can guide me to the right place!
am trying to build a search engine and need some help on building an SQL
query.. like I hv about 10 fields in a form and the search engine query
should dig out from the database based on the form input or display nothing
if none of the fields are filled..
TIA,
sands
--- End Message ---
--- Begin Message ---
Ok, I followed the instructions very closely, to what vague instruction
there are.
I umcommented out the .dll files and I get undefined variable for
mssql_connect()
Now there is barely any documentation on this and the tech support has
gotten me ZERO results, I am hoping since this is a WINDOWS PHP list that
someone will be able to help me.
I am running Win2k Server IIS5, MS SQL Server7
Anyone?
Next is Oracle...anyone with answers on that? LOL!!
--- End Message ---
--- Begin Message ---
Do a search for the php_mssql.dll for SQL Server 7. Verify that dll will
work with SQL Server 7.0
But you should be able to find that dll on the web somewhere. just do a
search for it. I'll see if i can find it too.
Nicole Amashta
www.aeontrek.com
"Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ok, I followed the instructions very closely, to what vague instruction
> there are.
>
> I umcommented out the .dll files and I get undefined variable for
>
> mssql_connect()
>
> Now there is barely any documentation on this and the tech support has
> gotten me ZERO results, I am hoping since this is a WINDOWS PHP list that
> someone will be able to help me.
>
> I am running Win2k Server IIS5, MS SQL Server7
>
> Anyone?
>
> Next is Oracle...anyone with answers on that? LOL!!
>
>
--- End Message ---
--- Begin Message ---
http://www.ru.php.net/manual/hu/ref.mssql.php
*here is some info that is semi-useful.
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Do a search for the php_mssql.dll for SQL Server 7. Verify that dll will
> work with SQL Server 7.0
>
> But you should be able to find that dll on the web somewhere. just do a
> search for it. I'll see if i can find it too.
>
> Nicole Amashta
> www.aeontrek.com
>
> "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Ok, I followed the instructions very closely, to what vague instruction
> > there are.
> >
> > I umcommented out the .dll files and I get undefined variable for
> >
> > mssql_connect()
> >
> > Now there is barely any documentation on this and the tech support has
> > gotten me ZERO results, I am hoping since this is a WINDOWS PHP list
that
> > someone will be able to help me.
> >
> > I am running Win2k Server IIS5, MS SQL Server7
> >
> > Anyone?
> >
> > Next is Oracle...anyone with answers on that? LOL!!
> >
> >
>
>
--- End Message ---
--- Begin Message ---
and more info:
http://www.faqts.com/knowledge_base/index.phtml/fid/123
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Do a search for the php_mssql.dll for SQL Server 7. Verify that dll will
> work with SQL Server 7.0
>
> But you should be able to find that dll on the web somewhere. just do a
> search for it. I'll see if i can find it too.
>
> Nicole Amashta
> www.aeontrek.com
>
> "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Ok, I followed the instructions very closely, to what vague instruction
> > there are.
> >
> > I umcommented out the .dll files and I get undefined variable for
> >
> > mssql_connect()
> >
> > Now there is barely any documentation on this and the tech support has
> > gotten me ZERO results, I am hoping since this is a WINDOWS PHP list
that
> > someone will be able to help me.
> >
> > I am running Win2k Server IIS5, MS SQL Server7
> >
> > Anyone?
> >
> > Next is Oracle...anyone with answers on that? LOL!!
> >
> >
>
>
--- End Message ---
--- Begin Message ---
and finally, the possible motherload of php files to download:
http://www.go.dlr.de/fresh/pc/src/www/.warix/php-4.0.6-Win32.zip.html
*I have not verified that these files are downlaodable and/or work. You're
on your own there.
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Do a search for the php_mssql.dll for SQL Server 7. Verify that dll will
> work with SQL Server 7.0
>
> But you should be able to find that dll on the web somewhere. just do a
> search for it. I'll see if i can find it too.
>
> Nicole Amashta
> www.aeontrek.com
>
> "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Ok, I followed the instructions very closely, to what vague instruction
> > there are.
> >
> > I umcommented out the .dll files and I get undefined variable for
> >
> > mssql_connect()
> >
> > Now there is barely any documentation on this and the tech support has
> > gotten me ZERO results, I am hoping since this is a WINDOWS PHP list
that
> > someone will be able to help me.
> >
> > I am running Win2k Server IIS5, MS SQL Server7
> >
> > Anyone?
> >
> > Next is Oracle...anyone with answers on that? LOL!!
> >
> >
>
>
--- End Message ---
--- Begin Message ---
Geez..
I cannot get this to work!
odbc doesn't work either... *sigh* I guess its back to mysql!
"Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Do a search for the php_mssql.dll for SQL Server 7. Verify that dll will
> work with SQL Server 7.0
>
> But you should be able to find that dll on the web somewhere. just do a
> search for it. I'll see if i can find it too.
>
> Nicole Amashta
> www.aeontrek.com
>
> "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Ok, I followed the instructions very closely, to what vague instruction
> > there are.
> >
> > I umcommented out the .dll files and I get undefined variable for
> >
> > mssql_connect()
> >
> > Now there is barely any documentation on this and the tech support has
> > gotten me ZERO results, I am hoping since this is a WINDOWS PHP list
that
> > someone will be able to help me.
> >
> > I am running Win2k Server IIS5, MS SQL Server7
> >
> > Anyone?
> >
> > Next is Oracle...anyone with answers on that? LOL!!
> >
> >
>
>
--- End Message ---
--- Begin Message ---
Hi Todd,
If you are using the ISAPI version you need to restart the web server in order to use
the mssql_extension.
If you are using CGI and getting undefined function for mssql_connect, you might have
more than one php.ini file on your system ?
You also need to install the client libraries for mssql server. These can be found on
the server CD, or you can copy ntwdblib.dll from the server to your cplient pc (the pc
running your php scripst).
- Frank
> Ok, I followed the instructions very closely, to what vague instruction
> there are.
>
> I umcommented out the .dll files and I get undefined variable for
>
> mssql_connect()
>
> Now there is barely any documentation on this and the tech support has
> gotten me ZERO results, I am hoping since this is a WINDOWS PHP list that
> someone will be able to help me.
>
> I am running Win2k Server IIS5, MS SQL Server7
>
> Anyone?
>
> Next is Oracle...anyone with answers on that? LOL!!
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
I can't seem to be able to load any of the DLL extensions included with PHP.
For example when I try to load the pdf extension using:
dl("php_zlib.dll"); or
displaying phpinfo()
I get this message in a warning window:
pdf: Unable to initialize module
Module compiled with debug=o, thread-safety=1 module API=20000809
PHP compiled with debug=o, thread-safety=1 module API=20001222
These options need to match
I am running:
WINNT 4.0 SP 6a
Apache 1.3.12
PHP 4.0.6
php.ini settings:
extension_dir = j:\php\extensions
enable_dl = On
extension=php_pdf.dll
Any thoughts? Thanks.
Zach Curtis
POPULUS
--- End Message ---
--- Begin Message ---
You're mixing two versions of PHP which happen to be incompatible in the
extension API itself. Be sure your ini file points to the correct extension
directory.
----- Original Message -----
From: "Zach Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 3:15 PM
Subject: [PHP-WIN] Loading DLL Extension
> I can't seem to be able to load any of the DLL extensions included with
PHP.
> For example when I try to load the pdf extension using:
>
> dl("php_zlib.dll"); or
> displaying phpinfo()
>
> I get this message in a warning window:
>
> pdf: Unable to initialize module
> Module compiled with debug=o, thread-safety=1 module API=20000809
> PHP compiled with debug=o, thread-safety=1 module API=20001222
> These options need to match
>
> I am running:
> WINNT 4.0 SP 6a
> Apache 1.3.12
> PHP 4.0.6
>
> php.ini settings:
> extension_dir = j:\php\extensions
> enable_dl = On
> extension=php_pdf.dll
>
>
> Any thoughts? Thanks.
>
>
> Zach Curtis
> POPULUS
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
