Loading invoices in PHP

zuperdude

Dear all,

As a part of a school project, I am creating a Website for a company using Navision 3.

I plan to let customers log in to a PHP Website and download invoices. PHP on linux has builtin ODBC, but not C/ODBC. I have a MySql db to "cache" data to.

How do I get started?

A solutions would be, according to the server admin to copy the db.fdb to a MSSQL server, or use a connector in PHP:
http://www.ez.no/solutions/solutions_and_software/web_connector_for_mbs_navision, but this will require a lot of coding on the Application Server part. Now he has told me that I could load the data directly through ODBC, so I am confused. :?

I am familiar with Delphi, and I have download a few components from mibuso. Perhaps I should create a desktop app that loads from the database and sends over to the mysql base?

I am not familiar with the database or C/ODBC. Does anyone have any idea that can help me further? How can I solve this in an easy way?

Waldo

Connecting to a SQL Server database doesn't seem a bad Idea in my eyes ... .

To install C/ODBC, you need a windows machine, and you're probably working on linux, no?

You could be using WAMP (Windows Apache MySQL PHP), but I don't think you want that.