6 Replies Latest reply on Jun 8, 2008 9:06 AM by mrtomg

    Dreamweaver CS3 and MySql

    mrtomg
      I have been following a tutorial on lynda.com on using php/mysql on DW CS3. I have successfully installed MAMP on my mac and have been using the local phpmyadmin and DW3 to populate pages with dynamic data. This is good. What is bugging me is that there doesn't seem to be any indication in the tutorial about connecting to the actual database on the web once the files are uploaded. I am used to using php to open a connection to my DB on the web and I don't think I have inputted anything that will tell DW where the "localhost" of my webhosts database might be and the username and password that will allow access. Have I missed a step? Is this something simple that I have somehow omitted? Any help would be much appreciated.
        • 1. Re: Dreamweaver CS3 and MySql
          Level 7
          There should be a Connections folder in your site.

          Inside that folder is the connection file. When you want to go live with the website, just edit it to reflect your live site
          settings.

          --
          Ken Ford
          Adobe Community Expert - Dreamweaver/ColdFusion
          Fordwebs, LLC
          http://www.fordwebs.com


          "mrtomg" <webforumsuser@macromedia.com> wrote in message news:g2ek5m$rkj$1@forums.macromedia.com...
          >I have been following a tutorial on lynda.com on using php/mysql on DW CS3. I
          > have successfully installed MAMP on my mac and have been using the local
          > phpmyadmin and DW3 to populate pages with dynamic data. This is good. What is
          > bugging me is that there doesn't seem to be any indication in the tutorial
          > about connecting to the actual database on the web once the files are uploaded.
          > I am used to using php to open a connection to my DB on the web and I don't
          > think I have inputted anything that will tell DW where the "localhost" of my
          > webhosts database might be and the username and password that will allow
          > access. Have I missed a step? Is this something simple that I have somehow
          > omitted? Any help would be much appreciated.
          >

          • 2. Re: Dreamweaver CS3 and MySql
            mrtomg Level 1
            Thank you very much Ken. There is indeed a connections folder that has the connection data listed. I know I can just plug in the right info there and it should connect just fine.

            I am surprised that the tutorial didn't make that a bit more obvious and that DW didn't have a way to automate that shift for the user. Hey, if it works that's all that matters.

            Thanks again.
            • 3. Re: Dreamweaver CS3 and MySql
              RichardODreamweaver
              In DW, there is a simple wizard that creates this file in the connections folder.

              In the Application panel, there is a tab called "Databases" - click new and you will be prompted to enter the details of the Database you have created on-line.

              This is, of course, assuming you have your site set up correctly - if not, go to site setup and go through the steps required for php server technology.

              When the connections folder is uploaded, the pages on your local system will be connected to the MySQL and you can build recordsets etc. from there.

              Does this help?
              • 4. Re: Dreamweaver CS3 and MySql
                mrtomg Level 1
                Hi Richard - This is actuallly getting at the nature of my problem. I know that I can create a DB connection via the "Application " database panel. However, whatever connection you make there responds to the configuration that was done in the "manage sites" setup. I set up my site's "testing" server with the php/mysql that was installed on my mac and it works just fine. The "remote" option in the manage sites setup doesn't have an option for php/mysql setup. The options I see are None, FTP, Local/network, RDS, and WebDav. None of those seems like an option to me. The closest would be the local/network but that option has no place to input the db username and password. From my newb perspective it doesn't seem to be asking for remote DB config into. Is one of those config options what I need? Thanks for your help with this.
                • 5. Re: Dreamweaver CS3 and MySql
                  jsteinmann Level 1
                  consider buying navicat... it's the best software for working with mysql that i've found... makes your life very easy
                  • 6. Re: Dreamweaver CS3 and MySql
                    mrtomg Level 1
                    I'm curious how you think this software might help the problem described in this thread? I have phpmyadmin installed on my local computer and have access to phpmyadmin online for the actual mysql db. How could this software help?