database programming

[cwdlmdd]

I am wanting to create a database program for my home based businnes. More so just to see what I need to do to create one and not because I really need it.

But I was hoping htat I could get everyone opinion on what to use and the best way to go about this with out using some already made.

My idea is to create this datbase in a web base format so that I could open it and work on it using any one of the computers that I have in the house right now.

I have already installed Apache, SQL 7.0 and I have used Frontpage, HTML and a limited amount of JavaScript and PHP for forms on a web site.I believe this can be done using PHP but I would like another opinion.

SO what do you think?

 

[raphink]

Do you really need to create a program?

Why not use MySQl as the database and PHPMyAdmin as the web-based administration interface ?

 

[cwdlmdd]

That is more or less what I was thinking doing but I just have not gotten around to reading about how to do it.

 

[peanutbutter12]

What kind of database are you looking to do? Most office programs are able to make databases to meet the needs of businesses.

 

[csheppard91]

I am wanting to create a database program for my home based businnes. More so just to see what I need to do to create one and not because I really need it.

But I was hoping htat I could get everyone opinion on what to use and the best way to go about this with out using some already made.

My idea is to create this datbase in a web base format so that I could open it and work on it using any one of the computers that I have in the house right now.

I have already installed Apache, SQL 7.0 and I have used Frontpage, HTML and a limited amount of JavaScript and PHP for forms on a web site.I believe this can be done using PHP but I would like another opinion.

SO what do you think?

You're definately on the right path, but this may be overkill for what you need. You must also note that one computer will have to act as the server and will need to be on whenever you want access to this page. If there's not too many simultaneous connections, then a simple access program would work, but a webservice would be more elegant and extendable. However, do you really need it and how would it work? Are you planning on just a bunch of textfields in a page that allows you to query and change the data? The simplest way would be to simply share the database.

Since it's a business you might as well just go ahead and create something. PHP+mySQL is your best option for a web service.

 

[rdale]

What kind of database are you looking to do?

That is a good question.

If answered, more/different options are available. cwdlmdd, are you just wanting to save in essence "text" files in a centralized location?