PHP / MySql是否适合此项目？ [英] Is PHP/MySql the right tool for this project?

问题描述

我有一个我在MS Access 2002中编写过的应用程序。它是一个非常好的基本库存系统，用于跟踪有关我们的信息：
Unix（solaris是特定的）服务器。其他管理员可能希望很快使用它/ b $ b，并且通过WAN运行MS Access并不适合野餐。这是

建议我移植到php和MySql。没有使用

的经验，我想知道这是否是一个可行的解决方案。


数据库如果非常普通香草，即基本上是一个平面文件

虽然有一些表与外键有关的主表。 No

想要报告一些基本查询，例如显示所有系统

标记为运行软件Y的版本X的服务器事物的类型。有些

的表单背后有一些VBA代码可以做一些简单的事情，比如

更改文本的颜色以使其更加突出。这个数据/网页

只能在内部使用。

I have an application I have written in MS Access 2002. It is a very
basic inventory system for keeping track of information about our
Unix(solaris to be specific) servers. Other admins may want to use it
shortly and running MS Access over the WAN is no picnic. It was
suggested that I port to php and MySql. Having no experience with
either, I''m wondering if this is a viable solution.

The database if very "plain vanilla", i.e., bascially a flat file
although a few tables with foreign keys relating to the main table. No
fancy reporting just a few basic queries such as "show all systems
marked as servers running version X of software Y" type of thing. Some
of the forms have some VBA code behind them that do simple things like
change the color of the text to make it stand-out. This data/web-page
would only be used internally.

从我到目前为止所读到的内容，php看起来可能是个好消息方式去

From what I''ve read so far, php looks like it may be a good way to go

但我不确定。大家都说什么？


任何建议，评论和关注点都会受到欢迎，以及

指向可能正在做类似事情的网站的指针。 />

比尔W.

but I''m not sure. What say you all?

Any suggestions, comments, concerns would be most welcome as well as
pointers to sites that might be doing something similar.

Bill W.

推荐答案

我们******* @ charter.net 写道：

我有一个我在MS Access 2002中编写的应用程序。它是一个非常基本的库存系统，用于跟踪我们的Unix（solaris是特定的）服务器的信息。其他管理员可能希望很快使用它，并且通过WAN运行MS Access并不适合野餐。这是建议我移植到php和MySql。没有任何经验，我想知道这是否是一个可行的解决方案。

数据库，如果非常普通的香草，即基本上是一个平面文件
虽然有几张表与外键有关的主表。没有
花哨报告一些基本查询，例如显示所有系统
标记为运行软件Y的版本X的服务器。事物的类型。其中一些表单背后有一些VBA代码可以做一些简单的事情，例如改变文本的颜色以使其脱颖而出。这个数据/网页
只能在内部使用。

I have an application I have written in MS Access 2002. It is a very
basic inventory system for keeping track of information about our
Unix(solaris to be specific) servers. Other admins may want to use it
shortly and running MS Access over the WAN is no picnic. It was
suggested that I port to php and MySql. Having no experience with
either, I''m wondering if this is a viable solution.

The database if very "plain vanilla", i.e., bascially a flat file
although a few tables with foreign keys relating to the main table. No
fancy reporting just a few basic queries such as "show all systems
marked as servers running version X of software Y" type of thing. Some
of the forms have some VBA code behind them that do simple things like
change the color of the text to make it stand-out. This data/web-page
would only be used internally.

从我到目前为止所读到的内容来看，php看起来可能是个不错的选择

From what I''ve read so far, php looks like it may be a good way to go

但我不确定。大家都说什么？

任何建议，评论，关注点都会受到欢迎，以及指向可能做类似事情的网站的指示。

Bill W 。

but I''m not sure. What say you all?

Any suggestions, comments, concerns would be most welcome as well as
pointers to sites that might be doing something similar.

Bill W.

Bill，


PHP / MySQL是一个可用于此项目的工具。这是正确的

一个吗？只有你可以肯定地说。


如果你有MySQL和PHP经验，那么我会说这可能是一个很好的工具。但是，PHP与MS Access有很大的不同，我认为除了表定义之外，你会发现不会有太多的结果。


如果你有其他经验，即.NET或.ASP，我可能会建议你

也可以通过数据库的SQL Server查看这些可能性。


但是如果你在Access之外没有任何编程经验，那么大多数工具可能与其他工具一样好（或差）。

-

==================

删除x来自我的电子邮件地址

Jerry Stuckle

JDS计算机培训公司
js ******* @ attglobal.net

==================

Bill,

PHP/MySQL is one tool you can use for this project. Is it the right
one? Only you can say for sure.

If you had MySQL and PHP experience, then I would say it probably is a
great tool. However, PHP is much different than MS Access and I think
you''ll find not much will carry over except for the table definitions.

If you have other experience, i.e. .NET or .ASP, I might recommend you
also look into those as possibilities, with a SQL Server for the database.

But if you don''t have any programming experience outside of Access,
probably most tools are as good (or bad) as the rest.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jerry Stuckle写道：

Jerry Stuckle wrote:

我们*** **** @ charter.net 写道：

我有一个我在MS Access 2002中编写的应用程序。它是一个非常基本的库存系统，用于跟踪信息关于我们的
Unix（solaris是特定的）服务器。其他管理员可能想要使用它很快就会在WAN上运行MS Access并不是野餐。

I have an application I have written in MS Access 2002. It is a very
basic inventory system for keeping track of information about our
Unix(solaris to be specific) servers. Other admins may want to use it
shortly and running MS Access over the WAN is no picnic.

< snip>
PHP / MySQL是一个可用于此的工具项目。它是正确的吗？只有您可以肯定地说。

<snip>
PHP/MySQL is one tool you can use for this project. Is it the right
one? Only you can say for sure.

最快的解决方案是使用正确的DBMS，通过

ODBC附加表格，如果有任何形式/ reports对连接进行操作，然后创建设置为

passthru SQL的查询，然后使用MS-Access（在文件共享上）作为前端。虽然我像基于网络的东西一样使用MySQL，但是PostgreSQL可能是这种设置的更好的后端。


HTH


C.

The quickest solution would be to use a proper DBMS, attaching tables via
ODBC, if any forms/reports operates on joins then create queries set as
passthru SQL then use MS-Access (on a file share) as a front end. While I
like MySQL for web-based stuff, PostgreSQL might be a better backend of
this kind of setup.

HTH

C.

我想我应该在原帖中说我确实有
$ b各种语言的$ b编程经验和

脚本语言.....不是PHP。在Sybase和MS-Access中也有丰富的经验

。


我不是结婚。为此我想到了PHP / MySql。这只是一个

推荐。


感谢您的反馈到目前为止


Bill

I guess I should have said in the original post that I do have
programming experience in a variety of languages and
scripting-languages.....just not PHP. Also have extensive experience
in Sybase as well as in MS-Access.

I''m not "married" to the idea of PHP/MySql for this. It was just one
recommendation.

Thanks for the feedback thus far

Bill

这篇关于PHP / MySql是否适合此项目？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！