Re: Re[2]: [PHP-WIN] MySql pconnect

2001-04-15 Thread Plutarck
As expressed in the article, the question is what the database was designed to actually "do". MySQL creates quick connections, responds to SELECT statements as fast as anything can, has a small footprint, and does not require any special fees to use it. And yes, it's open source. For the vast maj

php-windows Digest 16 Apr 2001 03:55:26 -0000 Issue 546

2001-04-15 Thread php-windows-digest-help
php-windows Digest 16 Apr 2001 03:55:26 - Issue 546 Topics (messages 6743 through 6765): Re: MySQL problem 6743 by: Plutarck 6746 by: Patrick 6748 by: Svensson, B.A.T. Re: MySql pconnect 6744 by: Plutarck 6749 by: Daniel Beulshausen 6752 by:

Re: [PHP-WIN] PHP4 won't display page

2001-04-15 Thread OoCobra97
Ok, first as mentioned on another email, change your AddType application/x-httpd-php .phtml .phps to: AddType application/x-httpd-php .phtml .php also, try putting your php scripts in your script alias, in your case c:\php4 and call them by using yourdomain/php4/scriptname hope this helps ~Je

Re: [PHP-WIN] PHP install : no result!!!

2001-04-15 Thread Phil Driscoll
Change ScriptAlias /php4/ "c:/php/" to ScriptAlias /php/ "c:/php/" Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additi

Re: [PHP-WIN] PHP install : no result!!!

2001-04-15 Thread Manuela DIALLO
> Can you show us what you have done in your httpd.conf file? Yes of course! Here included the relevant lines , thank you! Manu LoadModule php4_module c:/php/sapi/php4apache.dll ServerName 127.0.0.1 ScriptAlias /cgi-bin/ "C:/Program Files/Apache Group/Apache/cgi-bin/"

Re[2]: [PHP-WIN] MySql pconnect

2001-04-15 Thread Daniel Beulshausen
i'm going to specify at apache now :) Sunday, April 15, 2001, 8:52:59 PM, you wrote: > But my point is that the communication overhead is still gained by process > based systems. True they don't have the same pooling ability, as does a > threaded process management. Overhead saved using pconnec

Re: [PHP-WIN] MySql pconnect

2001-04-15 Thread Joe Brown
But my point is that the communication overhead is still gained by process based systems. True they don't have the same pooling ability, as does a threaded process management. Overhead saved using pconnect is that which is being debated here. On a side note The OCI8 module in it's latest r

Re: [PHP-WIN] MySql pconnect

2001-04-15 Thread Daniel Beulshausen
Sunday, April 15, 2001, 6:45:14 PM, you wrote: > Your comment reguarding threaded sapi's although accurate, leaves > out > process based systems. They also benefit from pconnects, because > the PHP > process lives on past the life of a single web page. such things can't be shared amongst process

Re: [PHP-WIN] PHP4 won't display page

2001-04-15 Thread Phil Driscoll
Change AddType application/x-httpd-php .phtml .phps to AddType application/x-httpd-php .phtml .php Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-WIN] Problem with PHP and tiny web server

2001-04-15 Thread Animorph840
I'm using it to run a small website on my local network, but I want a minimum of a performance hit in games and things. ""Phil Driscoll"" <[EMAIL PROTECTED]> wrote in message 00af01c0c589$fca950c0$0c01a8c0@philsntserver">news:00af01c0c589$fca950c0$0c01a8c0@philsntserver... > >I already have PHP r

[PHP-WIN] PHP4 won't display page

2001-04-15 Thread Warren Hemming
I have installed apache and PhP4 on a win 2000 machine. The apache server will start up saying that PHP is running. I have created a test page in the htdocs folder with the extention .php and saved as an ANSI endcoding. When I view the apache server everything looks good, but when I put the test

Re: [PHP-WIN] Supplied argument is not valid MS SQL-Link resource

