Hello,
I have a problem.
This weekend i am at a LAN, organised by my clan and we are wishing to have an intranet sign up and food order. But thats where my plan gets stuck!

We have a brand new server. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> How can i do this??


I have dreamweaver MX 2004 and we would like to use an acess database, for our database.

How do I:
1) Set up sever (mySql?)
2) How to add the database to the server
3) How to connect dreamweaver with the database
4) How to make a form that will send information to the server


Please Help!!!!!!


Thanks

Tom

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>I have dreamweaver MX 2004 and we would like to use an access database, for our database. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

ok, firstly how big is this LAN party going to be as MS Access isn't very good at having a load of people talking to it at once.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>How do I:
1) Set up sever (mySql?)<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Access and Mysql are 2 totally different databases. Mysql is much better, so if the ? was because you're confused on which one to use, then Mysql is the way to go.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>2) How to add the database to the server<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Well on most Mysql hosting accounts, you can add a database through a control panel supplied to you, or by coding it into a .php file via sql and executing it on the server.
To add an access database you simply ftp it onto the server (keeping it outside of the www dir/ so it can't be downloaded and tampered with).

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>3) How to connect dreamweaver with the database<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
For Mysql you will simply need a Username, Password, Hostname (usually Localhost), and a Database name. The user and pass are sometimes assigned by the host, and sometimes by you, depends on the setup. Then you either run a simple recordset command through dreamweaver and fill in the info as mentioned above, or you can code your own connection file.
Access will run off a Connection string, or a DSN on the server, which is done through the server control panel.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>4) How to make a form that will send information to the server <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
make a form in dreamweaver that represents the tables you created in the database, then use dreamweavers built in 'Insert' functions for writing to the database. This will add all the code you need.



regards

Dave Thomas
<b>DMX Zone Manager</b>

uswebpro.tempwebpage.com/dmxtutorials/7-setupSQLDatabase.htm



Tutorial #7

Today we wil setup our MySQL Database Tables.
These tables will store our website's data.


At this point you need to have a web hosting account with PHP & MySQL.
If you do not have one, let us set one up for you.


We will use NaveCat in this example.

You can download a free 30-day trial here:
Please click the button below to start downloading the evaluation version of Navicat.



-- USWebPro.com
ASP & PHP Web Development