Dreamweaver CS3 and MySql - Macromedia Dreamweaver

This is a discussion on Dreamweaver CS3 and MySql - Macromedia Dreamweaver ; 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. ...

+ Reply to Thread
Results 1 to 7 of 7

Dreamweaver CS3 and MySql

  1. Default Dreamweaver CS3 and MySql

    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. Default Re: Dreamweaver CS3 and MySql

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



  3. Default Re: Dreamweaver CS3 and MySql

    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.


  4. Default Re: Dreamweaver CS3 and MySql

    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?


  5. Default Re: Dreamweaver CS3 and MySql

    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.


  6. Default Re: Dreamweaver CS3 and MySql

    consider buying navicat... it's the best software for working with mysql that i've found... makes your life very easy

  7. Default Re: Dreamweaver CS3 and MySql

    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?



+ Reply to Thread