2001-04-15 Thread Frank M. Kromann
mssql_select_db returns true or false and not a link resource. You should change the code to: $Conn=mssql_connect('192.168.1.20','username','password'); if (mssql_select_db('My_Database',$Conn)) { $QueryString="select id, name from my_table"; $Test=mssql_query($QueryString, $Conn);

RE: Re[2]: [PHP-WIN] MySql pconnect

2001-04-15 Thread Svensson, B.A.T.
>-Original Message- >From: Plutarck [] >http://www.webtechniques.com/archives/2001/01/jagielski/ > >Skip down to where it mentions databases...very enlightening. Yeah... MySQL is even a worse RDBM's than I thought since before. No stored procedure, no transactions, no jezus!!! --

Re: [PHP-WIN] PHP install : no result!!!

2001-04-15 Thread Phil Driscoll
Can you show us what you have done in your httpd.conf file? -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EM

Re: [PHP-WIN] PHP install : no result!!!

2001-04-15 Thread Julie Meloni
Manuela DIALLO wrote: > Dear all, > > I've installed PHP and Apache on my PC under win98. Apache is running fine > and launching PHP at the same time. > When I open a php file (.php) under my browser, the PC is launching a > console window which is immediately closing... It sounds as if your A

Re: Re[2]: [PHP-WIN] MySql pconnect

2001-04-15 Thread Plutarck
http://www.webtechniques.com/archives/2001/01/jagielski/ Skip down to where it mentions databases...very enlightening. I think I may just consider slipping a "p" into my db_connect() function :) -- Plutarck Should be working on something... ...but forgot what it was. "Daniel Beulshausen" <[E

[PHP-WIN] PHP install : no result!!!

2001-04-15 Thread Manuela DIALLO
Dear all, I've installed PHP and Apache on my PC under win98. Apache is running fine and launching PHP at the same time. When I open a php file (.php) under my browser, the PC is launching a console window which is immediately closing... I suppose it's a PHP console window. This window is empty a

Re: [PHP-WIN] Instaling PHP in windows with Apache

2001-04-15 Thread Manuela DIALLO
Dear Giro, Thank you for your inputs. I've done the same as you explained to Margarida, but... my browser is displaying nothing... I've installed PHP and Apache on my PC under win98. Apache is running fine and launching PHP at the same time. When I open a php file (.php) under my browser, the PC

Re[2]: [PHP-WIN] MySql pconnect

2001-04-15 Thread Daniel Beulshausen
Sunday, April 15, 2001, 3:38:48 PM, you wrote: > When you call pconnect when a persistant connection is already available, it > is approximately the same speed as when you call connect for the second time > in a script. It still is a delay. It's not "instant", because PHP has to > check and see if

RE: [PHP-WIN] MySQL problem

2001-04-15 Thread Svensson, B.A.T.
You first error message says: TRY TO DO A TELNET TO 'LOCALHOST' AT PORT '3306'. Do this!!! by starting telnet. Type in localhost or IP# 127.0.0.1 and adjust the port number to 3306. Then try to connect. If you gets the message "connection refused" it means that either you SQL server is not up

RE: [PHP-WIN] WinNT, PHP4, IIS4, exec() Nothing Happens at all!

2001-04-15 Thread Svensson, B.A.T.
>-Original Message- >From: Dave Faulkner [mailto:[EMAIL PROTECTED]] >Sent: Sunday, April 15, 2001 5:15 AM >To: [EMAIL PROTECTED] >Subject: [PHP-WIN] WinNT, PHP4, IIS4, exec() Nothing Happens at all! >Below is some of the stuff i have tried: > >// exec("I:\Perl\bin\cjpeg.exe -quality 30 -

Re: [PHP-WIN] MySQL problem

2001-04-15 Thread Patrick
"Chris" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks for the reply. > > I went to mysql bin directory and typed mysql.exe, I get an error > message > "Error 2003: Can't connect to MySQL server on 'localhost' (10061)" > > What's the problem? Please adv

Re: [PHP-WIN] WinNT, PHP4, IIS4, exec() Nothing Happens at all!

2001-04-15 Thread Patrick
""Dave Faulkner"" <[EMAIL PROTECTED]> wrote in message 9bb3cf$ck0$[EMAIL PROTECTED]">news:9bb3cf$ck0$[EMAIL PROTECTED]... > Hi People!, > > this seems like an age old question that just doesnt seem to be able to get > solved. I too have a problem calling NT programs from within my PHP script. > H

Re: [PHP-WIN] MySql pconnect

2001-04-15 Thread Plutarck
Hm...ok, let's see here. Persistant connection vs. non. Pros and cons...*ponder* I haven't heard a whole lot about the debate, but here is what I'm thinking. When you call pconnect when a persistant connection is already available, it is approximately the same speed as when you call connect for

Re: [PHP-WIN] MySQL problem

2001-04-15 Thread Plutarck
Press Ctrl+Alt+Delete once, and see if you see any running programs such as "Mysqld-opt" or something to that effect. If not, I don't think MySQL is running on your system. Go back into your mysql directory and execute the file mysqld.exe I believe that should start MySQL. Then try connecting

php-windows Digest 15 Apr 2001 11:42:31 -0000 Issue 545

2001-04-15 Thread php-windows-digest-help
php-windows Digest 15 Apr 2001 11:42:31 - Issue 545 Topics (messages 6731 through 6742): Re: Problem with PHP and tiny web server 6731 by: Animorph840 6735 by: Phil Driscoll Need PHP/MySQL Assistance 6732 by: Bob Sears 6733 by: Tomasz Abramowicz 6738

Re: [PHP-WIN] MySQL problem

2001-04-15 Thread Chris
Thanks for the reply. I went to mysql bin directory and typed mysql.exe, I get an error message "Error 2003: Can't connect to MySQL server on 'localhost' (10061)" What's the problem? Please advise. I am running Win98SE with Apache. Plutarck wrote: > > Try going into your mysql bin directory

Re: [PHP-WIN] MySql pconnect

2001-04-15 Thread Phil Driscoll
I agree with James on this one - surely it makes sense if php is running as a server module and can keep hold of connections to utilise the performance advantage of pconnect. I'd be interested to know if there are any disadvantages to this, I may need to change some code :) Cheers -- Phil Drisco

Re: [PHP-WIN] MySQL problem

2001-04-15 Thread Plutarck
Try going into your mysql bin directory, then type: mysql.exe Then try using connect, or just doing your query. If that doesn't work, ensure MySQL is running. If that doesn't work...then there is some other problem. -- Plutarck Should be working on something... ...but forgot what it was. "C

RE: [PHP-WIN] MySql pconnect

2001-04-15 Thread James Moore
> > For connect vs. pconnect, the instances where you should use pconnect are > really rare. > > When in doubt, use connect. If you know of a specifically good > reason to use > it, then feel free. > > But I personally have never had a situation where pconnect worked better > than connect. pco

Re: [PHP-WIN] Need PHP/MySQL Assistance

2001-04-15 Thread Plutarck
Yah, either paste it in or paste a link to the code. Only 120 lines of code is a nice learning chunk. 1000 lines of MySQL oriented functions make it easy by comparison ;) (I especially like when I get a parse error on line "764", when that's the last line of the script, and it's because I forgot

Re: [PHP-WIN] MySql pconnect

2001-04-15 Thread Plutarck
For connect vs. pconnect, the instances where you should use pconnect are really rare. When in doubt, use connect. If you know of a specifically good reason to use it, then feel free. But I personally have never had a situation where pconnect worked better than connect. And as for extended serv

[PHP-WIN] MySQL problem

2001-04-15 Thread Chris
I was trying to create a database for PHP using MySQL with the command c:\mysql\bin>mysqladmin create database01 and I received the following error message "Can't connect to MySQL server on 'localhost' (10061) Check that mysql is running on localhost and that the port is 3306. You can check this b

Re: [PHP-WIN] Problem with PHP and tiny web server

2001-04-15 Thread Phil Driscoll
>I already have PHP running on it as a filter, but Xitami, although small, is >about 10 times bigger than tiny webserver, and has a tray icon. I want to >keep ram usage to a bare minimum. Sadly though, it appears that the tiny web server has saved some of its memory by not implementing a cgi inte