DreamweaverMX and a MySQL database

Report · Jul 26, 2006

Hi

I am trying to connect to my MySQL database in DreamwaeverMX.

When I try to add the MySQL Connection I put data as follow.

Connection Name :connTrio
Server Name : localhost
User Name : root
Password : password

I get message error "unidentifed error has occurred" When I try to select database.

I can confirm that the database is present, mysql is running, password used is correct.

Hope someone can help

Best Regards,

Martin

Report · Jul 26, 2006

Dax Trader wrote:
> I get message error "unidentifed error has occurred" When I try to select
> database.

This is probably one of the most frequently asked questions here.
Because the error is unidentified, you need provide the following
information for anyone to give you much help:

Which version of Dreamweaver?
What operating system?
Which version of PHP?
Which version of MySQL?
Does your version of PHP have MySQLI enabled?

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Jul 26, 2006

Hi
You said
Which version of Dreamweaver?
Reply 7.1
What operating system?
Reply Win XP
Which version of PHP?
Reply 5
Which version of MySQL?
Latest download
Does your version of PHP have MySQLI enabled?
I did at one point have PHP5 installed and Apache 2
I tested the server and all OK
I tested mysql and all ok
I tested (the install page) on PHP and all ok.

I ran a test live data (simple page) from within dreamweaver and it delivered back the server time so PHP was working.
So....individually all seems ok.

It seems like I have not integrated PHP with the server (god knows I have tried) I have followed every different instruction I could find on the internet to achieve this without success.
I ASSUME that it is this that is causing the failure of me to conect to the mysql database?

I have spent more than 36 hours to try to get set up so I can develop php and test on my local machine, I cant see that this is or should be that difficult. BUT I note in your response that it is the most asked question?
Tis very worrying that Macromedia must know this and yet dont seem to offer a definitive answer.

I will be delighted, estactic, and eternally in you debt if you can help me sort this. :-))
Martin
PS I might even fall in love with you :-))

Report · Aug 07, 2006

It seems that a lot of people are experiencing this problem. What worked in my case was changing the connection settings in Dreamweaver to use the driver on the local machine instead of the driver on the testing server and it now works like a charm. Hope this helps.

Report · Jul 26, 2006

Dax Trader wrote:
> BUT I note in your response that it is the most asked question?
> Tis very worrying that Macromedia must know this and yet dont seem to offer a
> definitive answer.

I believe it to be the most asked question because a large number of
people don't have a properly installed PHP/MySQL setup, or they fail to
define the testing server correctly in their site definition.

> I will be delighted, estactic, and eternally in you debt if you can help me
> sort this. :-))

Well, I'll try.

> PS I might even fall in love with you :-))

Please don't. I don't think my wife would approve. ;)

Open php.ini and make sure the semicolon is removed from the beginning
of these two lines:

;extension=php_mbstring.dll
;extension=php_mysql.dll

Add this line:

extension=php_mysqli.dll

Save php.ini, and restart Apache.
Load a page with <?php phpinfo(); ?> into a browser, and scroll right
down. Check that you have sections headed mysql and mysqli. Check that
the value of Client API version in those sections is at least 5.0.x.

Check your testing server setup.

The testing server folder must be in the Apache document root.
The URL prefix must be http://localhost/name_of_testing_folder/

Unless there is something unusual about your system, it should then work.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Jul 27, 2006

Hi
Thanks for all your help to date. Unfortunately I now have another error message when trying to connect to the MySQL database.

That message reads "Your PHP server doesnt have the MySQL module loaded or you cant use the MYSQL_(p)connect functions"

I can now confirm that Apache is running fine, MySQL is installed (I created a small test dbase with it to test the connection)

Apache is integrated with PHP5 as I can use the Live Data View facility in DreamWeaver.

Can you shed some more light :-))

Martin

Report · Jul 27, 2006

Dax Trader wrote:
> That message reads "Your PHP server doesnt have the MySQL module loaded or you
> cant use the MYSQL_(p)connect functions"
>
> Can you shed some more light :-))

Yes, believe it or not, that message says exactly what it means: you
don't have MySQL enabled in PHP. You can confirm this by creating a PHP
page that contains the following script (and nothing else):

<?php phpinfo(); ?>

Load it into a browser, and scroll down. You won't be able to find a
section headed mysql.

Open php.ini, and search for these two lines:

;extension=php_mbstring.dll
;extension=php_mysql.dll

Remove the semicolon from the start of each line to enable the
extensions. Also add this line after the second one:

extension=php_mysqli.dll

Save php.ini and restart Apache. Check your phpinfo() page again. If you
originally installed PHP correctly, you should now have sections headed
mysql and mysqli; and everything should work.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Jul 27, 2006

Hi David
Thanks for getting back to me so quick, I really appreciate it.
You sent those instructions earlier, I have done this (and just rechecked)
I can confirm that I DO NOT have the sections headed mysql and mysqli; when I run the test page.

I have installed PHP about 5 times always following every instruction step by step.

I can execute live data on the testing server so I know PHP is installed.
I can also use Mysql so that is ok

I think what you are saying is that Mysql and PHP are not "talking" to each other?

I have saved the "php.ini" file in both C:\ windows and C:\Windows\system32 and of course in its original location as part of the PHP folder.
I installed using the binaries as suggested.
Shame you dont offer a $50.00 remote setup service I would imagine you would be a very busy man indeed.

Where do we go from here?

Martin

Report · Jul 27, 2006

Dax Trader wrote:
> I have installed PHP about 5 times always following every instruction step by
> step.

Which instructions?

> I think what you are saying is that Mysql and PHP are not "talking" to each
> other?

No, what I'm saying is that the MySQL and MySQL Improved extensions are
not installed in PHP.

> I have saved the "php.ini" file in both C:\ windows and C:\Windows\system32
> and of course in its original location as part of the PHP folder.
> I installed using the binaries as suggested.

Who suggested installing binaries? Use binaries for Apache and MySQL,
but not for PHP. There's also no point in having three versions of
php.ini. Since I have no idea how you have installed PHP, it's very
difficult to advise of the best route forward.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Jul 27, 2006

Hi David
Sorry got confused over the binaries, of course I did not use that for PHP

Here are instructions I followed
http://www.tanguay.at/installPhp5.php5?step=1

Maybe if you have a look at the above link you will see where / IF it has given wrong advice.

Notice that some of the replies on that link mentioned both windows and system 32.

Dont give up on me please :-))
I really think you are my only hope on this.

Martin

Report · Jul 27, 2006

Hi
The "nightmare" is over !!!
Found this Wamp Server Set up

http://www.wampserver.com/en/download.php

100% working in less than 10 mins!

Report · Jul 28, 2006

Dax Trader wrote:
> Here are instructions I followed
> http://www.tanguay.at/installPhp5.php5?step=1

Those instructions use the deprecated method of installing PHP, which
has not been recommended for at least two years. However, I see you have
solved your problem by installing WAMP.

The fact that you now have a working installation is good news.
Everything may work fine; and in one sense that's what really matters.
Unfortunately, you have followed a poor set of instructions, which may
have left files lurking on your system that could cause future
incompatibilities.

A lot of people like WAMP and XAMPP, and both have good reputations; but
none of the all-in-one installers are approved by PHP:

http://uk2.php.net/manual/en/install.windows.php

Anyway, since you have a working installation, I think it's best to
leave well enough alone. You can now concentrate on working with dynamic
pages. Good luck.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

DreamweaverMX and a MySQL database

1 Correct answer