php-windows Digest 26 Apr 2002 05:21:08 -0000 Issue 1112

php-windows Digest 26 Apr 2002 05:21:08 - Issue 1112 Topics (messages 13304 through 13324): Re: Excel not closing after using it via COM 13304 by: Neil Lincoln 13305 by: Scott Hurring Single threading a database call 13306 by: Matt Babineau 13311 by: Vail, W

[PHP-WIN] Re: Getting Apache 2.0.35 and PHP 4.2 to work on Win2k

David, Install PHP 4.2 like you usually would but in your httpd.conf put: LoadModule php4_module C:\php\experimental\apache2filter.dll AddType application/x-httpd-php .php I did a complete uninstall and reinstall of both apache and php when I upgraded so nothing would be confused. --Chris

[PHP-WIN] re: the database locking

Here is the code that appears to work: $result0 = mysql_query("LOCK TABLES COUNTER_Page_Views WRITE"); $result1 = mysql_query("UPDATE COUNTER_Page_Views SET Count = Count + 1 WHERE Counter_ID = '" . $count_id . "'"); $result2 = mysql_query("SELECT Count FROM COUNTER_Page_Views WHERE Counter_ID =

Re: [PHP-WIN] Anoter explaination of my problem

Dude... if you use LOCK TABLE WRITE (not READ) on the table.. it will STAY locked.. until you give the UNLOCK command. It completely solves any concurrency issues. This is a fundamental database issue and MySQL is meant to handle it. :) -Mike At 05:19 PM 4/25/02 -0400, Matt Babineau wrote:

RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?

Suggestions: http://www.mysql.com/doc/L/o/Locking_Issues.html http://www.mysql.com/doc/T/r/Transactional_Commands.html VERY good: http://www.mysql.com/articles/ddws/61.html http://www.phpbuilder.com/forum/read.php3?num=5&id=23671&loc=0&thread=23671 At 04:59 PM 4/25/02 -0400, you wrote: >Well, w

[PHP-WIN] Re: Security Alert!-cgi.force_redirect=0

