setting up a php package with dreamweaver
DREAMWEAVER: sql files I think don't open with dw cs5. but you can open them with notepad++. npp is probably more capable of handling the length and width you require. plus,it does column block editing should you need that (alt-drag).
DREAMWEAVER: start with some video tutorials or at least the book dreamweaver cs6 bible. youtube has some. lynda.com has all the excellent video training (and course content files on some stuff) you could want for $25/mo subscription. you can get the books from http://www.barnesandnoble.com or http://www.amazon.com
what you are basically going to be doing is editing source code files, probably PHP files. that's not trivial if you have not done that before. it's server-side scripting. you can find documentation at http://php.net I suggest you do 2 things.
- get the .chm version of the manual and configure windows to handle.chm files.
IE has its own debugger but has its own interesting nonstandard error messages that differ from everybody else. :-( IE is the odd man out when it comes to w3c/whatwg standards too.
DREAMWEAVER/whatever site setup: I don't have cs6. I have cs5. but I think it's basically the same. you go to the files panel, there's a dropdown box on the left side, change it to "manage sites". create your new site using local, put your URL into advanced. and if you don't have at least a test web server, you can't do dynamically-related files (which you could probably use to help you with editing that stuff). avoid having a remote/production web server you have to FTP to, until you want to actually FTP the site.chances are, you must read the site's manual pages (use a browser to file,open the main manual file) and learn how to install the package.
chances, are, the web designer has already set everything up except for the database.
you are welcome to contact me after 1pm Pacific time, that is support hours. if you do, please provide the link to this for reference.
the more you learn on your own, the better off you will be.
php software packages should be upgraded every 3 months or so for security reasons, to keep your site from getting hacked. so get used to the upgrade process. look up the php package's web site for instructions on the install/upgrade process and print it out (expand any relevant collapsed entries before printing).
php book:o'reilly's php+mysql.
this is not going to be an easy "word processor wysiwyg(what you see is what you get)" ride. for the most part, design view may just not work, so you may be stuck with code view. if you have a local XAMPP test server set up, it hopefully will discover and show dynamically-related files up top to make the editing more centralized instead of scattered and disjointed. by the way, 127.0.0.1 has the standard TCP/IP name localhost.
you will see hopefully still working config files, (updates happen every once in a while) and instructions for making your own test server to listen on 127.0.0.1:80 on your machine which is not in "promiscuous mode" (meaning, it does not bind to *:80 which is all the NICs on the computer, thus transmitting to the internet (ack!) [regardless of router - you need a commercial firewall to block port 80 outgoing that and keep it within your LAN, well that's a tough one, might need to restrict it to s specific NIC and have 2 NICs, one you use only for the internet and one for web server using static IP]). ISPs sometimes do not allow servers that transmit to the internet. read ISP's terms of service agreement. you don't want FTP going over the internet either, especially. I lost files that way, because I had my setup misconfigured.
go to hosting web server's control panel create your mysql database and database user grant appropriate rights to the database user (ALL unless specified) go into phpadmin, select the database you created then the SQL tab and copy and paste your SQL code in and execute now your database is ready for use.
password generator: (make very random passwords about 12-20 characters long including smattering of punctuation, uppers,lowers, digits) there are some characters you can't use that will mess things up. that page doesn't require a server to run.[fixed 2/22/2013]
a web-config.php config file that needs to be edited so it points to and logs into your database using the appropriate database server using the database user you created and selecting the mysql database name you created (you probably have to put all that info in, and if you are doing wordpress, some SALT codes you have to lookup and generate on your own and paste in). wordpress upgrades are SIMPLE. but don't do them with a browser because those are always broken (plugin upgrades over the browser are OK). read the manual.
you can then use dw's PUT arrow button or filezilla (preferable) to ftp the files to the ftp server. only you know that info. write all site info down on paper and file it.
this is NOT something people should do for you, because it requires passwords only YOU should know.
the test server may not be easy to set up, and it is optional. doing testing on a production server is not recommended.