VB PHP MySQLQuestion

[tamathaltarak]

Hi,

I am not sure how to do this so I am looing for some pointers please.

I have an online MySQL database (linux server with no access via myodbc or ado) and I want to read data from this and import into a local access database.

I am using vb as the client application with ado connections to the local access database.

I need a way to get data from the MySQL database and import / delete / update into my local access database. I also need to upload data into the MySQL database.

Is it possible to do this, without direct access to the MySQL server.

My thought was to do the following.
1) create php files on the server to load a page containing the data I want to download. (basically create a csv file)
2) use the vb application to navigate to the php page (passing the variables in)
3) somehow read the php csv page into an array
4) do something with the array (update insert etc...)

Has anyone else ever done this before or is there an easier way ?

Any info will be much appreciated

Thanks

Tamath Altarak

[techgnome]

If you get a copy of PHPMyAdmin
It has a way to export query results to text files. The text files are sent directly to the local PC (I think), so the app wouldn't need to navigate to the web at all.
This is real only good if it's just a one time thing. If it is something that needs tpo be done on a regular basis, you best bet may be to create a web page that displays the results in a table format, then use the INet control to OpenURL, from which you can read the HTML page and parse out the data from the table.

Not sure if any of this helps.

[tamathaltarak]

Thanks for the reply,

PHPMyAdmin is a none starter as the data required is more than a one off.

Your idea of inet control and parsing is confirming my idea of receiving csv type data.

Have you ever done anything similar to this before ?

Thanks

Tamath Altarak

[techgnome]

Nope. Can't say I have. Sorry.

[JoshT]

Does PHP have a library to turn a DB Query into XML? If so, you could use MSXML in your VB app to request the XML webpage and parse it into Access.

[tamathaltarak]

Hi,

I'm not sure if it has a xml routine built into php. I can have a look and check.

Thanks

[techgnome]

PHP uses "expat" -- but unfortunatly it isn't part of the basic core PHP functionality. It's an add-on component that needs to be compiled into the version PHP running on the server.
More on XML and PHP can be found here: http://www.php.net/manual/en/ref.xml.php

[tamathaltarak]

thanks for the info.

I'll have to check if my host has this addon or can add it on.

Thanks again

Tamath Altarak