PHP 与共享 Linux 主机上的 MS Access 2007
基本上,我在一家餐饮服务公司工作,该公司有一个菜单数据库,我们每周在多个位置使用该数据库,存储在 Microsoft Access 2007 .accdb 文件中。我正在尝试在共享主机上开发一个 PHP 应用程序,以便可以上传和查询 .accdb 文件,以便根据数据库生成和存储本周的 HTML 菜单。
价值百万美元的问题:如何在共享主机上的 PHP 中与此 .accdb 文件表单交互?我想我一开始就假设 Zend 或 Pear 会有一个适合我的驱动程序,但我在找到任何实质性内容时遇到了一些麻烦,特别是对于共享托管。
谢谢!
Basically I work for a dining services company that has a menu database that we use for each week at multiple locations stored in a Microsoft Access 2007 .accdb file. I'm trying to develop a PHP application on shared hosting so that the .accdb file can be uploaded and queried as to generate and store HTML menus for the week based on the database.
Million dollar question: how can I interact with this .accdb file form within PHP on shared hosting? I guess I just kind of assumed Zend or Pear would have a driver for me when I started off, but I'm having some trouble finding anything of substance, especially for shared hosting.
Thanks!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
看看这个问题:
Linux 托管上使用 MS Access 进行 PHP 数据库连接< /a>
大多数人(包括我:))都建议将 Access 数据库迁移到 MySQL(或 Postgres),并将其作为网站上的实时数据库运行。如果您办公室中有依赖 Access 的人员/流程,您可以通过将 Access 连接到实时 MySQL 数据库来使用 Access 作为前端 通过 ODBC。
Take a look at this question:
database connection in php with MS Access on linux hosting
Most people (including me :) ) are recommending migrating the Access database to MySQL (or Postgres), and running that as the live database on the website. If there are people/processes in your office that rely on Access, you can use Access as a frontend by connecting it to the live MySQL database over ODBC.
这可能会引起兴趣:http:// /bryanmills.net/archives/2003/11/microsoft-access-database-using-linux-and-php/
通过 Linux 托管上的 php 中的数据库连接与 MS Access
This may be of interest: http://bryanmills.net/archives/2003/11/microsoft-access-database-using-linux-and-php/
via database connection in php with MS Access on linux hosting