本地Access数据库共享PHP / MySql主机导出 [英] Local Access database to shared PHP/MySql hosting export

问题描述

我的客户端在其本地计算机上有一个MS Access数据库应用程序。在更改设计方面，我有完全访问权限。


我在共享主机上有一个简单的PHP / MySql应用程序，所以没有直接

访问数据库服务器。


我想给她设施将信息输出到她当地的

访问共享PHP / MySql站点的应用程序。从Access应用程序中的一个命令按钮（或

类似）。


这可能是完全覆盖。也就是说共享网站上的所有

信息都将被当地

机器覆盖。


我我假设我必须向某个PHP页面发出HTTP请求，然后

将运行SQL删除所有记录，然后附加所有新的

。


这是正确的方法吗？我不想花费数周的时间发现

这在某种程度上存在根本性的缺陷。客户端有ADSL连接。


你的，Mike MacSween

My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.

I''ve got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.

I''d like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.

It would be probably be a complete overwrite. That is to say all the
information on the shared site would be overwritten with that from the local
machine.

I''m assuming that I''d have to make an HTTP request to some PHP page which
would then run the SQL to delete all the records, then append all the new
ones.

Is this the right approach? I don''t want to spend weeks finding out that
this is fundamentally flawed in some way. The client has an ADSL connection.

Yours, Mike MacSween

推荐答案

文章< 42 * **********************@news.aaisp.net.uk> ;,

" Mike MacSween" < MI *************************** @ btinternet.com>写道：

In article <42***********************@news.aaisp.net.uk>,
"Mike MacSween" <mi***************************@btinternet.com> wrote:

我的客户端在她的本地计算机上有一个MS Access数据库应用程序。在更改设计方面我完全可以访问它。

我在共享主机上有一个简单的PHP / MySql应用程序，因此无法直接访问数据库服务器。

我想让她有机会将她当地的访问应用程序中的信息导出到共享的PHP / MySql站点。从Access应用程序中的一个命令按钮（或类似的）。

这可能是一个完全覆盖。也就是说共享网站上的所有信息都会被当地
机器上的信息覆盖。

我假设我必须要做一个PHP页面的HTTP请求，然后运行SQL删除所有记录，然后附加所有新的

这是正确的方法吗？我不想花费数周的时间发现它在某种程度上存在根本性的缺陷。客户端有ADSL连接。

你的，Mike MacSween

My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.

I''ve got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.

I''d like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.

It would be probably be a complete overwrite. That is to say all the
information on the shared site would be overwritten with that from the local
machine.

I''m assuming that I''d have to make an HTTP request to some PHP page which
would then run the SQL to delete all the records, then append all the new
ones.

Is this the right approach? I don''t want to spend weeks finding out that
this is fundamentally flawed in some way. The client has an ADSL connection.

Yours, Mike MacSween

你必须编写一个生成访问导入的php脚本文件。

我不熟悉Access，所以我不能再对如何，

做出评论，但我确定有访问那里的书籍，告诉你如何b $ b做文件导入。您所要做的就是相应地在perl或php中创建

MySQL数据库的输出，并将其输出为Access

导出文档。

为什么尝试这个是获取客户端的数据库并导出它。

以类似的格式创建输出。


-

DeeDee，不要按那个按钮！迪迪！没有！迪...

You''d have to write a php script that generates a access import file.
I''m not that familiar with Access, so I can''t comment further on "how",
but I''m sure there are Access books out there that will tell you how to
do "file import". All you have to do is create the output from your
MySQL database in perl or php accordingly and output it as an Access
export document.

One why to try this is to take the client''s database and export it.
Create your output in a similar format.

--
DeeDee, don''t press that button! DeeDee! NO! Dee...

谢谢。我想你可能误会了。我想从

Access数据库和INTO MySQL数据库中获取数据。


" Michael Vilain" < 6 **** @ spamcop.net>在消息中写道

news：vi ************************** @ comcast.dca.giga news.com。 ..

Thanks. I think you may have misunderstood. I want to get data FROM the
Access database and INTO the MySQL database.

"Michael Vilain" <vi****@spamcop.net> wrote in message
news:vi**************************@comcast.dca.giga news.com...

在文章< 42 *********************** @ news.aaisp.net.uk>中，
Mike MacSween < MI *************************** @ btinternet.com>写道：

In article <42***********************@news.aaisp.net.uk>,
"Mike MacSween" <mi***************************@btinternet.com> wrote:

我的客户端在她的本地计算机上有一个MS Access数据库应用程序。我在改变设计方面完全可以访问它。

我在共享主机上有一个简单的PHP / MySql应用程序，所以没有直接
访问数据库服务器。

我想让她有机会将她当地的访问应用程序中的信息导出到共享的PHP / MySql站点。从Access应用程序中的一个命令按钮
（或类似的）。

这可能是一个完整的覆盖。也就是说共享网站上的所有信息都会被
本地机器覆盖。

我假设我'' d必须向某个PHP页面发出HTTP请求，然后运行SQL删除所有记录，然后附加所有新的

这是正确的进场？我不想花费数周的时间发现它在某种程度上存在根本性的缺陷。客户端有ADSL
连接。

你的，Mike MacSween

My client has an MS Access database application on her local machine. I
have
full access to that in terms of changing the design.

I''ve got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.

I''d like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button
(or
similar) in the Access application.

It would be probably be a complete overwrite. That is to say all the
information on the shared site would be overwritten with that from the
local
machine.

I''m assuming that I''d have to make an HTTP request to some PHP page which
would then run the SQL to delete all the records, then append all the new
ones.

Is this the right approach? I don''t want to spend weeks finding out that
this is fundamentally flawed in some way. The client has an ADSL
connection.

Yours, Mike MacSween

你必须编写一个生成访问导入的php脚本文件。
我对Access并不熟悉，所以我不能对如何进行进一步评论，
但是我确定那里有Access书会告诉你如何
做文件导入。您所要做的就是相应地在perl或php中创建来自您的MySQL数据库的输出，并将其作为Access
导出文档输出。

为什么尝试这个是为了拿走客户的数据库并导出它。
以类似的格式创建输出。

-
DeeDee，不要按下那个按钮！迪迪！没有！ Dee ......

You''d have to write a php script that generates a access import file.
I''m not that familiar with Access, so I can''t comment further on "how",
but I''m sure there are Access books out there that will tell you how to
do "file import". All you have to do is create the output from your
MySQL database in perl or php accordingly and output it as an Access
export document.

One why to try this is to take the client''s database and export it.
Create your output in a similar format.

--
DeeDee, don''t press that button! DeeDee! NO! Dee...

我注意到Message-ID：< 42 *************来自Mike MacSween的**********@news.aaisp.net.uk>

包含以下内容：

I noticed that Message-ID: <42***********************@news.aaisp.net.uk>
from Mike MacSween contained the following:

谢谢。我想你可能误会了。我想从
Access数据库和INTO到MySQL数据库中获取数据。

Thanks. I think you may have misunderstood. I want to get data FROM the
Access database and INTO the MySQL database.

过去我这样做的方法是导出访问数据库

然后像这样更新MySql数据库：


＃连接数据库

mysql_connect（

The way I have done this in the past is to export the access database
then update the MySql database like so:

# Connect to the database
mysql_connect(

这篇关于本地Access数据库共享PHP / MySql主机导出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！