So I would really like to use the full power of Dreamweaver by pulling some data from the database onto some php pages. OK, sure I can do this but create a /config/config.php and /inc/connectiontodatabase.php, functions.php but you know what that's a pain in the butt when all I want to do is show a list of names in the body of my webpage. So I'm reading how wonderful it is to use Dreamweaver to connect to mySQL. My only problem is I think I have a mentally defiecent Dw from the Creative Cloud.
If I hot to the HELP file it gives me and error say there is no help file in stalled and the Database window is just greyed out. I can see where I'm suppose to create a connection string but it's not available to me. True, I am using my SingleHop Server as both the remote server AND a testing server because Dreamweaver online help said I had to have a testing server to have a database. Why? Can't I just connect to my MYSQL Database I created on the remote site. What do a need another testing server or even a fake testing server for that matter?
Can someone help me? Can Dw really connect to my MYSQL database or is this a pipe dream?
That PHP code you're complaining about? That's what creates the connection to the database. PHP is a server-side scripting language. As requests come to the server, the PHP code executes, creates a connection to the database, queries the database based on whatever filtering you're asking the PHP script to do, captures the returned data from the quire to the database, puts it all back together and displays it as HTML on your page.
You really shouldn't "connect" your database directly to a website - that would be a security nightmare! Instead, you use server-side scripting langauge (PHP or ASP .NET are the big ones) to make carefully controlled and paramaterized calls (queries) to the database and return the data appropriately formated for display.
As for a testing server, take a look at WAMP/MAMP/XAMP - basically Apache, MySQL and PHP for W(indows), M(ac). It creates a nice self-contaioned environment on your local machine for testing. Testing servers are great because you can test your ideas in a nice, controlled environment before releasing them into the wilds of the internet. And with databases, you really do want to test things and make sure to lock stuff down - again there can be serious security implications once you start developing dynamic web sites.