|
|
Posted by Norman Peelman on 04/26/06 13:23
"McHenry" <mchenry@mchenry.com> wrote in message
news:444e15ed$0$30750$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
>
> "Gernot Frisch" <Me@Privacy.net> wrote in message
> news:4b6i7sFuq35gU1@individual.net...
> >
> > "McHenry" <mchenry@mchenry.com> schrieb im Newsbeitrag
> > news:444e06f3$0$30747$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> >>
> >> "Gernot Frisch" <Me@Privacy.net> wrote in message
> >> news:4b6d08F107p0fU1@individual.net...
> >>>
> >>> "McHenry" <mchenry@mchenry.com> schrieb im Newsbeitrag
> >>> news:444df6ab$0$30732$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
> >>>>I am familiar with asp and have done quite some coding using VBA etc.
> >>>>
> >>>> Presently I have a routine in asp that manipulates MS Excel objects
> >>>> etc, can I control Excel objects in php too ?
> >>>
> >>> Can you tounge-kiss a dog?
> >>>
> >>> Sure you can, but why would you?
> >>>
> >>
> >> I have an Excel sheet that queries 2000 web pages daily and stores the
> >> data in a db...
> >>
> >> Can you suggest another way to reliably query these 1300 pages and
> >> extract the data without using the Excel Web Query function ?
> >
> > querying web pages in php is possible and easy. Storing in a database
is,
> > too. You can propably almost copy/paste that part. php has very usefull
> > functions for string parsing, so this part is much easier, however you
> > have to re-write it.
> >
> > You can use Excel+VBA - but your server must support it. But - what is
the
> > use of php then?
>
> So php can't control Excel objects like VBA can ?
>
Yes, it can... along with alot of other software suppporting COM objects.
I've done it myself (just goofing around) but am no expert. You would need
to do some googling to find the answers you need. But, it would be alot
easier using PHP alone as PHP can:
1) read an entire web site (text/html) into a variable
a) $webpage = fopen('http://your.url.here','r');
2) parse that variable and store it directly into MySQL
a) use 'regex' to extract the data
b) write/update MySQL
3) without going through Excel or ADO
Either way you decide to do it, you've got some investigating to do... a
quick fix for you right now may be to simply write a small PHP script to
copy the data from your original db to MySQL (after your original process)
until you get things straightened out.
Norm
> >> p.s. regarding the dog comment... how do you know it can be done ?
> >
> > I can't think of any physical problem with that. Yuck!
> >
> >
> >
> >
>
>
Navigation:
[Reply to this message]
|