通过odbc用php连接到quickbooks数据库?

我们正在通过网络表单从用户那里收集信用申请数据.

[edit]
We're collecting credit application data from users on a web form.

我还没有将我的Web表单直接绑定到QB中.

I have not tied my web form directly into QB.

我不知道此数据收集的QB表结构是什么-也不知道如何向用户显示它，因为我从未真正直接使用过QB.但是我办公室里的其他人也可以.

I have no idea what the QB table structure is for this collection of data - nor of how it displays it to the user because I've never actually worked directly with QB. Others in my office do however.

对于开放源代码/免费选项的任何信息，我仍然会感激不尽.

I would still appreciate any information about open source / free options.

我将通过删除第一个所需选项来简化问题.

I'll simplify the problem by removing the first desired option.

让我们谈谈将平面文件导入Quickbooks.

Let's just talk about importing a flat file into quickbooks.

我没有可以玩的快速书的副本，因此我不知道快速书本身具有哪些选项，但是我在网上看到一些有关QB希望导入.ini文件的消息. (尚不知道它期望的格式，但是稍后我会解决)

I don't have a copy of quickbooks that I can play with, so I have no idea what options exist that are native to quickbooks but I see some chatter on the web about QB expecting an .ini file for imports. (don't know the format that it expects yet, but I'll get that worked out later)

如果您设法从mySQL中将平面文件导入到快速手册中，或者知道提供洞察力的链接，请分享您的故事(我现在找不到很多).
[结束编辑]

Please share your story if you have managed to import a flat file from mySQL into quickbooks or know of links that offer insight (I'm not finding much right now).
[end edit]

我意识到这种情况可能并不常见，但是我需要通过以下两种方式之一连接到现有的quickbooks数据库.

I realize that this scenario is probably uncommon, but I need to connect to an existing quickbooks database in one of two ways.

1)直接从我们网站上运行的php脚本中-直接将用户提供的数据从Web插入到快速手册中.

1) either directly from a php script running on our web site -- insert user supplied data directly from web to quickbooks.

或

2)将用户数据直接放入mySQL数据库中，然后将数据从mySQL导出到快速簿中.

2) put user's data directly into mySQL database and later export data from mySQL to quickbooks.

如果第一种选择可行，那么您对建立与quickbooks数据库的odbc连接的想法将不胜感激.

If the first option is viable, I would appreciate your thoughts on establishing an odbc connection to the quickbooks database.

我可以用类似的方法解决这个问题吗?

can I go about it with something like:

try {
  $conn = @odbc_connect("DSNName", "", "", "SQL_CUR_USE_ODBC");
  // un and pw parameters are passed as empty strings since the DSN 
  // has knowledge of the password already.
  // 4th parameter is optional

  $exec = @odbc_exec($conn, $insert) or die ("exec error");
  echo "success!";
}
catch (Exception $e) {
  echo $e->getMessage();
} // end try catch