php-windows Digest 4 Sep 2002 03:00:59 -0000 Issue 1322
Topics (messages 15653 through 15658):
image archieve
15653 by: kivanc urgancioglu
Re: Best environment for PHP on Windows
15654 by: Brian 'Bex' Huff
Re: MSSQL trouble: ansi_nulls?
15655 by: David Hollister
Re: Can't Download PHP
15656 by: Kerry Kobashi
IIS 3 Install
15657 by: Kerry Kobashi
Problems browsing PHP files
15658 by: Skeepa
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 ---
Hi Friends,
I had to write php scripts in windows for
intranet..The server for php will be apache server.The
project is about searching image and text files in the
server on LAN and copy them to a directory in a PC on
LAN and insert the names of those files into mysql
db.My problem:how can I insert the names of the image
and text files(ex:results of the dir command) into
mysqldb.I mean how can i get the names of the image
and text files individually in windows..The main point
is how can I get the names of the image or text files
one by one,it's not diffucult to insert them into to
db.
Note:We are using Novell Netware so assume server as
an F: drive...
Thanks
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--- End Message ---
--- Begin Message ---
Curious... Id like to know why you suggest CGI over SAPI for Apache...
its more stable, but less fast. If you're looking for speed, I believe
the suggested method is SAPI with Apache.
It should be noted that Apache 1.3 isn't as fast as IIS 5.0 on Win2k
boxes. If performance is a primary goal, you should check out the free
PHP Accelerator:
http://www.php-accelerator.co.uk
It optimizes your PHP scripts, then stores them "compiled" for faster
execution of dynamic pages. However, if you do a lot of database calls
on each page, you'd probably benefit more from some faster network hardware.
--
Brian 'Bex' Huff
[EMAIL PROTECTED]
Phone: 952-903-2023
Fax: 952-829-5424
> Apache/CGI.
>
>
> Benjamin Walling wrote:
>
>
>> We have a website currently running ASP/IIS/Win2k. It has some problems
>> that get it locked up on a semi regular basis, requiring a reboot or killing
>> of dllhost.exe.
>>
>> I've started porting some of the code to PHP to see if this is a viable
>> alternative. So far, I've been running it on IIS/Win2k as an ISAPI filter.
>> I've found the performance to be subpar running against the same database
>> backend server (MSSQL) as the ASP code. I downloaded a copy of apache,
>> although I've not installed or tested it. I'll grant that the ASP code and
>> the PHP code are running on separate machines, although they have the same
>> hardware configuration (the PHP machine even has a lighter load because I am
>> the only one using it - there are 20-30 people on the ASP machine all day
>> long).
>>
>> What is the optimal configuration for running PHP under Windows? IIS/ISAPI?
>> Apache/CGI? Apache/mod_php? If I'm going to give this a fair run, I'd like
>> to do it under the optimal conditions for PHP.
>>
>> There does not seem to be sufficient support for accessing MSSQL under
>> linux. I've tried freetds, but it doesn't have full support - running
>> stored procedures with mssql_init() mssql_bind() mssql_execute() won't work.
>> We can't get away from MSSQL - our accounting system runs on it, and that's
>> not going to change.
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Did you get a response on this? I only know that this setting has to do
with the NULL standards (queries either equate NULL to false or equate NULL
to a value of NULL). Is there some further interpretation of NULL contained
within your connection method? - most definitely! Query Analyzer
implements quite a bit of added connection functionality; you have many
options for setting the behavior of your current session. At least in SQL
7, the DBCC USEROPTIONS command will list all your current connection
options.
I guess that means you have to dig further into the fine print for
connection preferences by given technology.
-----Original Message-----
From: Matt Kynaston [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL trouble: ansi_nulls?
OK, to answer my own question...
The ansi_* settings were to blame for the sp failing. In Enterprise Manager
I went into the Server Properties (Properties > Connections) and made sure
'ANSI null defined on' was checked and the problem has cleared up.
Still mystified, though: why do connections from Query Analyser and FreeTDS
set these things up properly, and connections from Win PHP not? And is there
a way to change the connection setting from within PHP?
Matt
> -----Original Message-----
> From: Matt Kynaston [mailto:[EMAIL PROTECTED]]
> Sent: 30 August 2002 10:31
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] MSSQL trouble: ansi_nulls?
>
>
> Hi there,
>
> I tried posting this to the newsgroup yesterday, but it
> doesn't look like it
> worked - sorry if it shows up twice.
>
> I'm running PHP 4.2.2 under Win2K/IIS and trying to run a
> stored proc in
> MSSQL2000 (SP2) on the same server.
>
> Exactly the same script works fine from Linux/Apache using
> FreeTDS, but
> won't work from the Win2K.
>
> I can connect (verified from Profiler), but the mssql_query()
> returns the
> following error:
> Warning: MS SQL message: Cannot insert the value NULL into
> column 'height',
> table
> 'tempdb.dbo.#LimitTable_______________________________________
> ______________
> ____________________________________________________0001000000
> 14'; column
> does not allow nulls. INSERT fails. (severity 16) in
> e:\Inetpub\wwwroot\canaryislands-golf.com\common\classes\etbsq
> ltemplate.inc
> on line 42.
>
> The same stored proc runs fine from Query Analyser. I've
> noticed a couple of
> strange things using Profiler. When the Linux box connects (or Query
> Analyser), it issues the following statements:
>
> -- network protocol: TCP/IP
> set quoted_identifier on
> set implicit_transactions off
> set cursor_close_on_commit off
> set ansi_warnings on
> set ansi_padding on
> set ansi_nulls on
> set concat_null_yields_null on
> set language us_english
> set dateformat mdy
> set datefirst 7
>
> The PHP connection differs, and I think that's what's causing
> the problems:
>
> -- network protocol: TCP/IP
> set quoted_identifier off
> set implicit_transactions off
> set cursor_close_on_commit off
> set ansi_warnings off
> set ansi_padding off
> set ansi_nulls off
> set concat_null_yields_null off
> set language us_english
> set dateformat mdy
> set datefirst 7
>
> Does anyone know how to change the ansi_* and
> concat_null_yields_null set
> statements that are issued when PHP connects? Or am I on the
> wrong track?
>
> Regards,
>
> Matt
>
--- End Message ---
--- Begin Message ---
I had problems too..
If you click on their download links, sit and wait for about 10 minutes...
the save as dialog box comes up and you will be able to download..
"Sperry Russ" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I am new to PHP and wanted to download it and check it out. I have tried
>
> numerous of the mirrors but cannot download at all. I have to download
> with IE 6.0 and Mozilla 1.1. Any ideas what might be wrong?
>
> Thanks,
> Sperry Russ
>
--- End Message ---
--- Begin Message ---
Ok so I downloaded the windows PHP version onto my IIS3 NT4 Server system...
Ran the installation program
created a simple hello world program...
then did a localhost/hello.php and nothing came up except a HTTP 404
error...
Any thoughts/suggestions?
--- End Message ---
--- Begin Message ---
Hi, I've just installed PHP 4.2.2 + Apache 1.3.26 over Windows 2000, but I
can't see any php files in my browser. Apache works fine.
Errors:
- Running Apache on port 80, a blank screen appears.
- Running Apache on port 8080, the browser tries to download de php file
("save as" dialog box appears)
Apache configuration (httpd.conf):
--------------
LoadModule php4_module c:/php/sapi/php4apache.dll
AddModule mod_php4.c
AddType application/x-httpd-php .php
--------------
Anybody can help me?
Thanks. Skeepa.
--- End Message ---
