php-windows Digest 7 Oct 2004 03:57:44 -0000 Issue 2422
Topics (messages 24700 through 24710):
Re: Function reference
24700 by: Sven Schnitzke
24703 by: Gryffyn, Trevor
24704 by: Gryffyn, Trevor
PHP5, IIS & MySQL
24701 by: James Nunnerley
24702 by: Felipe Gasper
Re: Unable to load php_mysql.dll
24705 by: PHPDiscuss - PHP Newsgroups and mailing lists
24706 by: PHPDiscuss - PHP Newsgroups and mailing lists
24707 by: PHPDiscuss - PHP Newsgroups and mailing lists
php_mysql.dll - WON'T WORK!!
24708 by: PHPDiscuss - PHP Newsgroups and mailing lists
24709 by: Kevin Williams
Convert Nominal Number into string spelling in PHP
24710 by: susilo
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 ---
Dale,
best thing you can do is start by developing the script using
Word's VBA using builtin calltips, help and object browser
then translate it to PHP.
The most important thing to observe is that PHP's COM
implementation does not implement multidimensional variant
arrays (at least as of 4.3.3, the latest version I used to COM with).
That is, e.g. in Excel you may get a Range of some cells as
an object:
$r = $ActiveSheet->Range('A1:A20');
, but you cannot say
$arr = $r->Value;
You have to retrieve the values one by one using Cells().
In Word there might exist similar limitations.
Good luck!
--
Sven
> -----Urspr�ngliche Nachricht-----
> Von: Dale Attree [SMTP:[EMAIL PROTECTED]
> Gesendet am: Mittwoch, 6. Oktober 2004 09:21
> An: PHP Windows Mailing List
> Betreff: [PHP-WIN] Function reference
>
> Hi,
>
> Does anyone have or know where I can find a function reference for
> MicroSoft Word as a COM object in PHP, other than the example in the PHP CHM
> file and/or manual.
>
> Kind Regards,
> Dale
>
--- End Message ---
--- Begin Message ---
This might help a little:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrco
re/html/wrconwordobjectmodeloverview.asp
Microsoft has a few object models online that give you an idea of the
objects, properties, methods, etc in their products. The one for
MapPoint is excellent. Other MS products have severely unhelpful object
models (or none at all) online.
There's a Word VBA Yahoo group that I joined a while ago that could be
some help if you plan on doing a lot of stuff with Word via COM. You'll
have to learn to translate the VBA syntax to PHP but it's not too hard
once you get the hang of it.
I find it easier to just use VBA when doing COM stuff, but if you need
to use PHP, there are some examples out there to help you out. I made a
PHP script that COM's to MapPoint that works fairly well, but it's
smoother to just do it via VBA.
I love PHP, but right tool for the right job, ya know?
If you have specific questions, feel free to drop me a line and I'll see
if I can help.
-TG
> -----Original Message-----
> From: Dale Attree [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 06, 2004 3:21 AM
> To: PHP Windows Mailing List
> Subject: [PHP-WIN] Function reference
>
>
> Hi,
>
> Does anyone have or know where I can find a function reference for
> MicroSoft Word as a COM object in PHP, other than the example
> in the PHP CHM
> file and/or manual.
>
> Kind Regards,
> Dale
>
--- End Message ---
--- Begin Message ---
Very good point. The VBA editor and related help can definitely be a good place to
look for information. A lot of times in VBA, you just start typing and it pops up
with help and options relating to what you're entering.
I've written things in VBA then translated them to PHP just to get the structure and
syntax down.
-TG
> -----Original Message-----
> From: Sven Schnitzke [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 06, 2004 4:30 AM
> To: '[PHP-WIN]'
> Subject: AW: [PHP-WIN] Function reference
>
>
> Dale,
>
> best thing you can do is start by developing the script using
> Word's VBA using builtin calltips, help and object browser
> then translate it to PHP.
>
> The most important thing to observe is that PHP's COM
> implementation does not implement multidimensional variant
> arrays (at least as of 4.3.3, the latest version I used to COM with).
> That is, e.g. in Excel you may get a Range of some cells as
> an object:
>
> $r = $ActiveSheet->Range('A1:A20');
>
> , but you cannot say
>
> $arr = $r->Value;
>
> You have to retrieve the values one by one using Cells().
> In Word there might exist similar limitations.
>
> Good luck!
> --
> Sven
>
> > -----Urspr�ngliche Nachricht-----
> > Von: Dale Attree [SMTP:[EMAIL PROTECTED]
> > Gesendet am: Mittwoch, 6. Oktober 2004 09:21
> > An: PHP Windows Mailing List
> > Betreff: [PHP-WIN] Function reference
> >
> > Hi,
> >
> > Does anyone have or know where I can find a function reference for
> > MicroSoft Word as a COM object in PHP, other than the
> example in the PHP CHM
> > file and/or manual.
> >
> > Kind Regards,
> > Dale
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
I've been asked to setup a webserver, which currently runs various ASP.NET
stuff, with PHP ability, linking to a MySQL Db.
I've always found it easy to configure PHP, MySQL etc on Apache, but never done
it on IIS.
I've followed the instructions on the PHP website, and can php display scripts;
however, ever time I try to connect to mysql I get the following:
Unable to load dynamic library './php_mysql.dll' - The specified module could
not be found.
I've put php_mysql.dll in the /%SystemRoot%/system32 directory, which is how
Apache used to find it, but it still comes up with an error.
Any ideas?
Also, as a bit of an aside, I'm also being asked to make sure that this is
secure and safe to run - does anyone have any thoughts with regards to the
security of running PHP on IIS, and anything I should do to prevent future
security problems.
Cheers
Nunners
--- End Message ---
--- Begin Message ---
Quoth James Nunnerley on 10/6/2004 8:03 AM...
Unable to load dynamic library './php_mysql.dll' - The specified module could
not be found.
You need libmysql.dll from the PHP distribution somewhere where PHP can
find it.
I've put php_mysql.dll in the /%SystemRoot%/system32 directory, which is how
Apache used to find it, but it still comes up with an error.
Any ideas?
You shouldn't need to put anything in system32; add your php directory
to your PATH, and it should then be able to find the correct
libmysql.dll. (Be sure that PHP appears before MySQL\bin in PATH or that
MySQL\bin isn't there at all; for some reason, PHP can't use MySQL's
libmysql.dll.)
Also, as a bit of an aside, I'm also being asked to make sure that this is
secure and safe to run - does anyone have any thoughts with regards to the
security of running PHP on IIS, and anything I should do to prevent future
security problems.
It sounds as if you're running PHP as an ISAPI module, which I've read
is less stable but more secure. I haven't had problems with the ISAPI
module, but my app where I use this setup is pretty low-traffic.
Hope this helps.
-Felipe Gasper
Cincinnati, OH
--
Quidquid latine scriptum sit altum viditur.
Si hoc legere scis, nimis eruditionis habes.
Easier web browsing: http://mozilla.org
--- End Message ---
--- Begin Message ---
I set my extension folder to 'D:\Service\PHP\ext' and the php_mysql.dll is
in the ext folder. I was getting an error saying "The specified module
could not be found." But after I copied the libmySQL.dll to the system32
folder, I got this error, "The specified procedure could not be found."
(Notice the difference of 'module' and 'procedure' in the two error
messages.) Why isn't it working?
--- End Message ---
--- Begin Message ---
I set my extension folder to 'D:\Service\PHP\ext' and the php_mysql.dll is
in the ext folder. I was getting an error saying "The specified module
could not be found." But after I copied the libmySQL.dll to the system32
folder, I got this error, "The specified procedure could not be found."
(Notice the difference of 'module' and 'procedure' in the two error
messages.) Why isn't it working?
--- End Message ---
--- Begin Message ---
I set my extension folder to 'D:\Service\PHP\ext' and the php_mysql.dll is
in the ext folder. I was getting an error saying "The specified module
could not be found." But after I copied the libmySQL.dll to the system32
folder, I got this error, "The specified procedure could not be found."
(Notice the difference of 'module' and 'procedure' in the two error
messages.) Why isn't it working?
--- End Message ---
--- Begin Message ---
I set my extension folder to 'D:\Service\PHP\ext' and the php_mysql.dll is
in the ext folder. I was getting an error saying "The specified module
could not be found." But after I copied the libmySQL.dll to the system32
folder, I got this error, "The specified procedure could not be found."
(Notice the difference of 'module' and 'procedure' in the two error
messages.) Why isn't it working? *sighs*
Thanks in advance.
--- End Message ---
--- Begin Message ---
PHPDiscuss - PHP Newsgroups and mailing lists wrote:
I set my extension folder to 'D:\Service\PHP\ext' and the php_mysql.dll is
in the ext folder. I was getting an error saying "The specified module
could not be found." But after I copied the libmySQL.dll to the system32
folder, I got this error, "The specified procedure could not be found."
(Notice the difference of 'module' and 'procedure' in the two error
messages.) Why isn't it working? *sighs*
Thanks in advance.
I copied php5ts.dll and libmysql.dll to my Apache2\bin folder, and
mod_php is working just fine. I have c:\php in my path and c:\php\ext as
my extensions folder. If you're using a different setup than mod_php,
the problem is likely your path. Does the folder where php.exe,
php5ts.dll and libmysql.dll come *before* your mysql\bin folder and your
system32 folder?
Hope that helps.
--- End Message ---
--- Begin Message ---
Does everyone know how to convert Nominal Number into string spelling in
PHP ?.
Like this :
Nominal Number : 567.123.560
And the spelling string/word have to be like this :
"Five Hundred Sixty Seven Million One Hundred Twenty Three Thousand Five
Hundred and Sixty"
Please help me..
--- End Message ---
