18 Replies Latest reply on Aug 31, 2006 12:35 PM by jblattert

    PHP5, Apache5,MySQL5 & Dreammweaver8

    Mwalimo Level 1
      I am very new to PHP, Apache and MYSQL.

      For two weeks now I have tried and failed to do the following (all installations are local on my laptop):

      1. To set up the PHP Application server....why is it is hard and very frustrating.
      Can someone help me with SIMPLE, inassuming instructions for installing PHP5.
      The instructions(in the PHP manual) are helpless and hopeless for a beginner like me.

      2. To connect Dreamweaver 8 to MySQL database....the error is unknown!
      Has this anyhthing to do with my failed PHP installation?
        • 1. Re: PHP5, Apache5,MySQL5 & Dreammweaver8
          Level 7
          If you would just buy a copy of David Powers' Foundation PHP for Dreamweaver
          8, your problems will be solved. He has pages of details about how to do
          this on both a PC and a Mac. The tutorials are explicit, and comprehensive.
          It worked right the first time for me.

          --
          Murray --- ICQ 71997575
          Adobe Community Expert
          (If you *MUST* email me, don't LAUGH when you do so!)
          ==================
          http://www.dreamweavermx-templates.com - Template Triage!
          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
          http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
          ==================


          "Mwalimo" <webforumsuser@macromedia.com> wrote in message
          news:ecuju9$19o$1@forums.macromedia.com...
          >I am very new to PHP, Apache and MYSQL.
          >
          > For two weeks now I have tried and failed to do the following:
          >
          > 1. To set up the PHP Application server....why is it is hard and very
          > frustrating.
          > Can someone help me with SIMPLE, inassuming instructions for installing
          > PHP5.
          > The instructions(in the PHP manual) are helpless and hopeless for a
          > beginner
          > like me.
          >
          > 2. To connect Dreamweaver 8 to MySQL database....the error is unknown!
          > Has this anyhthing to do with my failed PHP installation?
          >
          >


          • 2. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
            Mwalimo Level 1
            Murray *ACE*, unfortunately I am in an African country where such books are not found and impossible to get. The Internet is all I have.
            Is there a way you can help?
            • 3. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
              Level 7
              Perhaps David will come along and respond directly. To get ready for this,
              tell us what OS you are using, please. Also, tell us if you have installed
              Apache already, or do you plan to use IIS?

              --
              Murray --- ICQ 71997575
              Adobe Community Expert
              (If you *MUST* email me, don't LAUGH when you do so!)
              ==================
              http://www.dreamweavermx-templates.com - Template Triage!
              http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
              http://www.dwfaq.com - DW FAQs, Tutorials & Resources
              http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
              ==================


              "Mwalimo" <webforumsuser@macromedia.com> wrote in message
              news:ecunl1$647$1@forums.macromedia.com...
              > Murray *ACE*, unfortunately I am in an African country where such books
              > are not found and impossible to get. The Internet is all I have.
              > Is there a way you can help?
              >


              • 4. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                Mwalimo Level 1
                Murray 'ACE',

                The OS is Windows XP Professional.

                I have installed the following:

                1. PHP5 in c:\php
                It is not working, the test scripts are not displaying the expected output.

                2. MySQL5 in c:\mysql
                MySQL seems to be running fine. I have gone through most tutorials.
                However, Dreamweaver 8 cannot connect to the databases.

                3. APACHE5 in c:\apache
                APACHE on Port 80, http://localhost/ is loading the test index.html located in the folder c:\apache\webapps\ROOT\

                I do not intent to use IIS. My intention is to use the trio (apache,mysql, php), if I get over the nightmare I having.
                • 5. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                  Level 7
                  How have you defined the testing server in DW?

                  --
                  Murray --- ICQ 71997575
                  Adobe Community Expert
                  (If you *MUST* email me, don't LAUGH when you do so!)
                  ==================
                  http://www.dreamweavermx-templates.com - Template Triage!
                  http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
                  http://www.dwfaq.com - DW FAQs, Tutorials & Resources
                  http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
                  ==================


                  "Mwalimo" <webforumsuser@macromedia.com> wrote in message
                  news:ecv6oo$nud$1@forums.macromedia.com...
                  > Murray 'ACE',
                  >
                  > The OS is Windows XP Professional.
                  >
                  > I have installed the following:
                  >
                  > 1. PHP5 in c:\php
                  > It is not working, the test scripts are not displaying the expected
                  > output.
                  >
                  > 2. MySQL5 in c:\mysql
                  > MySQL seems to be running fine. I have gone through most tutorials.
                  > However, Dreamweaver 8 cannot connect to the databases.
                  >
                  > 3. APACHE5 in c:\apache
                  > APACHE on Port 80, http://localhost/ is loading the test index.html
                  > located
                  > in the folder c:\apache\webapps\ROOT\
                  >
                  > I do not intent to use IIS. My intention is to use the trio (apache,mysql,
                  > php), if I get over the nightmare I having.
                  >


                  • 6. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                    Mwalimo Level 1
                    Murray, here are the setting for the Testing server in DW.

                    Server Model ---> PHP MySQL
                    Access --->: Local/Network
                    Testing Server folder--->c:\apache\webapps\ROOT\
                    The refresh option is ticked
                    URL prefix---> http://localhost

                    Also, I found a very easy to follow tutorial on installing PHP5 ( http://www.evaria.com/v3/index/article/19/how-to-install-php5-on-windows.html) but with Apache2, not apache5. So I could not find the file httpd.conf in the c:\apapche\conf folder.
                    • 7. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                      Level 7
                      Mwalimo wrote:
                      > 1. PHP5 in c:\php
                      > It is not working, the test scripts are not displaying the expected output.

                      How did you install it? Using the Windows Binaries zip package or the
                      Windows installer?

                      > 2. MySQL5 in c:\mysql
                      > MySQL seems to be running fine. I have gone through most tutorials.
                      > However, Dreamweaver 8 cannot connect to the databases.

                      Did you choose that installation location yourself? The default location
                      for MySQL 5.0 is C:\Program Files\MySQL\MySQL Server 5.0.

                      Dreamwweaver cannot connect to MySQL if PHP is not working.

                      > 3. APACHE5 in c:\apache
                      > APACHE on Port 80, http://localhost/ is loading the test index.html located
                      > in the folder c:\apache\webapps\ROOT\

                      There is no such program as Apache 5. It sounds as though you have
                      installed Apache Tomcat 5.0, which is used for serving Java Server Pages
                      (JSP). To work with PHP, you need to install Apache 2.0. The official
                      PHP binaries are compatible only with Apache 1.3 or Apache 2.0.

                      --
                      David Powers
                      Adobe Community Expert
                      Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                      http://foundationphp.com/
                      • 8. PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                        Jon9999 Level 1
                        Mwalimo,

                        I know David doesn't recommend it, but if you are pulling your hair out you might just give one of the all-in-one Apache/PHP/MySQL distros a try. I've had very good success with XAMPP. The current version of XAMPP includes Apache 2.2.2, MySQL 5.0.21, PHP 5.1.4 (patched to work with Apache 2.2), phpMyAdmin 2.8.1, and an all-in-one control panel. It installs easily and in one step, and it worked for me right out of the package. The default configuration probably won't be exactly what you want, so you'll still have some tweaking to do.

                        The downside is that you won't get quite the latest releases of all of the components, and you won't get updates (including, notably, security-related patches) as quickly as would if you install all the pieces individually. You also run the risk of being stuck if development of your distro should ever stop, but the worst-case scenario is that you'll have to re-install all of the pieces individually -- which is exactly where you are right now.

                        First choice is to install Apache and PHP and MySQL and phpMyAdmin individually. (Actually, first choice is to get yourself a copy of David's book to guide you through installing Apache and PHP and MySQL and phpMyAdmin individually.) If you simply can't get the individual installs to work, or if you're pressed for time and you need something temporary while you figure it all out, try XAMPP.

                        Good luck.

                        P.S. To reiterate something David said above that I figured out the hard way, if you do try to go the individual route, don't install Apache 2. 2.x. The 2.2 series doesn't work with PHP 5.1.x (except with a patched library file, as is included with XAMPP). With PHP 5.1.4 or 5.1.5, make sure you install Apache 2.0.x (most recent in the 2.0 series is 2.0.59).
                        • 9. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                          Level 7
                          Jon9999 wrote:
                          > I know David doesn't recommend it, but if you are pulling your hair out you
                          > might just give one of the all-in-one Apache/PHP/MySQL distros a try. I've had
                          > very good success with http://www.apachefriends.org/en/xampp.html.

                          A lot of people do have great success with XAMPP. My main concern with
                          recommending it to someone like Mwalimo is that he has already installed
                          the main components. Unless he can uninstall them cleanly, they may
                          cause conflicts with the XAMPP installation.

                          My aversion to the all-in-one packages goes back to one that was very
                          popular a few years ago (I think it came from a site in Australia called
                          firepages). Development just stopped overnight and a lot of people had
                          difficulty uninstalling it and upgrading. I believe XAMPP has better
                          support and, unlike some other packages, it doesn't alter the Windows
                          registry, so is easy to uninstall.

                          --
                          David Powers
                          Adobe Community Expert
                          Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                          http://foundationphp.com/
                          • 10. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                            Jon9999 Level 1
                            Hi David,

                            I installed XAMPP over a failed/partial installation of individual components when I couldn't get everything to work properly (before buying your book, of course!), and it installed and worked without incident. Conversely, once I bought your book, I had no trouble uninstalling XAMPP and re-installing native versions of everything, on two computers. The XAMPP setup program appears to behave well, and it's very easily and cleanly uninstallable from the Add/Remove Programs applet in the Windows Control Panel. Of course, there might be other issues that I never uncovered, but for someone like Mwalimo who just can't get anything else to work, I think it's a reasonable option.

                            XAMPP served me well for a time, until I bought your book and was able to follow your recommendation (and very clear instructions) to install native versions of everything. I'm glad I followed your advice because I now have up-to-the-minute access to the latest releases of everything, but XAMPP worked fine as a stopgap.

                            Cheers,
                            -jon
                            • 11. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                              Level 7
                              Jon9999 wrote:
                              > I installed XAMPP over a failed/partial installation of individual components
                              > when I couldn't get everything to work properly (before buying your book, of
                              > course!), and it installed and worked without incident.

                              That's useful to know.

                              > XAMPP served me well for a time, until I bought your book and was able to
                              > follow your recommendation (and very clear instructions) to install native
                              > versions of everything. I'm glad I followed your advice because I now have
                              > up-to-the-minute access to the latest releases of everything,

                              That's nice to know, too. :)

                              --
                              David Powers
                              Adobe Community Expert
                              Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                              http://foundationphp.com/
                              • 12. PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                Mwalimo Level 1
                                David and Jon99,
                                Thank you very much for your comments. After considering them, I did the following:

                                1. Installed Apache 2.2.3 (c:\apache2 ----->David, you were correct that I had installed Apache Tomcat)
                                The test for the webserver works.
                                However the server does not load when I add the following lines (for PHP) to c:\Apache2\conf\httpd.conf.
                                LoadModule php5_module "c:/php5/php5apache2.dll"
                                PHPIniDir "c:/php5"

                                2. Installed PHP 5.1.6 (c:\php5)
                                Its is not working and I don't know why.

                                3. Installed MySQL 5.0 (C:\Program Files\MySQL\MySQL Server 5.0)
                                Dreamweaver 8 is still not connecting to MySQL database, most probably because PHP is not working.

                                I really whish I had David's books, but like I said befoer the Internet (you guys included) is all I have. Please help.
                                • 13. PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                  Jon9999 Level 1
                                  Mwalimo,

                                  You're almost there.

                                  But you were warned twice, my friend! Scroll up a bit and re-read the final paragraph of David Powers's posting dated 08/28/2006 at 07:54:10 PM and the postscript to my posting dated 08/28/2006 at 10:47:27 PM, then uninstall Apache 2.2.3 and install Apache 2.0.59 instead. PHP 5 is not compatible with the Apache 2.2 series.

                                  Good luck!

                                  -jon
                                  • 14. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                    Level 7
                                    Jon9999 wrote:
                                    > Read the P.S. to my posting dated 08/28/2006 at 10:47:27 PM, then uninstall Apache 2.2.3 and install Apache 2.0.59 instead.

                                    Hmm. I don't seem to be able to see Jon's post-script, but the reason
                                    you need to uninstall Apache 2.2.3 is because the official PHP
                                    distribution doesn't support it. You need Apache 2.0 instead.

                                    --
                                    David Powers
                                    Adobe Community Expert
                                    Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                                    http://foundationphp.com/
                                    • 15. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                      Level 7
                                      Probably was an edit to the original webforum post.

                                      --
                                      Murray --- ICQ 71997575
                                      Adobe Community Expert
                                      (If you *MUST* email me, don't LAUGH when you do so!)
                                      ==================
                                      http://www.dreamweavermx-templates.com - Template Triage!
                                      http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
                                      http://www.dwfaq.com - DW FAQs, Tutorials & Resources
                                      http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
                                      ==================


                                      "David Powers" <david@example.com> wrote in message
                                      news:ed4m3g$e5k$1@forums.macromedia.com...
                                      > Jon9999 wrote:
                                      >> Read the P.S. to my posting dated 08/28/2006 at 10:47:27 PM, then
                                      >> uninstall Apache 2.2.3 and install Apache 2.0.59 instead.
                                      >
                                      > Hmm. I don't seem to be able to see Jon's post-script, but the reason you
                                      > need to uninstall Apache 2.2.3 is because the official PHP distribution
                                      > doesn't support it. You need Apache 2.0 instead.
                                      >
                                      > --
                                      > David Powers
                                      > Adobe Community Expert
                                      > Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
                                      > http://foundationphp.com/


                                      • 16. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                        Jon9999 Level 1
                                        Murry is correct. I forgot that those of you in NNTP land cannot see the edits.

                                        The postscript says:

                                        "P.S. To reiterate something David said above that I figured out the hard way, if you do try to go the individual route, don't install Apache 2.2.x. The 2.2 series doesn't work with PHP 5.1.x (except with a patched library file, as is included with XAMPP). With PHP 5.1.4 or 5.1.5, make sure you install Apache 2.0.x (most recent in the 2.0 series is 2.0.59)."
                                        • 17. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                          Mwalimo Level 1
                                          quote:

                                          Originally posted by: Jon9999
                                          Mwalimo,

                                          You're almost there.

                                          But you were warned twice, my friend! Scroll up a bit and re-read the final paragraph of David Powers's posting dated 08/28/2006 at 07:54:10 PM and the postscript to my posting dated 08/28/2006 at 10:47:27 PM, then uninstall Apache 2.2.3 and install Apache 2.0.59 instead. PHP 5 is not compatible with the Apache 2.2 series.

                                          Good luck!

                                          -jon


                                          Yes, I (oops, WE) got it! The Apache, PHP and MySQL trio is finally working with my Dreamweaver. It feels like a dream.
                                          Thank you guys for baby sitting me.
                                          • 18. Re: PHP5, Apache5,MySQL5 &amp; Dreammweaver8
                                            jblattert
                                            David,

                                            FINALLY I think I'm getting some answers! Thank you, David, for some insight! I haven't gone ahead with a complete uninstall yet, but want to know your recommendations for procedure. So many times in the past, I've been in worse shape after doing an uninstall/reinstall than I was before...

                                            This is my present configuration - which actually WORKS, to a degree. The database connections are in place, but the bindings return a general 500 error.

                                            Windows XP

                                            Dreamweaver 8.0.2 (just upgraded - same problem)

                                            - Used setup-v1.17-apache-2.2.2-win32.exe for setup - from devside.net PHP 5.2.0-dev MySQL 4.1.7 (installed new after package. Have two instances of mysql on my system - one active, one in manual-inactive)

                                            - All was going well until trying to establish bindings in Dreamweaver. PHP is up and running. MySQL loaded, and database connection fine. Bindings gets the error... "HTTP Error Code 500 Internal Server Error"

                                            Assuming that I should uninstall Apache 2.2.2 and put 2.0.59 in its place, what train of procedures would you recommend so I'm not in a worse situation...

                                            My complete post about this may have been in the wrong forum -- no replies as yet:
                                            http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=263&threadid =1188235&enterthread=y

                                            On another note -- if I can never get the bindings to work through the DreamWeaver interface, does that mean that manual coding will be fruitless as well?

                                            Thank you!

                                            Joe B.