Re: Dreamweaver - PHP and MySQL "Undefined Error"

Hi Jenn and thanks for replying to my email. I have used Dreamweaver successfully to create ASP web apps and I'm trying now to teach myself PHP. Noticing that the PHP community keeps growing, and I like that. Since I love Dreamweaver and I have used for years I do not want to do this in notepad like must geeks would recommend (BTW , someone already sent me an email suggesting I do that! LOL!) I know it is easy to use PHP to test and connect to MySQL using a regular text editor and an Web Server but I rather keep using Dreaweaver's API for writing code and creating dynamic pages. Now to answer some of your questions. I currently using XP with IIS 6.0. I installed PHP 5 (used the installer for this) so I guess I need to re-install PHP manually following their instructions on the php.net site. I installed MySQL 5 (and 4.x before that too) and created simple DBs and tables and new users, so I would connect to the db using "root" ID. I followed every instruction Macromedia has in their site to connect to MySQL but it wouldn't work. I read on their TechNotes that there are many problems lots of people report every day trying to connect to MySQL, so they simply said that they connect to MySQL using PHP and if PHP is not configured right it will simply not work. I look at the PHP site and documentation on how to install PHP and it looks pretty straight forward. So I'm going to try to install PHP manually now. The thing is that I did this following and trusting Macromedia's instructions and are amaze it wouldn't work. I guess things were easier when UltraDev was around!. LOL! If you can think of any other tip for me to try, please don't hesitate to drop me a line or two. Maybe I should switch to GoLive and see if they support MySQL connections yet. It is going to be the new dreamweaver now since Adobe bought out Macromedia, maybe they combine the two of them and come up with a DreamLive....hahhahaa...Bullocks! Cheer mate and thanx for the help! Jay "Jps" <jen_p_s@yahoo.com.au> wrote in message news:4265FAFC.4090006@yahoo.com.au... > J. Castillo wrote: >> I'm trying to connect to MySQL db from Dreamweaver and after 2 days, I'm >> starting to loose my pacient. >> >> Macromedia blames PHP for any "unexplain" reason why their software might >> not connect to MySQL. >> >> I tried everything they said on their support page and still no result. >> >> Anyone in here uses Dreamweaver to write PHP with a mySQL backend? >> >> Something I found is that php.ini when installed in Windows comments the >> include_path lines, lines that supposely, Dreamweaver needs to access >> MySQL when using PHP to connect. >> >> The error message I get from Dreamweaver when I leave the comments on the >> include_path lines in the php.ini file is: >> >> "Undefined Error" >> >> and when I remove the comments I get: >> >> "Error parsing C:\WINDOWS\php.ini on line 435" which is the line that had >> the comments. >> >> Help! anyone that have successfully connected to MySQL with via >> Dreamweaver. >> >> I have upgrade my Mysql to 5 Beta, and php to 5 also trying to see if >> that would fix the problem but with no result. >> >> Many thanks, >> >> Jay - Florida > Hi, > > I've been using Dreamweaver 2004MX to write PHP/mySql database web apps > for about a year now without problem. > Did you use the .msi file to install PHP or did you install and configure > it manually? I found that the .msi method leaves a lot out - modules in > particular if you are using Apache - very annoying. > > I'm a bit perplexed why Dreamweaver blames PHP. When you set up a mySql > connection in Dreamweaver it's just a plain tcp connection. If you set the > mySql database permissions up correctly for the account you are using for > the connection it should just do its thing and display the schema. The > only times I found that it did not were when: > 1. The local mySql client was too old to authenticate on the version of > mySql it was connecting to (bad one when we updated to mySql 4.1xx from > 4.0xx) > 2. The mySql server was set up to reject network connections. > 3. The firewall on the mySql server did not allow the port mySql was using > (3306 usually) > > > Are you using PHP for web apps or local scripts? > > Cheers, > Jennifer - Australia