Guide to creating a database using Dreamweaver.

In need of advice.

[Webwise]

Please I need a very good Step by Step ways of Creating Database using Dreamweaver. And also the best and easy way to learn MYSQL and PHP. Maybe a good Text book or a free Online website to get the right ways of creating DB using DW.

Vickii

[griz_fan]

Hi Vickii,

You wouldn't actually use Dreamweaver to create a database, but you would use Dreamweaver to create an HTML front end to access a database.

Since it looks like you're using PHP and MySQL, you would use what ever MySQL tools your web host provides for administering MySQL in order to create the database. Then, fire up Dreamwever to build your HTML pages to enter data into your database, or extract data from the MySQL database to display on your web pages using PHP scripting. If this sounds complicated and a bit intimidating, don't wory, it is at first. Luckily, there are scores of websites and books to help shed light on this. I found PHP and MySQL Web Development by Luke Welling and Laura Thomson a great help when I first started, I consider it an excellent beginner's book for PHP and MySQL. Also, check out [hotscripts.com...]
Here, you will find installation kits for Windows, OSX or Linux so you can install PHP, MySQL, Apache, etc... on your own computer. Having these at your disposal will really you help learn how to build a database-driven website.

Hope this helps!

[wonderbread]

phpMyAdmin is a great gui interface for administering mySQL databases. It sure beats manually typing in SQL statements from the SQL command line...

Many hosts have this preinstalled...you might want to check with them.

Nick

[jatar_k]

Welcome to WebmasterWorld Webwise,

try these
PHP Tutorial [ca3.php.net]
MySQL Tutorial [dev.mysql.com]

and these threads
Intro to PHP book [webmasterworld.com]
Books and Recomendations [webmasterworld.com]
Basics of extracting data from MySQL using PHP [webmasterworld.com]
Help developing MySQL search query [webmasterworld.com]