By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Is PHP/MySql the right tool for this project?

P: n/a
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.
From what I've read so far, php looks like it may be a good way to go

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.

Sep 5 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
we*******@charter.net wrote:
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.
From what I've read so far, php looks like it may be a good way to go

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 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
==================
Sep 5 '05 #2

P: n/a
Jerry Stuckle wrote:
we*******@charter.net wrote:
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 is one tool you can use for this project. Is it the right
one? Only you can say for sure.


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.
Sep 5 '05 #3

P: n/a
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

Sep 5 '05 #4

P: n/a
As Jerry noted, PHP/MySQL is a tool you could use. I could easily see
you do the same thing with ASP and continue to use the same Access
database. It depends a lot on where this web application will sit.

Sep 6 '05 #5

P: n/a
It will probably need to fit on a box running Solaris (Unix).

bill W

Sep 6 '05 #6

P: n/a
we*******@charter.net wrote:
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.
From what I've read so far, php looks like it may be a good way to go

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.


It really depends on the host server -- if you already run MySQL then it
might be worth the effort however it'd probably be easier to hook PHP up
to access (I've done it before) and code a little front end if you are
stuck on *nix -- if you are on Windows consider upping the database into
the MSDE or SQL Server and churning out some classic ASP-- the code
fragments in the VBA app will probably be cut and pasteable in many cases.

I'm torn - but if its a low volumn app a complete re-write will be a
headache that is hardly worth it.

James
Sep 7 '05 #7

P: n/a
Apache/PHP/MySQL is a bit of a pain to set up on Solaris. But I guess
you have your Sun gurus to take care of that.

My suggestion is to go with PHP 5 w/ SQLite. For a low volume site
you'll get better performance than a full-blown relational database.

Sep 7 '05 #8

P: n/a
In article <11**********************@o13g2000cwo.googlegroups .com>,
"we*******@charter.net" <we*******@charter.net> wrote:
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.
From what I've read so far, php looks like it may be a good way to go

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.


We're awfully biased towards php in this group - so the answer is a simple
"Yes" :)

I always like to keep my options open for future development, s while some data
might not directly require a SQL database, I like to put it there anyway, since
I often end up wanting to make it more advance in the future.

Plus, with SQL, you get the whole fetch/update/insert API built in. You don't
have to build own tools to lookup data in flatfiles.

--
Sandman[.net]
Sep 7 '05 #9

P: n/a
For short term, PHP has odbc database functions that can access the
Access dbs. I guess this would work if you can put the php on a Win
machine running IIS or Apache.

You can then think about moving to a new DB.

On 4 Sep 2005 19:14:41 -0700, "we*******@charter.net"
<we*******@charter.net> wrote:
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.


Sep 8 '05 #10

P: n/a
One extra note. If you can run this from a Win. machine, PHP/Apache
or IIS is the fastest way to get a small app up and running. However,
I would not stay in Access if you plan updates of the DB!

On 4 Sep 2005 19:14:41 -0700, "we*******@charter.net"
<we*******@charter.net> wrote:
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


Sep 8 '05 #11

P: n/a
Hello Bill,
Take a look at this product
(I am in the development team. You can make
any request of feature):
http://cam70.sta.uniroma1.it/TechnicalPreview/

Adriana
..NET Developer

Sep 9 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.