php-windows Digest 26 Apr 2002 17:56:57 -0000 Issue 1113
Topics (messages 13325 through 13333):
PHP+COM+manage event
13325 by: mickael jeantet
13330 by: Alan Brown
GD solutions
13326 by: Webmaster
Re: MySQL / PHP - possible to run many sql statements in the same execution?
13327 by: Svensson, B.A.T. (HKG)
Re: Excel not closing after using it via COM
13328 by: Alan Brown
13329 by: Neil Lincoln
Re: installing on a remote web host
13331 by: Nicole Amashta
Re: PHP Graphing engine
13332 by: Shrock, Court
PHP4 and FileMaker ODBC
13333 by: Charles Tassell
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 ---
Hello
I'm writting a client-server application in PHP (4.0.6).
I use a COM object and I can open the server using a method of this object.
I send a message with another method and it's OK, no errors.
But I would like to know if it is possible to catch the event called
Notification which is the answer of the server and how ?
Is it possible to have more informations about errors than "invoke failed" ?
Thank you.
_________________________________________________________________
MSN Photos est le moyen le plus simple de partager et d'imprimer vos photos
: http://photos.msn.com/support/worldwide.aspx
--- End Message ---
--- Begin Message ---
I am fairly sure you are talking about the IConnectionPoint technology which
you get at in VB with "WithEvents".
It is in the COM TODO list but has never bubbled up to be implemented.....
Alan
----- Original Message -----
From: "mickael jeantet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 9:08
Subject: [PHP-WIN] PHP+COM+manage event
> Hello
>
> I'm writting a client-server application in PHP (4.0.6).
>
> I use a COM object and I can open the server using a method of this
object.
> I send a message with another method and it's OK, no errors.
> But I would like to know if it is possible to catch the event called
> Notification which is the answer of the server and how ?
> Is it possible to have more informations about errors than "invoke failed"
?
>
> Thank you.
>
> _________________________________________________________________
> MSN Photos est le moyen le plus simple de partager et d'imprimer vos
photos
> : http://photos.msn.com/support/worldwide.aspx
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
|
I am trying to get GD or imagemagick to work, but get 2 problems:
1st - GD (even in the binaries) must be compiled manually ( I have no
compiler)
2nd- imagemagick can't be downloaded, all server hang if I try (!!!?)
Anyone have an idea how to get one of these?
THNX
Webmaster Baarnhosting.nl
|
--- End Message ---
--- Begin Message ---
> What I would need to do here is either lump all the queryioes into one
> SQL execution or lock the PHP code so it is single threaded like this:
I understand this as that you are trying to deal with the (in)famous
readers&writer problem here? There is a basic technique to deal with
this, and it is called an "atomic action".
In an RDBMS you can perform an atomic action by starting up a transacation
with the highest isolation level. However, in most case you don't need to be
_that_ much "atomic", and a lower transaction lever might very well be optimal
solution most purposes (unnecessary high isolation levels degrades performance.)
//Anders - idiot
--- End Message ---
--- Begin Message ---
There is a missing "Release" call in the COM code when temporary objects are
created for a construct such as
$excel->application->DisplayAlerts = False;
This is not as visible a problem with an inproc server as with a localserver
such as Excel.
It is fairly easy to work around this (until I get a real fix into the base)
by breaking it up thus:
$application = $excel->application;
$application->DisplayAlerts = False;
This has to be done in two places in the example I saw. However I note that
if you put in a logic error such as this:
$book = $workbooks->Open($file);
$sheet = $books->Worksheets(1);
After the exception a copy of Excel is still left running. I wiill look more
at this over the weekend and test my Release() call on the temporary object.
It seems to work, but I fear that it will break something else....
Alan.
----- Original Message -----
From: "Scott Hurring" <[EMAIL PROTECTED]>
To: "Php-Win (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, 25 April, 2002 13:51
Subject: 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 "scott", so it shouldn't be plauged
> by the "SYSTEM" ownership issue... even though
> i haven't tested it)
>
> Please check out: http://furt.com/code/php/com_issues/
> (Read 'readme.txt')
>
> ---
> Scott Hurring
> Systems Programmer
> EAC Corporation
> [EMAIL PROTECTED]
> Voice: 201-462-2149
> Fax: 201-288-1515
>
> > -----Original Message-----
> > From: Neil Lincoln [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 25, 2002 1:20 PM
> > To: Scott Hurring; Php-Win (E-mail)
> > Subject: 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 PROTECTED]]
> > Sent: Thursday, April 25, 2002 11:59 AM
> > To: Php-Win (E-mail)
> > Subject: 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,
> > yet stays alive when the PHP script is
> > finished.
> >
> > ---
> > Scott Hurring
> > Systems Programmer
> > EAC Corporation
> > [EMAIL PROTECTED]
> > Voice: 201-462-2149
> > Fax: 201-288-1515
> >
> > > -----Original Message-----
> > > Try
> > >
> > > $book->Close("False");
> > >
> >
> > Doesnt do anything.
> >
> > > But then one has to ask, why does it work fine from other
> > > languages, e.g. Perl? If the API were broken, it would seem
> > > that it would be broken regardless of the language one was
> > > using.
> > >
> > > Scott
> >
> > Yeah.. that's the way it seems now.
> >
> >
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> >
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
We have tried this and it doesn't help. And yes, any non normal exit from
the EXCEL COM object results in a "zombie".
-----Original Message-----
From: Alan Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 8:00 AM
To: Scott Hurring; Php-Win (E-mail)
Subject: Re: [PHP-WIN] Excel not closing after using it via COM
There is a missing "Release" call in the COM code when temporary objects are
created for a construct such as
$excel->application->DisplayAlerts = False;
This is not as visible a problem with an inproc server as with a localserver
such as Excel.
It is fairly easy to work around this (until I get a real fix into the base)
by breaking it up thus:
$application = $excel->application;
$application->DisplayAlerts = False;
This has to be done in two places in the example I saw. However I note that
if you put in a logic error such as this:
$book = $workbooks->Open($file);
$sheet = $books->Worksheets(1);
After the exception a copy of Excel is still left running. I wiill look more
at this over the weekend and test my Release() call on the temporary object.
It seems to work, but I fear that it will break something else....
Alan.
----- Original Message -----
From: "Scott Hurring" <[EMAIL PROTECTED]>
To: "Php-Win (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, 25 April, 2002 13:51
Subject: 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 "scott", so it shouldn't be plauged
> by the "SYSTEM" ownership issue... even though
> i haven't tested it)
>
> Please check out: http://furt.com/code/php/com_issues/
> (Read 'readme.txt')
>
> ---
> Scott Hurring
> Systems Programmer
> EAC Corporation
> [EMAIL PROTECTED]
> Voice: 201-462-2149
> Fax: 201-288-1515
>
> > -----Original Message-----
> > From: Neil Lincoln [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 25, 2002 1:20 PM
> > To: Scott Hurring; Php-Win (E-mail)
> > Subject: 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 PROTECTED]]
> > Sent: Thursday, April 25, 2002 11:59 AM
> > To: Php-Win (E-mail)
> > Subject: 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,
> > yet stays alive when the PHP script is
> > finished.
> >
> > ---
> > Scott Hurring
> > Systems Programmer
> > EAC Corporation
> > [EMAIL PROTECTED]
> > Voice: 201-462-2149
> > Fax: 201-288-1515
> >
> > > -----Original Message-----
> > > Try
> > >
> > > $book->Close("False");
> > >
> >
> > Doesnt do anything.
> >
> > > But then one has to ask, why does it work fine from other
> > > languages, e.g. Perl? If the API were broken, it would seem
> > > that it would be broken regardless of the language one was
> > > using.
> > >
> > > Scott
> >
> > Yeah.. that's the way it seems now.
> >
> >
> > ---
> > Incoming mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> >
> >
>
> --
> 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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
--- End Message ---
--- Begin Message ---
Also, in some cases, you need to specify a pound-bang directive that points
the path to your php (similar to perl)
#!/usr/bin/php
Try a test php on the server
name the file: phpinfo.php
<?
echo phpinfo();
?>
if that doesnt work, try
*(you should have docs for you site which would tell you this if it is
necessary)
#!/your/path/to/php
<?
echo phpinfo();
?>
Then test your file like so: http://www.yourdomain.com/phpinfo.php
--
Nicole Amashta
Web Application Developer
www.aeontrek.com
"Ross Fleming" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It's already installed and enabled, they've told you that. Simply call
your
> pages .php or .phtml (whatever they tell you to call them) instead of
.html
>
> Ross
>
> -----Original Message-----
> From: rob [mailto:[EMAIL PROTECTED]]
> Sent: 25 April 2002 02:58
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] installing on a remote web host
>
>
> Hi all,
> I have searched for any info on installing php up to a web host's server
as
> far as they have told me "PHP is enabled by default" so! I am looking for
> the documentation that will guide me in the process of uploading and
> activateing php ... thanks!
>
> Rob
> deltona, fl
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
http://www.aditus.nu/jpgraph/
> -----Original Message-----
> From: Matt Babineau [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 25, 2002 4:28 PM
> To: 'Php-Win (E-mail)'
> Subject: [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: <mailto:[EMAIL PROTECTED]>
> [EMAIL PROTECTED]
> p: 603.943.4237
> w: <http://www.illuminatistudios.com/>
> http://www.illuminatistudios.com
>
>
>
--- End Message ---
--- Begin Message ---
I get the impression that this is a fairly common request, but I haven't
seen a definite answer, so I figured I'd ask. Is it possible to use a
FileMaker Pro ODBC connection with PHP4? I have a DSN setup, but when I
try to connect I get the following message (via odbc_errorstr()):
Unable to connect to the database: [FileMaker][ODBC FileMaker Pro
driver][FileMaker Pro]Connect failed
Has anyone successfully connected to FileMaker via ODBC, and if so, what
settings had to be enabled? I know that there is a library called FX (
http://www.iviking.org/projects/FXdownload.php ) which will let you access
FileMaker via the XML interface, but I get the feeling that this is going
to be slower and more complicated than just using ODBC and standard SQL.
I'm using PHP4.1.2 on IIS5 (Win2K) if it makes any difference.
--- End Message ---