You might need to have the second line in PHP.INI too: cgi.force_redirect=0 cgi.redirect_status_env ENV_VAR_NAME Cor van de Veen "Matthew Gotth-Olsen" <[EMAIL PROTECTED]> schreef in bericht [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm running IIS on a WinXP box, I've got everything inst

[PHP-WIN] Re: PHP Graphing engine

http://www.hotscripts.com/PHP/ --- "Matt Babineau" <[EMAIL PROTECTED]> schreef in bericht 014d01c1ecb0$c7fc8960$0100a8c0@developerx">news:014d01c1ecb0$c7fc8960$0100a8c0@developerx... > Does anyone know of any good graphing engines for PHP? I n

[PHP-WIN] PHP Graphing engine

Does anyone know of any good graphing engines for PHP? I need a slick way to represent some numerical data. Matt Babineau Freelance Internet Developer e: [EMAIL PROTECTED] p: 603.943.4237 w: http://www.illuminatistudios.com

[PHP-WIN] Security Alert!-cgi.force_redirect=0

I'm running IIS on a WinXP box, I've got everything installed, however whenever I try to access a php script I get this error which I'm sure you all are familiar with: -- Security Alert! PHP CGI cannot be accessed directly. This

[PHP-WIN] Anoter explaination of my problem

thread1 > updates and increments a numebr in the DB thread2 > does the same thing as thread one thread1 > reads the database to get the new value for display on the web page thread2 > also reads the database for the new updated value. so thread1 displays "2" and thread2 display

RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?

Well, when I tested the code, It was still allowing 2 requests to update/read the table at the same time. It may only be in the case tha tI am facing when I am updating the table but also need to output the new value that was updated. I may just be attacking this problem wrong too. Matt Babineau

RE: [PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?

Sorry for seeming a bit dense, but what's the problem with using "LOCL TABLES" for all SQL stmnts? It's my understanding that it will lock tables and prevent other procs from reading/writing to that table while you've got a lock on it. Is that not the case? --- Scott Hurring Systems Programmer

[PHP-WIN] MySQL / PHP - possible to run many sql statements in the same execution?

Let me try and explain a little better: Here is some query code $query3 = "LOCK TABLES COUNTER_PAGE_VIEWS"; $query = "SELECT Count FROM COUNTER_Page_Views WHERE Counter_ID = '" . $count_id . "'"; $query1 = "UPDATE COUNTER_Page_Views SET Count = Count + 1 WHERE Counter_ID = '" . $count_id . "'"

[PHP-WIN] command line options to php.exe

I'm trying to pass command line options to php.exe under IIS 5 (win2k), but without any success. What's going on is that I've got two sites that need their own include_path's. I've tried putting "C:\php\php.exe -d include_path='.;c:\foo' %s %s" and "C:\php\php.exe -c c:\foo %s %s" into the I

RE: [PHP-WIN] Single threading a database call

Because you didn't say, I have to assume you are using MySQL as your database. It is my understanding that an Auto Increment of a primary key field is single threaded, such that if you do an insert, followed by mysql_insert_id () to get the number inserted. Anything else, that I can think of

RE: [PHP-WIN] re: making a DB counter

Thanks Scott I think this will help, will let you know how it comes out. Matt Babineau Freelance Internet Developer e: [EMAIL PROTECTED] p: 603.943.4237 w: http://www.illuminatistudios.com -Original Message- From: Scott Hurring [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 20

RE: [PHP-WIN] File upload issue 4.2.0

If you will notice, the error happens on line 0. That happens before PHP hits my scripts, so the error here is a processing error in PHP... not the result of a command I run. I could post to an empty file and PHP would still kick out this error if I didn't specify anything in the tag on the pre

RE: [PHP-WIN] re: making a DB counter

Try this: http://www.mysql.com/doc/L/O/LOCK_TABLES.html That seems to be what you're asking for... to lock down the table while you select, then update... --- Scott Hurring Systems Programmer EAC Corporation [EMAIL PROTECTED] Voice: 201-462-2149 Fax: 201-288-1515 > -Original Message-

[PHP-WIN] re: making a DB counter

Here is a snip of my code $query = "SELECT Count FROM COUNTER_Page_Views WHERE Counter_ID = '" . $count_id . "' FOR UPDATE"; $query1 = "UPDATE COUNTER_Page_Views SET Count = Count + 1 WHERE Counter_ID = '" . $count_id . "'"; $result = mysql_query($query); $result1 = mysql_query($query1); what

[PHP-WIN] Single threading a database call

I am making a call to a database to update a record incrementing the number in the field. When I put some load on this page, I get it returning the same number sometimes. This is unacceptable. because under heavier load people will be receiving the same number and it will not count the correct amo

RE: [PHP-WIN] Excel not closing after using it via COM

I'm not doing this through Apache. I tried out Win32 command line PHP and Perl. So even though it might be an issue with Excel being owned by "SYSTEM" when run thru Apache, PHP still leaves it open whereas Perl does not. (And to boot, my Apache service is configured to RunAs my account "scot

RE: [PHP-WIN] Excel not closing after using it via COM

On our systems the EXCEL COM object executes as a member of "SYSTEM" instead of as a child of the owner of the Apache/php server. When the COM object completes it leaves the EXCEL hanging around as a child of a SYSTEM process. -Original Message- From: Scott Hurring [mailto:[EMAIL PROTECTE

php-windows Digest 25 Apr 2002 17:00:29 -0000 Issue 1111

php-windows Digest 25 Apr 2002 17:00:29 - Issue Topics (messages 13300 through 13303): Image creationm (again) 13300 by: Brian McGarvie getimagesize warnings... 13301 by: Martin.Andrew Re: installing on a remote web host 13302 by: Vail, Warren Re: Excel not c

RE: [PHP-WIN] Excel not closing after using it via COM

I went back and ran some perl code using the Excel COM object. Excel does properly exit... so it looks like you are correct -- it's probably a bug in PHP's COM code. Attached is is sample Perl, PHP and Excel, if anyone wants to verify that excel does indeed die after the perl script is finished

RE: [PHP-WIN] installing on a remote web host

You can upload the following page and test quickly - - upload the above line of code to something like test.php and invoke it with your browser http://www.yourdomain.com/test.php If you get a page of useful information abou

[PHP-WIN] getimagesize warnings...

I'm trying to upload images to the websever I create a temp file and copy it to the webserver 95% of the time I have no problems, occasionally I get the follwoing errors.. Warning: getimagesize: Read error! When I check the web server a file with the same name of the image I tried to copy exis

[PHP-WIN] Image creationm (again)

I've also been having trouble with using GD, the extension is loaded correctly, however when I execute my code the image in IE (not tried it in anything else yet) is blank... -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php