php-windows Digest 3 Aug 2003 09:28:36 -0000 Issue 1851
Topics (messages 20988 through 20994):
Re: Q on parts of PHP?Apache setup...
20988 by: Jim
Re: Apache or IIS
20989 by: The.Rock
20990 by: Craig Roberts
20991 by: Jon Phipps
20992 by: Mike Brum
php shows no results
20993 by: Dominic
20994 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 ---
This subject has come up on PHPBuilder site previously and it looks like
they might have solved the question. Check out:
http://www.phpbuilder.com/board/showthread.php?threadid=10242264
and see if there is information there that helps you out. It looks to me
like there are 2 different DLLs depending on which method of use you are
using, and this would make sense to me because there are different methods
of hadeling the data. In any even, this thread should help you out.
Jim
-------Original Message-------
From: jsWalter
Date: Saturday, August 02, 2003 10:12:44
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Q on parts of PHP?Apache setup...
These are the config commands I have for PHP under Apache...
LoadFile "/etc/php/php4ts.dll"
Action application/x-httpd-php "/etc/php/php.exe"
LoadFile "/etc/php/gnu_gettext.dll"
LoadModule php4_module "/etc/php/sapi/php4apache2.dll"
ScriptAlias /php/ "/etc/php/"
AddType application/x-httpd-php .php .phtml
AddType application/x-httpd-php-source .phps
<Files *.php>
SetOutputFilter PHP
SetInputFilter PHP
LimitRequestBody 524288
</Files>
I understand that PHP can run in 2 different modes...
- CGI
- SAPI
What I don't see is how to configure Apache to do one or the other.
Would some kind soul please take the above conf lines (or add/remove as you
saee fit) and give me series for CGI and the series for SAPI.
I've looked for this info and just haven't found it (oh, its out there, I'm
just looking in the right places).
Thanks
Walter
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
--- End Message ---
--- Begin Message ---
I wouldn't call myself a guru with IIS, but I happen to know a lot about it.
In my experience with IIS and PHP, the bigger the script the more IIS seems
to sag. Apache runs better and is more stable I think than IIS. The thing
about editing a conf file for the configuration is no big deal. If your
setting this up, its not so much different that you couldn't learn it in a
short amount of time. Plus there are a few GUI front ends for editing the
conf file in windows.
The other thing is, I seem to have less problems on Apache than IIS. The
isapi dll for php in IIS isn't very stable and often time craps out for no
reasons. Apache may have some issues, but they will be far less than what
you'll experience in IIS.
I'm a windows person, but recently started learning Redhat. You'll find a
big performance difference if you can run php on a Linux OS. I've got
several scripts that I have a time function that measures how fast the page
is created. Its pretty much a night and day difference as far as performance
is concerned.
Just my 2 cents...
"William Harrison" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> We are planning to use PHP on windows 2000 but which is the better web
> server to use under this these circumstances IIS or Apache?
>
> Thanks
>
> Will
>
>
>
--- End Message ---
--- Begin Message ---
I've never used PHP with IIS... but run it on 2 Windows 2000 Apache (1.3.27)
servers in production, plus on 2 test workstations. I've had few problems.
There's plenty of tutorials on the net for configuring Apache to do all
sorts of things.
Craig Roberts
"The.Rock" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I wouldn't call myself a guru with IIS, but I happen to know a lot about
it.
> In my experience with IIS and PHP, the bigger the script the more IIS
seems
> to sag. Apache runs better and is more stable I think than IIS. The thing
> about editing a conf file for the configuration is no big deal. If your
> setting this up, its not so much different that you couldn't learn it in a
> short amount of time. Plus there are a few GUI front ends for editing the
> conf file in windows.
>
> The other thing is, I seem to have less problems on Apache than IIS. The
> isapi dll for php in IIS isn't very stable and often time craps out for no
> reasons. Apache may have some issues, but they will be far less than what
> you'll experience in IIS.
>
> I'm a windows person, but recently started learning Redhat. You'll find a
> big performance difference if you can run php on a Linux OS. I've got
> several scripts that I have a time function that measures how fast the
page
> is created. Its pretty much a night and day difference as far as
performance
> is concerned.
>
> Just my 2 cents...
>
>
> "William Harrison" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Hi,
> >
> > We are planning to use PHP on windows 2000 but which is the better web
> > server to use under this these circumstances IIS or Apache?
> >
> > Thanks
> >
> > Will
> >
> >
> >
>
>
--- End Message ---
--- Begin Message ---
You are right, I am getting tired of the hassles I face with my IIS5
bases system, previously functioning scripts that fail for no apparent
reason... and many other things. I think I am going to start configuring
apache for my system. I ran it some time ago and it runs much faster
than IIS in my application.... but it is going to be labour intensive
converitng the sites, unless someone knows a converter from IIS to apache
Jon
--- End Message ---
--- Begin Message ---
What I've found is that if you're going to making a quick & dirty little
dev environment on a personal machine and you're running Windows, then
using IIS is just fine. It's extremely quick and easy to set up and it's
easy to learn even if you don't know what you're doing and are making
"educated guesses".
If you're setting up a production machine and you want reliability and
you're going to be using languages like PHP, Perl and other
non-Win32-native languages, then stick with Apache. It might take a bit
more understanding of what you're doing to do it right, but it's a lot
more reliable and offers better security and flexibility.
My $.02
-Mike
-----Original Message-----
From: Jon Phipps [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 02, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re: Apache or IIS
You are right, I am getting tired of the hassles I face with my IIS5
bases system, previously functioning scripts that fail for no apparent
reason... and many other things. I think I am going to start configuring
apache for my system. I ran it some time ago and it runs much faster
than IIS in my application.... but it is going to be labour intensive
converitng the sites, unless someone knows a converter from IIS to
apache
Jon
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I have the following php statement which shows results when I run on the
database server in SQL. The page connects to the database server, but for
some reason returns no results. It does show results if I setup for another
table however. The code is:
<?php require_once('../../Connections/Options.php'); ?>
<?php
mysql_select_db($database_Options, $Options);
$query_Recordset1 = "SELECT * FROM TStory";
$Recordset1 = mysql_query($query_Recordset1, $Options) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
The table was made as:
CREATE TABLE `TStory` (
`TstoryUID` smallint(6) NOT NULL auto_increment,
`Title` varchar(100) NOT NULL default '',
`ShortText` varchar(100) NOT NULL default '',
`LongText` varchar(100) NOT NULL default '',
`Page` smallint(6) NOT NULL default '1',
`Section` smallint(6) NOT NULL default '1',
`Writer` varchar(100) NOT NULL default '',
PRIMARY KEY (`TstoryUID`)
) TYPE=MyISAM;
Any thoughts would be greatly appreciated.
--
Dominic
--- End Message ---
--- Begin Message ---
Check what mysql_error() returns.
But I don't the see any code which should even display something:
-Mike
On Sat, 2 Aug 2003, Dominic wrote:
> Date: Sat, 2 Aug 2003 16:21:20 -0400
> From: Dominic <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] php shows no results
>
> I have the following php statement which shows results when I run on the
> database server in SQL. The page connects to the database server, but for
> some reason returns no results. It does show results if I setup for another
> table however. The code is:
>
> <?php require_once('../../Connections/Options.php'); ?>
> <?php
> mysql_select_db($database_Options, $Options);
> $query_Recordset1 = "SELECT * FROM TStory";
> $Recordset1 = mysql_query($query_Recordset1, $Options) or
> die(mysql_error());
> $row_Recordset1 = mysql_fetch_assoc($Recordset1);
> $totalRows_Recordset1 = mysql_num_rows($Recordset1);
> ?>
>
> The table was made as:
> CREATE TABLE `TStory` (
> `TstoryUID` smallint(6) NOT NULL auto_increment,
> `Title` varchar(100) NOT NULL default '',
> `ShortText` varchar(100) NOT NULL default '',
> `LongText` varchar(100) NOT NULL default '',
> `Page` smallint(6) NOT NULL default '1',
> `Section` smallint(6) NOT NULL default '1',
> `Writer` varchar(100) NOT NULL default '',
> PRIMARY KEY (`TstoryUID`)
> ) TYPE=MyISAM;
>
> Any thoughts would be greatly appreciated.
>
> --
> Dominic
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
