Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Connecting to Mysql

New Here ,
Apr 25, 2007 Apr 25, 2007
I installed mysql and try to use php on Winxp using IIS.
The phpinfo script runs great however i cant set up a connection string using dreamweaver, when i select a database a get the message:

Your php server doesn't have the Mysql module loaded or cant use the mysql_pconnect functions.

Can someone please help me

Thanku in advance
TOPICS
Server side applications
871
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Apr 25, 2007 Apr 25, 2007
>>
Your php server doesn't have the Mysql module loaded or cant use the mysql_pconnect functions.
>>

when looking at your phpinfo, do you see "MySQL Support: enabled" somewhere ?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 25, 2007 Apr 25, 2007
Sorry...where is "phpinfo" exactly?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Apr 25, 2007 Apr 25, 2007
well, you said "The phpinfo script runs great" -- there´s actually a PHP function called "phpinfo" which will display all your server settings, so I thought that´s what you´ve been seeing already ;-)

please create a new PHP file containg only the following:

<?php
phpinfo();
?>


and save it in your local server root as, say, "phpinfo.php". When launching this page in your browser, it should display lots of server related information to you, and somewhere you should be seeing "MySQL Support: enabled".
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 25, 2007 Apr 25, 2007
On 25 Apr 2007 in macromedia.dreamweaver.appdev, martha.a wrote:

> Sorry...where is "phpinfo" exactly?

- Create a new text file; name it, say phpinfo.php
- In that file add the following:

<?php phpinfo(); ?>

- Save the file and upload it
- Browse to it

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 25, 2007 Apr 25, 2007
Thanks for the help.
No, I don't see it anywhere...
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 25, 2007 Apr 25, 2007
I copypasted the question from another post which wasn't mine. Sorry for the confusion...
I did what u say but I don't see "MySQL Support: enabled" anywhere.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Apr 25, 2007 Apr 25, 2007
>>
I did what u say but I don't see "MySQL Support: enabled" anywhere
>>

If you don´t see this, it seems that the MySQL module isn´t activated at all -- regretfully I can´t provide a solution for IIS, let´s hope that someone else reading this can tell you more about it.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 25, 2007 Apr 25, 2007
geschenk wrote:
> If you don�t see this, it seems that the MySQL module isn�t activated at all
> -- regretfully I can�t provide a solution for IIS, let�s hope that someone else
> reading this can tell you more about it.

How did you install PHP? Using the Windows Installer? If so, which
version? If you're using 5.2.0 or higher, you can find installation
instructions here.

http://foundationphp.com/tutorials/php_installer.php

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 25, 2007 Apr 25, 2007
Yes, I used the Windows Installer.
When I went through the step #7, I did select the MySql extension.

I cannot figure out what is going wrong.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 25, 2007 Apr 25, 2007
martha.a wrote:
> Yes, I used the Windows Installer.
> When I went through the http://foundationphp.com/tutorials/php_installer.php, I did select the MySql extension.
>
> I cannot figure out what is going wrong.

Did you restart your computer after installing it?

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 25, 2007 Apr 25, 2007
LATEST
Yes...
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines