We're going under the assumption that you have already set up a MySQL
database on your server.
When you set up your site in Dreamweaver make sure these are your settings:
Local info
Site Name: Whatever you like
Local Root Folder: Navigate to where you keep your files for the site on
your home computer
HTTP Address: http://yourdomainname.com/
Remote info
Access: FTP
FTP Host: yourdomain.com or servername.webcomindia.net(change to your domain or server name)
Host Directory: public_html/ (or public_html/subfolder/ for addon domains)
login: cpanel username
password: cpanel password
Check the box for "use passive FTP"
Do NOT check the box for "use firewall" (very important!)
As far as check in/check out, unless you have some specific reason to do so, do not check any of these boxes.
If you hit "test" after you set up these settings, you should be able to
connect.
Testing Server
Server Model: PHP/MySQL
All other settings should be the same as in the Remote Info, except for
URL Prefix: http://yourdomainname.com
Database Connection
Now create a PHP page by clicking on New, Dynamic Page, PHP or open an existing PHP page.
Open the Applications panel.
The first three of four steps should have check marks next to them.
For step four, click the "+" button, and select MySQL connection from the
drop-down list.
Connection name: whatever you would like to name it - it doesn't matter.
MySQL Server: localhost
Username: cpanel username
Password: cpanel password
Database: click "select" and in a few seconds (depending on your
connection speed) you should get a list of available databases you can
connect to.