Dreamweaver CS4 - Dynamic Data Issue on Localhost (PHP/MySQL)

[Guest]

I am currently working through the dynamic data tutorials for the "Dreamweaver CS4: The Missing Manual" text and have encountered an issue when I try to add/run two different recordsets (one for products and one for categories) on one PHP page.

As instructed, I added the first recordset to the PHP page and was able to run the page in Live View (and on Safari) without any issues.  The links and data worked perfectly.  Then when I added the "Categories" recordset to the PHP page and tried to run LV or Safari, the page came back completely blank.  For fear that I had made a mistake, I scrapped my files and started the lesson again only to find the issue still appeared.

I have installed MAMP on my iMac and configured it according to the text and the MAMP website.  I have also configured Dreamweaver CS4 according to the text.  My only guess is that there is a configuration setting on either MAMP (PHP or Apache) or Dreamweaver CS4 that needs to be adjusted.  Please let me know...

[Peter_A__Forkes]

I am keeping a close eye on this thread.

For three weeks I have been FIGHTING PHP to get it to work.

MAMP tells me that is it running BUT no matter what PHP code I try an execute, all I get is the PHP echoed back to me.

Good luck!  We're going to need it.

[David_Powers]

I'm pretty sure that by default, MAMP turns off display_errors. If you have a PHP syntax error on your page, you'll get a blank screen.

To turn on the display of errors, you need to edit the PHP configuration file, php.ini, which is located at /Applications/MAMP/conf/php5/php.ini.

It's best to edit php.ini in a dedicated text editor, such as BBEdit. If you don't have BBEdit, get TextWrangler, which is free from www.barebones.com.

Inside php.ini, search for the following line:

display_errors = Off

Change it to this:

display_errors = On

A few lines further down, locate this line:

log_errors = On

Change it to this:

log_errors = Off

Save the file, and restart Apache. You should then see error messages displayed onscreen.

[Guest]

Thanks David!  That helped me to determine that I had some misplaced code in my PHP file.  I scrapped the PHP file once again and started the tutorial over, and it worked this time.  🙂