close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Connection(s) to Existing Database

Thread began 8/19/2009 12:45 pm by robert222776 | Last modified 8/24/2009 12:09 pm by robert222776 | 2406 views | 3 replies

robert222776

Connection(s) to Existing Database

I have an existing client php site with a database I built and connected to with DW db connections and server behaviors, etc., that utilize a dynamic master/detail page relationship. The database is simple, with a table for members and one for users. Consequently, I already have a Connection folder and file. In addition, as part of the above, I already have a simple CMS to handle member/user edits, additions, and deletions of database records. Again, all built DW server behaviors prior to my having any WA products. Also, obviously we are dealing with a live server and not a testing server situation.

1. Now I want to add PowerCMS to the mix. I have already added the PowerCMS tables to the existing database. My first thought is that I want to leave the existing CMS as is, and use PowerCMS to "manage" the rest of the static site pages. Is that the recommended approach, as opposed to abandoning the existing CMS in favor of using PowerCMS to manage the entire site?

2. Assuming that I leave the current CMS in place, now the question is what to do with the Connections folder at the "root" of the CMS100 folder. I would prefer to leave all the PowerCMS folders and files inside of the CMS100 folder at the site root to keep things tidy, instead of placing them separately at the site root (where the other Connection folder resides). With the CMS100 folder in place at the site root, it seems like I would need a second database connection for the benefit of the PowerCMS files. Do I really need more than one connection to the same database with this scenario?

3. I suppose another option is to create a second database for PowerCMS and make the connection to that database, but that seems somewhat redundant and unnecessary. True?

4. How do you recommend I proceed in this situation?

Thanks,
Robert

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

Content

rating

Layout

rating

Ease of use

rating

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...