php-windows Digest 22 May 2004 16:06:03 -0000 Issue 2257
Topics (messages 23792 through 23796):
Re: updating from xls -> [filter] -> mysql
23792 by: Jesper Palmqvist [Talarforum i Skandinavien AB]
23793 by: Sven Schnitzke
PHP and FLASH Remoting - can it be done?
23794 by: jcoliton.comcast.net
23795 by: Frank M. Kromann
How do you filter out certain IP values?
23796 by: Daniel Anderson
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 ---
I have been using PHP with COM
On my Win2000 platform running PHP as a module on Apache2 the excel
application doesn't end after the script ends
The script ends:
$exapp->Quit();
unset($exapp);
?>
What could be the problem?
/Jesper
-----Ursprungligt meddelande-----
Fr�n: Sven Schnitzke [mailto:[EMAIL PROTECTED]
Skickat: den 21 maj 2004 14:14
Till: '[PHP-WIN]'
�mne: AW: [PHP-WIN] updating from xls -> [filter] -> mysql
Hi George,
are you familiar with COM? If so, consider:
// select range to $r , then do
if($r->NumberFormat()="a format") { ... }
where "a format" can be "Standard" or something like
"#,##0.00; -###0.00" or so as used in the "Format - Cells" dialog of
Excel.
With Excel 8 there seems to be a glitch as it returns localized colour
names and does not accept english ones (At least my German version
behaves this way; didn't scrutinize too deeply though).
If you are interested I will send you a basic PHP COM script doing EXCEL
I/O to start from.
HTH
--
Sven Schnitzke
> -----Urspr�ngliche Nachricht-----
> Von: George Pitcher [SMTP:[EMAIL PROTECTED]
> Gesendet am: Freitag, 21. Mai 2004 12:08
> An: [EMAIL PROTECTED]
> Betreff: [PHP-WIN] updating from xls -> [filter] -> mysql
>
> Hi,
>
> I'm thinking ahead to something I'll need to tackle in the future.
>
> My current system is Filemaker based and I can import straight from
> Excel spreadsheets - but with no checking available. Now that I'm
> re-writing into php/mysql(pear:dB)/smarty, If I can, I'd like the user
> to be able to select the file (I can do that bit), check that the
> column positions match a predefined format (?), and then update
> records in my db table.
>
> Does this look doable? Any hints on how? I don't want to use ODBC as
> the filename will be constantly changing so there'll be no dsn set up.
>
> George in Oxford
>
>
> --
> 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
--- End Message ---
--- Begin Message ---
Getting rid of the Excel instance indeed is the tricky part of it:
With Excel 8 / PHP4.3.2 the problem lies in handling of the typelib(s):
// You might want to load the appropriate type library if you have to use
// excel constants on the interface. Do that by setting INI value
// com.autoregister_typelib = true
// As of PHP-4.3.2:
// ini_set('com.autoregister_typelib', true); does NOT work !!
// if you use register_typelib() you will get orphaned excel instances hanging around!
... but others had different experiences ...
HTH
--
Sven
> -----Urspr�ngliche Nachricht-----
> Von: Jesper Palmqvist [Talarforum i Skandinavien AB] [SMTP:[EMAIL PROTECTED]
> Gesendet am: Freitag, 21. Mai 2004 16:15
> An: [EMAIL PROTECTED]
> Betreff: SV: [PHP-WIN] updating from xls -> [filter] -> mysql
>
> I have been using PHP with COM
>
> On my Win2000 platform running PHP as a module on Apache2 the excel
> application doesn't end after the script ends
>
> The script ends:
>
> $exapp->Quit();
> unset($exapp);
> ?>
>
> What could be the problem?
>
> /Jesper
>
>
> -----Ursprungligt meddelande-----
> Fr�n: Sven Schnitzke [mailto:[EMAIL PROTECTED]
> Skickat: den 21 maj 2004 14:14
> Till: '[PHP-WIN]'
> �mne: AW: [PHP-WIN] updating from xls -> [filter] -> mysql
>
>
> Hi George,
> are you familiar with COM? If so, consider:
>
> // select range to $r , then do
> if($r->NumberFormat()="a format") { ... }
>
> where "a format" can be "Standard" or something like
> "#,##0.00; -###0.00" or so as used in the "Format - Cells" dialog of
> Excel.
>
> With Excel 8 there seems to be a glitch as it returns localized colour
> names and does not accept english ones (At least my German version
> behaves this way; didn't scrutinize too deeply though).
>
> If you are interested I will send you a basic PHP COM script doing EXCEL
> I/O to start from.
>
> HTH
> --
> Sven Schnitzke
>
>
> > -----Urspr�ngliche Nachricht-----
> > Von: George Pitcher [SMTP:[EMAIL PROTECTED]
> > Gesendet am: Freitag, 21. Mai 2004 12:08
> > An: [EMAIL PROTECTED]
> > Betreff: [PHP-WIN] updating from xls -> [filter] -> mysql
> >
> > Hi,
> >
> > I'm thinking ahead to something I'll need to tackle in the future.
> >
> > My current system is Filemaker based and I can import straight from
> > Excel spreadsheets - but with no checking available. Now that I'm
> > re-writing into php/mysql(pear:dB)/smarty, If I can, I'd like the user
>
> > to be able to select the file (I can do that bit), check that the
> > column positions match a predefined format (?), and then update
> > records in my db table.
> >
> > Does this look doable? Any hints on how? I don't want to use ODBC as
> > the filename will be constantly changing so there'll be no dsn set up.
> >
> > George in Oxford
> >
> >
> > --
> > 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
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
I've just finished a course in PHP, so excuse my ignorance since it was a rather basic
course. All of our class examples worked with static HTML pages as either input or
output. I hope to use FLASH and PHP to create an application as part of my thesis, but
can only find one book on the subject (and it uses FLASH 5, not MX). Should I abandon
PHP right from the front, or am I not finding references to using FLASH (I think the
connection protocal is called FLASH Remoting) and PHP. Can you suggest where I might
look for info on this stuff?
I really like PHP (both for the programming language itself, and the cost of web
hosting) as compared to Cold Fusion - do I have to stick to JUST Macromedia products?
Thanks in advance.
John Coliton
--- End Message ---
--- Begin Message ---
Hi John,
Take a look at this site http://www16.brinkster.com/gazb/ming/index.html
- Frank
> I've just finished a course in PHP, so excuse my ignorance since it was
a rather basic course. All of our class examples worked with static HTML
pages as either input or output. I hope to use FLASH and PHP to create an
application as part of my thesis, but can only find one book on the
subject (and it uses FLASH 5, not MX). Should I abandon PHP right from the
front, or am I not finding references to using FLASH (I think the
connection protocal is called FLASH Remoting) and PHP. Can you suggest
where I might look for info on this stuff?
>
> I really like PHP (both for the programming language itself, and the
cost of web hosting) as compared to Cold Fusion - do I have to stick to
JUST Macromedia products?
>
> Thanks in advance.
>
> John Coliton
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi, can anyone tell me how to filter out some IP values?
For example: 80.2.*.30
Many thanks,
Dan
--- End Message ---
