Using a Database

I want to set up a website that'll allow colleagues to login and add
information which can be subsequently viewed by other users. I was thinking of
using a database to store the information - allowing people to add or view as
necessary.

I have a copy of MS Access, so I can set that up as my database. My ISP allows
for ASP and PHP scripting (which I think I need to shunt the data to and fro),
but I don't know how to use either of them.

My question is....which is the best way forward, ASP or PHP as I understand it
they do the same thing ? OR is there another way. Also, how does mySQL fit in -
is it another database like Access ?

PHP and MySQL work great together and cost nada. DW supports the combination pretty well and most ISP's support.

How do I get a copy of MySQL.

I went onto mysql.com and couldn't see where to get it OR is it supplied as part of the ISP package...?

Malcolm N_ wrote:

On Thu, 3 Jan 2008 11:59:59 +0000 (UTC), "TheVille2"
webforumsuser (AT) macromedia (DOT) com> wrote:

How do I get a copy of MySQL.

I went onto mysql.com and couldn't see where to get it OR is it supplied as part of the ISP package...?


http://dev.mysql.com/downloads/mysql/5.0.html#downloads

Note that MySQL isn't like Access, its a server technology that your
host will have to offer you as a service. You can install it locally to
get to grips with it, but its not like Access, its not got a nice front
end program to configure it, there will be a learning curve thats fairly
steep if you do not understand the basics of an SQL server.

Steve

Start by reading the dev notes on the Adobe site -

http://www.adobe.com/devnet/dreamwea...plication.html

It will take you a while....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"TheVille2" <webforumsuser (AT) macromedia (DOT) com> wrote

I want to set up a website that'll allow colleagues to login and add
information which can be subsequently viewed by other users. I was
thinking of
using a database to store the information - allowing people to add or view
as
necessary.

I have a copy of MS Access, so I can set that up as my database. My ISP
allows
for ASP and PHP scripting (which I think I need to shunt the data to and
fro),
but I don't know how to use either of them.

My question is....which is the best way forward, ASP or PHP as I
understand it
they do the same thing ? OR is there another way. Also, how does mySQL fit
in -
is it another database like Access ?

So the answer (by default) would seem to be PHP and MySQL ?

It sounds like you would like to create a blog. Once suggestion is to save
yourself the head-aches and go to www.svalenciainternational.com, my hositng
site and click on the bronze button. for about 4.99 to 9.00 per month you can
set up a website blog with 24/7 support. Later in the year there will be other
blog service. Just in case you just want to get the job done and have support.
I am new to the site so I hope I am not breaking protocol here.

Access is a bit of dead product. Why pay for access when MySQL is free.

davidbarrackphoto wrote:

Access is a bit of dead product. Why pay for access when MySQL is free.

I completely agree, Access is a good tool for learning stuff, as you
have a nice recognizable interface to help you create your database and
manually populate data, but when it comes to actually using a database
on a remote server, MySQL is great, but it is different, and you will
need to learn how to use it as its not like Access.

If your host has MSSQL, and is configured correctly, you can use Access
as a management tool, and control your MSSQL database. I used to use it
almost exclusively, especially when you can upsize Access databases to
MSSQL.

Steve

you can find bundled software packages for both Linux and windows servers

I assume you are on Windows
http://www.wampserver.com/en/

I feel php is the better choice along with PEAR db and/or MySQL. Most host
have phpmyadmin my SQL interface that you can use.

But it seems all you need to do is for your project is modify a forum.

I find http://fudforum.org/download.php to one of the better php based forum
for easy upgrades and it endorsed by php.net. But there are alternatives out
their that you may find has a better 'feel', or functionality towards what you
are looking for.