newbie1

SUMMARIZING 4 TROUBLESHOOTING POINTS FOR MYSQL CONNECTION 1) In Dreamweaver, go to Sites/Manage Sites/Advanced, in “Testing Server,” be sure to configure URL prefix: http://localhost/ .... See Check the URL Prefix in the Site Definition at Macromedia.com. (Note that the URL prefix does not always need to point to http://localhost/. Right now, we are just using localhost as the troubleshooting web site. The important thing is for “URL prefix” to point to the document root address of whichever testing web site you are connecting to.) 2) Make sure that the MySql extension is activated in php.ini. Take the ; off the left side of the line in order to activate: extension=php_mysql.dll 3) Make sure that extension_dir = “c:\php\ext” is activated in php.ini, and that it points to the correct directory where php_mysql.dll is located. For PHP5: extension_dir = “c:\php\ext” For PHP4: extension_dir = “c:\php" Use this if you followed PHP4 installation instructions and copied all the extensions from c:\php\extensions to c:\php. 4) Make sure that PHP is working in Apache server. Does browsing to your http://localhost/phpinfo.php page display PHP graphics and data? BLANK PAGES AND ERROR CODES IN DREAMWEAVER The Dreamweaver Tutorial has you create PHP code on two pages: comments-view.php and comments-add.php. The problem is that after you complete the tutorial instructions, both pages display as blank pages in your Internet browser. If you’re working on those pages in Dreamweaver, when you click on “Live Data View” you get the following error code: The testing server did not execute any of the scripts in your document. Possible explanations include: 1) The testing server is not running. 2) The testing server ignores files with the ".php" file extension. 3) Your document does not contain any scripts. This is caused by a parsing problem in PHP, i.e the PHP code hangs up and your Apache server gives you a blank page. The solution is to make a change in the php.ini file. Change short_open_tag = on to make it read: short_open_tag = off Good luck. I hope this helps. REFERENCE: http://www.thriftyplaces.com/html/dreamwea...php___apac.html

Ok, here's the real answer. At least it worked for me. In your php.ini file, change short_open_tag = on to read: short_open_tag = off References: http://www.issociate.de/board/post/61138/P...ng_problem.html http://builder.com.com/5102-6371-1044988.html Happy parsing, Newbie-One

Marcromedia does a good job of describing how to map those directories in the section "Check the URL Prefix in the Site Definition" at http://www.macromedia.com/cfusion/knowledg...cfm?id=tn_16515. The URL prefix refers to the Testing Server, not the remote server. It may depend on how you defined your (Local Server/Testing Server/Remote Server) setup when you installed Dreamweaver. Since, I chose to have all 3 servers, Dreamweaver tries to execute the comments-view.php page from the tutorial at my Testing Server, which is Apache installed on the same PC as Dreamweaver. Anyway, that link is a good read that refers to your previous discussion. My interest is that I'm still getting the exact same error that you described. Google shows about 7 postings with this same problem, but no solutions. Only 7 postings, means that this problem is amazingly rare, or everyone else solved it so easily that they didn't bother to post about it. I"m still looking for the answer. Some hints that I have evolved are: 1) When I display comments-view.php in a browser, I see a blank white page. 2) When I use the browser to view the source code, all it displays are two lonely body tags. 3) When I use Windows Notebook to open that exact same page on my hard drive, all the code is there. 4) Dreamweaver designs it's PHP to execute first, before the HTML. In Windows Notebook, I can see all the PHP code at the very top of the page before the other code. 5) Maybe ==> It is a parsing error, i.e. an error in the code that Dreamweaver put on the page. Since, PHP executes first and hangs up, the rest of the page is not displayed even though it is there. Hey, I'm still guessing and looking. Good luck. Please post if you figure anything out.