NYCPHP Meetup

[Alberto dos Santos]

On 04/10/05, David Mintz <dmintz at davidmintz.org> wrote:
>
> On Tue, 4 Oct 2005, Aaron Fischer wrote:
>
> > I have a manual process that I would like to make happen automatically
> > (on a scheduled basis).
> >
>
> You should be able to create an ODBC data source, then access it
> programmatically -- e.g., with the PHP ODBC API
> (http://us3.php.net/manual/en/ref.uodbc.php)
>
> With your data in hand, it seems you can either
>
> (1) connect to your hosts MySQL database directly across the network from
> your machine and run the insert queries, or, if they don't let you do
> that,
>
> (2) do your own export-as-text (e.g., to tab-delimited), then upload it
> via POST (cURL might be helpful) to another PHP script on your server that
> accepts the upload and knows what to do with it -- break it back down and
> run the queries with it. You will no doubt want to add user authentication
> to the mix and possibly SSL.
>
> There's probably a simpler/better solution about to be posted any second.
> (-:
>
>
> ---
> David Mintz
> http://davidmintz.org/


I second the opinion that the simplest is to interconnect both databases
with php.

Another solution I had to implement once was to have an asp dump an XML,
using scheduled tasks on Win2K, to a certain network folder, and have a php
get it using getElementByID and dump it to MySQL.
It worked fine, though I had to get someone to do me the asp, hehe.

--
Alberto dos Santos
Consultor em TI
IT Consultant

http://www.yournway.com
A internet à sua maneira.
The Internet your own way.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20051004/0db495af/attachment.html>