close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Dynamic Connections Build GMC3 Available for WCE

Thread began 8/25/2010 5:25 pm by Anna Robinson | Last modified 9/07/2010 1:15 pm by Anna Robinson | 1080 views | 15 replies

Ray BorduinWebAssist

Since nobody has commented yet, I'll try to point out a few more of the advantages.

- Make a connection file that will dynamically determine the domain it's on and use the appropriate credentials based on that domain.

Currently a lot of people have a separate local and live database that have different connection information. The only way to handle this now is to maintain separate versions of the connection file. Then you have to make sure not to upload dependent files because it would overwrite the local or live version and break your site. With this new extension you can set up both versions in the connection file itself and not worry about this problem any more.

- Make a connection file to allow changing of the credentials even on the same domain.

Since you can have truly dynamic connection information you can for instance have multiple powerstore sites running with a single admin and allow someone to choose the store they want to administer from the admin and have it switch databases so that one admin could control any number of stores. Also you could use this for things like localization of different languages. For instance in powerCMS you could create a copy of your database for each language and have a dropdown to change the connection to the corresponding language which actually switches the database. Then you can have english, french, spanish, or whatever other language versions of your site all controlled by a session variable that changes the connection and the rest of your site can be the same.

- Make a connection file where just the username and password are dynamic so that different users can have different permissions.

More and more our extensions are going to start creating and manipulating database tables for you. This means your connection in Dreamweaver needs to have privilages that allow that, but you may not want your website user to have the same permissions for security reasons. This allows you to use one connection in DW but a separate connection on your live site to prevent any security concerns around having a user with database table editing privilages... also you may have a site where users view data and administrators insert and update data. You can use different database usernames and passwords associated with the user group by managing session variables to prevent users from having anything but read access to the database. That way even if you hapen to miss a SQL injection hole no malicious destruction or manipulation of data would be possible since the user permissions would prevent those types of queries from running, even though an admin that logs in could still have permission to make those edits.

Make sense? There are probably other good uses of this extension I haven't thought of as well. Please provide some feedback about whether this extension is helpful for you and how you would use it.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...