Setting up a mySQL database for a website ...

purbeast0

No Lifer
Sep 13, 2001
53,544
6,368
126
I am trying to learn how to setup a database for a web based type of database thing, where uses can enter stuff into the database and it will be posted on the web.

For starting I am just trying to learn how to setup just a basic webpage that access a database. My current hosting company is dreamhost, and I have created an SQL database alredy through their control pane.

Now I looked online at a few tutorials with google but they don't really seem to be web-based it seems. They were more for setting up local ones.

I am a programmer but haven't done DB stuff before (opted to not take the class in school) but I've touched on mySQL in school for a few weeks, but that was a few years ago. So could anyone point me in the direction that will tell me how I can setup the mySQL database that I have created in dreamhost with a webpage that I'm trying to make just to test it out?

Thanks.
 

purbeast0

No Lifer
Sep 13, 2001
53,544
6,368
126
I don't think it has phpmyadmin with dreamhost ... I don't see it in the control panel anywhere.
 

purbeast0

No Lifer
Sep 13, 2001
53,544
6,368
126
Originally posted by: SofaKing
do you have cPanel?

http://demodemo.com/1/tutorials/cpanel_xskin_mysql.htm

edit: ah, didn't see you had dreamhost.

hmm, do they have phpmyadmin installed?

Okay well I just looked at that demo. I have already created the actual database through the control panel of dreamhost as well as created an account.

I guess my main question is how do I go about linking the mySQL database to an actual webpage. or where can I find a tutorial how to do that. for now I just want to do a simple link w/like one field, then display everything in the DB on the webpage that I entered the information from.
 

L1FE

Senior member
Dec 23, 2003
545
0
71
It seems like you've already set up the database. In order to create tables within that database, you can click on the direct link in your Goodies > MySQL page. This link is usually dbname.domainname.com. After logging in you should have access to basically anything you need to create a table. In order to access that database and allow users to manipulate data, you should just check up on some basic mySQL tutorials. Straight out of the box mySQL will not be able to do what you want it to do in terms of having users be able to enter data etc etc.