php-windows Digest 27 Apr 2007 01:29:51 -0000 Issue 3209
Topics (messages 27768 through 27780):
PHP & SQL Server 2005
27768 by: Dale Attree
27769 by: Alf Stockton
27770 by: Dale Attree
27771 by: Gustav Wiberg
27772 by: Gustav Wiberg
27773 by: Gustav Wiberg
27776 by: Dan Shirah
Re: [PHP] slow performance
27774 by: Stanislav Malyshev
27775 by: Stanislav Malyshev
27779 by: Henning Eiben
Javascript email group
27777 by: Alf Stockton
27778 by: Mikael Grön
Re: MySQL + SSL with PHP on windows
27780 by: bedul
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 guys.
I am able to do select queries without any hassles, but as soon as I try
execute an insert query, I get "The statement has been terminated."
Any suggestions?
Kind Regards,
Dale
***********************************************************************************************
The information contained in this e-mail is confidential and may be subject to
legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in reliance
on it. If you have received this e-mail in error, please notify us immediately
by e-mail ([EMAIL PROTECTED]) or telephone (+27 11 265 4200). This message is
free of all known viruses. It has been screened for viruses by Blockmail.
***********************************************************************************************
--- End Message ---
--- Begin Message ---
Dale Attree wrote:
Hi guys.
I am able to do select queries without any hassles, but as soon as I try
execute an insert query, I get "The statement has been terminated."
Any suggestions?
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
$RP = $_SERVER['REQUEST_URI'];
$res = mssql_query($sql,$dblink) or
die($RP.'<br>'.mssql_get_last_message());
It is hitting the die() and therefore not inserting into the DB.
-----Original Message-----
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:06 AM
To: Dale Attree
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP & SQL Server 2005
Dale Attree wrote:
> Hi guys.
>
>
>
> I am able to do select queries without any hassles, but as soon as I try
> execute an insert query, I get "The statement has been terminated."
>
>
>
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
***********************************************************************************************
The information contained in this e-mail is confidential and may be subject to
legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in reliance
on it. If you have received this e-mail in error, please notify us immediately
by e-mail ([EMAIL PROTECTED]) or telephone (+27 11 265 4200). This message is
free of all known viruses. It has been screened for viruses by Blockmail.
***********************************************************************************************
--- End Message ---
--- Begin Message ---
Hi there!
"$RP = $_SERVER['REQUEST_URI'];"
Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ?
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:13 AM
To: 'Alf Stockton'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
$RP = $_SERVER['REQUEST_URI'];
$res = mssql_query($sql,$dblink) or
die($RP.'<br>'.mssql_get_last_message());
It is hitting the die() and therefore not inserting into the DB.
-----Original Message-----
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:06 AM
To: Dale Attree
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP & SQL Server 2005
Dale Attree wrote:
> Hi guys.
>
>
>
> I am able to do select queries without any hassles, but as soon as I try
> execute an insert query, I get "The statement has been terminated."
>
>
>
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
***********************************************************************************************
The information contained in this e-mail is confidential and may be subject to
legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in reliance
on it. If you have received this e-mail in error, please notify us immediately
by e-mail ([EMAIL PROTECTED]) or telephone (+27 11 265 4200). This message is
free of all known viruses. It has been screened for viruses by Blockmail.
***********************************************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi again
Is it the the same with updates?
Maybe its something about limitation in table?
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2000-and-2005.aspx
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:24 AM
To: 'Gustav Wiberg'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Doesn't matter. That variable is not related to my problem.
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Hi there!
"$RP = $_SERVER['REQUEST_URI'];"
Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ?
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:13 AM
To: 'Alf Stockton'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
$RP = $_SERVER['REQUEST_URI'];
$res = mssql_query($sql,$dblink) or
die($RP.'<br>'.mssql_get_last_message());
It is hitting the die() and therefore not inserting into the DB.
-----Original Message-----
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:06 AM
To: Dale Attree
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP & SQL Server 2005
Dale Attree wrote:
> Hi guys.
>
>
>
> I am able to do select queries without any hassles, but as soon as I try
> execute an insert query, I get "The statement has been terminated."
>
>
>
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
****************************************************************************
*******************
The information contained in this e-mail is confidential and may be subject
to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify us
immediately by e-mail ([EMAIL PROTECTED]) or telephone (+27
11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
****************************************************************************
*******************
--
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
***********************************************************************************************
The information contained in this e-mail is confidential and may be subject to
legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in reliance
on it. If you have received this e-mail in error, please notify us immediately
by e-mail ([EMAIL PROTECTED]) or telephone (+27 11 265 4200). This message is
free of all known viruses. It has been screened for viruses by Blockmail.
***********************************************************************************************
--- End Message ---
--- Begin Message ---
Hi again!
Maybe it's something about rights for the IUSR?
Else I don't know...
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:37 AM
To: 'Gustav Wiberg'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
It is a brand new database, now data in it.
When I execute the queries through the studio manager, they work.
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:32 AM
To: 'php windows' ([EMAIL PROTECTED])
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Hi again
Is it the the same with updates?
Maybe its something about limitation in table?
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2
000-and-2005.aspx
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:24 AM
To: 'Gustav Wiberg'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Doesn't matter. That variable is not related to my problem.
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Hi there!
"$RP = $_SERVER['REQUEST_URI'];"
Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ?
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:13 AM
To: 'Alf Stockton'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
$RP = $_SERVER['REQUEST_URI'];
$res = mssql_query($sql,$dblink) or
die($RP.'<br>'.mssql_get_last_message());
It is hitting the die() and therefore not inserting into the DB.
-----Original Message-----
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:06 AM
To: Dale Attree
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP & SQL Server 2005
Dale Attree wrote:
> Hi guys.
>
>
>
> I am able to do select queries without any hassles, but as soon as I try
> execute an insert query, I get "The statement has been terminated."
>
>
>
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
****************************************************************************
*******************
The information contained in this e-mail is confidential and may be subject
to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify us
immediately by e-mail ([EMAIL PROTECTED]) or telephone (+27
11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
****************************************************************************
*******************
--
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
****************************************************************************
*******************
The information contained in this e-mail is confidential and may be subject
to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify us
immediately by e-mail ([EMAIL PROTECTED]) or telephone (+27
11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
****************************************************************************
*******************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
***********************************************************************************************
The information contained in this e-mail is confidential and may be subject to
legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute or
disclose the e-mail or any part of its contents or take any action in reliance
on it. If you have received this e-mail in error, please notify us immediately
by e-mail ([EMAIL PROTECTED]) or telephone (+27 11 265 4200). This message is
free of all known viruses. It has been screened for viruses by Blockmail.
***********************************************************************************************
--- End Message ---
--- Begin Message ---
This could also be caused by a mismatch in the fields. Try opening up your
SQL Management Studio and then paste your INSERT statement into a new query,
execute it and see if it works.
On 4/26/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
Hi again!
Maybe it's something about rights for the IUSR?
Else I don't know...
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:37 AM
To: 'Gustav Wiberg'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
It is a brand new database, now data in it.
When I execute the queries through the studio manager, they work.
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:32 AM
To: 'php windows' ([EMAIL PROTECTED])
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Hi again
Is it the the same with updates?
Maybe its something about limitation in table?
http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2
000-and-2005.aspx
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:24 AM
To: 'Gustav Wiberg'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Doesn't matter. That variable is not related to my problem.
-----Original Message-----
From: Gustav Wiberg [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
Hi there!
"$RP = $_SERVER['REQUEST_URI'];"
Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ?
Best regards
/Gustav Wiberg
-----Original Message-----
From: Dale Attree [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 8:13 AM
To: 'Alf Stockton'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] PHP & SQL Server 2005
$RP = $_SERVER['REQUEST_URI'];
$res = mssql_query($sql,$dblink) or
die($RP.'<br>'.mssql_get_last_message());
It is hitting the die() and therefore not inserting into the DB.
-----Original Message-----
From: Alf Stockton [mailto:[EMAIL PROTECTED]
Sent: 26 April 2007 08:06 AM
To: Dale Attree
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP & SQL Server 2005
Dale Attree wrote:
> Hi guys.
>
>
>
> I am able to do select queries without any hassles, but as soon as I try
> execute an insert query, I get "The statement has been terminated."
>
>
>
> Any suggestions?
>
The "The statement has been terminated." does not necessarily mean that
the insert failed.
Look in the table and see if the insert was successful.
--
Regards,
Alf Stockton www.stockton.co.za
You can do very well in speculation where land or anything to do with dirt
is concerned.
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
****************************************************************************
*******************
The information contained in this e-mail is confidential and may be
subject
to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute
or
disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify
us
immediately by e-mail ([EMAIL PROTECTED]) or telephone
(+27
11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
****************************************************************************
*******************
--
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
****************************************************************************
*******************
The information contained in this e-mail is confidential and may be
subject
to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute
or
disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify
us
immediately by e-mail ([EMAIL PROTECTED]) or telephone
(+27
11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
****************************************************************************
*******************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
***********************************************************************************************
The information contained in this e-mail is confidential and may be
subject to legal privilege.
Access to this e-mail by anyone other than the intended recipient is
unauthorised.
If you are not the intended recipient you must not use, copy, distribute
or disclose the e-mail or any part of its contents or take any action in
reliance on it. If you have received this e-mail in error, please notify us
immediately by e-mail ([EMAIL PROTECTED]) or telephone
(+27 11 265 4200). This message is free of all known viruses. It has been
screened for viruses by Blockmail.
***********************************************************************************************
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
OK, I installed FCGI and ran my testsuite. I did get more requests in a
timeperiod of 5 minutes, but unfortunatly I also got a lot of errors
(HTTP 500). But the performance of successful pages was increased by
almost 15%.
Maybe you need to configure FastCGI for more processes - 500 could be
result of getting more requests than there are processes to handle them.
--
Stanislav Malyshev, Zend Products Engineer
[EMAIL PROTECTED] http://www.zend.com/
--- End Message ---
--- Begin Message ---
If you interested in further improving performance, look at bytecode
caches such as Zend Platform or APC. It can be especially beneficial if
you use frameworks containing a lot of PHP classes.
As I already mentioned, I used eAccelerator. Does APC perform better?
No idea about eAccelerator, didn't test it.
--
Stanislav Malyshev, Zend Products Engineer
[EMAIL PROTECTED] http://www.zend.com/
--- End Message ---
--- Begin Message ---
Stanislav Malyshev wrote:
>> OK, I installed FCGI and ran my testsuite. I did get more requests in a
>> timeperiod of 5 minutes, but unfortunatly I also got a lot of errors
>> (HTTP 500). But the performance of successful pages was increased by
>> almost 15%.
>
> Maybe you need to configure FastCGI for more processes - 500 could be
> result of getting more requests than there are processes to handle them.
How would I do that?
--
... Does killing time harm eternity?
--- End Message ---
--- Begin Message ---
For those looking for a javascript email group you may want to look at:-
http://magnumip.co.za/cgi-bin/mailman/listinfo/webdev
Do remember that this is not just javascript but also includes "all the
questions they were too afraid to ask about web development (including
but not limited to HTML, Javascript, PHP, DHTML, CSS2, XML, XHTML, ASP,
.Net, back-end integration, design, scripting, security, DOMs blah blah
blah)."
--
Regards,
Alf Stockton www.stockton.co.za
Are you making all this up as you go along?
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
Nice! Thanks
Alf Stockton skrev:
For those looking for a javascript email group you may want to look at:-
http://magnumip.co.za/cgi-bin/mailman/listinfo/webdev
Do remember that this is not just javascript but also includes "all
the questions they were too afraid to ask about web development
(including but not limited to HTML, Javascript, PHP, DHTML, CSS2, XML,
XHTML, ASP, .Net, back-end integration, design, scripting, security,
DOMs blah blah blah)."
--- End Message ---
--- Begin Message ---
perhaps u not configure the user first>??
SSL not read as localhost
----- Original Message -----
From: "Adam Madsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2007 10:16 AM
Subject: [PHP-WIN] Re: MySQL + SSL with PHP on windows
> I have been having the same issue.
>
> Using PHP 5.2.1 mysql or mysqli I can not connect to a remote Mysql server
> using SSL
> I can get it to work on a mysql command line client just not with PHP.
>
> Has anyone ever had this working on an IIS box?
>
>
> Adam Madsen
> ------------------
> IT Director Transwest Group
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
