Easy Ways to build a database in Dreamweaver

[danielparod]

Hi,

I am trying to add our inventory (car dealership) to my website that I built in Dreamweaver. Can anybody explain to me in newbie terms the easiest way to do this?

Thanks,
Daniel

[jhardman]

Hi,

I am trying to add our inventory (car dealership) to my website that I built in Dreamweaver. Can anybody explain to me in newbie terms the easiest way to do this?

Thanks,
Daniel

The answer will depend in part on what kind of server you are using. Different servers are already set up to work well with certain databases and although most could probably be set up with any db, you can simplify your steps if you know which dbs work well with your server.

Jared

[numberwhun]

Hi,

I am trying to add our inventory (car dealership) to my website that I built in Dreamweaver. Can anybody explain to me in newbie terms the easiest way to do this?

Thanks,
Daniel

You may find the tutorial you need here, but I really didn't look through for you.

Regards,

Jeff

[danielparod]

The answer will depend in part on what kind of server you are using. Different servers are already set up to work well with certain databases and although most could probably be set up with any db, you can simplify your steps if you know which dbs work well with your server.

Jared

Jared,

I am signed up with hostmonster, which has phpMyAdmin on it. However, trying to figure out how to use it, and more importantly, how to integrate it into my website, has proved more difficult than figuring out Dreamweaver. I guess I don't really understand how mySQL interfaces with a website.

Thanks,
Daniel

[eWish]

Daniel,

phpMyAdmin is simply a database management client. In order for your site to interact with the database you will need a server-side language to retrieve your data for you. You will need a language like Perl, PHP, Rudy etc.... I am sure that you could find some example code if you searched the programming forums. Also, Google can be for friend too when searching for tutorials.

Dreamweaver will only be able to help create your HTML markup for the display of your data that is retrieved from your database.

All of the above is after you have designed your database. That in it's selft is a task and will require a much better understanding of the database you use.

--Kevin

[danielparod]

Daniel,

phpMyAdmin is simply a database management client. In order for your site to interact with the database you will need a server-side language to retrieve your data for you. You will need a language like Perl, PHP, Rudy etc.... I am sure that you could find some example code if you searched the programming forums. Also, Google can be for friend too when searching for tutorials.

Dreamweaver will only be able to help create your HTML markup for the display of your data that is retrieved from your database.

All of the above is after you have designed your database. That in it's selft is a task and will require a much better understanding of the database you use.

--Kevin

Kevin,

Thanks for your post, the whole process makes a little more sense now. Is there a site that you would recommend I go to to learn what I need to?

Thanks,
Daniel

[eWish]

What language if any do you know? Once you know that, then you can search the programming forum of that language and/or search Google for tutorials. If you don't know any languages then that makes it harder. Both Perl and PHP are popular for web development and are easy to use for interaction with MySQL.

--Kevin

[danielparod]

I am currently learning PHP, which doesn't seem that difficult, so I have some hope there. I have started to build my database through phpMYadmin, once I get done with that, though, what would be my next step?

Thanks,
Daniel

P.S. Thanks for taking time to answer my stupid questions.

[eWish]

This is kind of an overview of what I would do.

1. Normalize Database
2. Create a management script to insert, edit, delete data in database. You could use phpMyAdmin is you wish for these tasks.
3. Design queries to retrieve data as needed executed via script for dynamic display.
4. Create markup for presentation of data retrieved.

I would ask for assistance in the programming forum of choice (PHP since that is what you mentioned.)

I hope that helps you get started.

--Kevin