Hi,

Can anybody please help me or give me any idea about interfacing PHP/MYSQL to any existing Database like dbase III...However is it possible to do so? Otherwise is it possible to retrieve the mysql data in the existing form...?

Thank You..

mekh

__________________
MD Gurung

Well, PHP has a dbase extension that allows you to access dbase databases. You could write a little script that extracts all the records from DBF and insert them into MySQL.

It would probably be easier if you used a conversion tool.

A simple google search (import dbase dbf into mysql) yields many results. Among them:
  http://www.sqldbu.com/eng/sections/t...sqlimport.html


Take care,

Nik
http://www.bigaction.org/

Thank you Nik,

Actually I want is interfacing my PHP/MYSQL website with the TELEMAGIC that is running since last 5 years...Can you please suggest me what can I do?

Thanx
Mekh



mekh dev gurung

Telemagic should allow you to export data. I don't know what format it exports it in, but if it's text based, you should be able to write a fairly simple parser in PHP that'll read that file and import the data into MySQL for you.

Of course, it'd be much easier if you can get telemagic to export it's data in SQL format...

What does the telemagic documentation say?


Take care,

Nik
http://www.bigaction.org/

Thanx NIK,

Actually I mean extracting the DATA from PHP/MYSQL to TELEMAGIC which is using dbIII... However I don't know how is dbase working there...
Is there any idea like exporting data inside any Normal Form...?

Take Care

mekh

mekh dev gurung

Well, you should also be able to do a data import into telemagic. It probably recognizes standard SQL and/or CSV (comma-separated values). You can easily write a script (or download one) that dumps MySQL contents into these formats. For example, PhpMyAdmin supports several different dump modes.

Again, I've never used telemagic so I'm pretty much useless to you -- read the manual for Telemagic, specifically the areas that deal with importing data. It might just be that it has an ODBC driver that can connect to MySQL directly.


Take care,

Nik
http://www.bigaction.org/

Thanx NIK,

I will try my best and do inform you whenever I got through this problem...Do keep in touch

Mekh