Setting up a mySQL database for a website ...

[purbeast0]

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.

 

[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?

 

[iroast]

if the host doesn't have phpmyadmin, you can try mysqlcc http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html

 

[purbeast0]

I don't think it has phpmyadmin with dreamhost ... I don't see it in the control panel anywhere.

 

[purbeast0]

Originally posted by: iroast
if the host doesn't have phpmyadmin, you can try mysqlcc http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/downloads/mysqlcc.html

To install that on my webspace, will I have to download it and upload it to my webspace, then somehow connect to my webspace through a command prompt and set it up that way?

 

[purbeast0]

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]

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.

 

[L1FE]

http://www.freewebmasterhelp.com/tutorials/phpmysql

Try that. First link that popped up when you googled mySQL and php.

 

[purbeast0]

Originally posted by: L1FE
http://www.freewebmasterhelp.com/tutorials/phpmysql

Try that. First link that popped up when you googled mySQL and php.

Thanks I'm going to check it out right now.