problem connecting to Mysql

weeda · Joined: 12 Jun 2006 Posts: 10

Hi all,
i am a beginner in GTK PHP and i have problem connecting to MySQL 5.0.18.
I am using GTK-PHP2 with PHP5. I use @mysql_connect, so i cant see the error message. But if I use just mysql_connect, then i got the following error message: Fatal:error: Call to undefined function mysql_connect() in XXX on line XXX .
With PHP5 (classic, no GTK), the connection is working, so I have no idea what's the problem.
Thanks in advance,
Andi

cweiske · Joined: 08 Dec 2005 Posts: 454 Location: Leipzig/Germany

I guess the mysql extension isn't loaded. Look into the php.ini.
It's in C:\PHP-Gtk2\php.ini

weeda · Joined: 12 Jun 2006 Posts: 10

Thanks for the quick answer.
The extesnsion php_mysql.dll is loaded. I need something else?

cweiske · Joined: 08 Dec 2005 Posts: 454 Location: Leipzig/Germany

Are you sure? Am I right that you have two php versions on your computer, one for php-gtk2 and one for the webserver?

To check if it is really there, you can use

weeda · Joined: 12 Jun 2006 Posts: 10

I have 3 PHP installed. One PHP4 (i am not using this), PHP5 for the webserver and one PHP5 for GTK. And i am using the php frpm the GTK.
Hmm... you have right the mysql extension is not loaded...how can i loaded it? the extension=php_mysql.dll is in the php.ini. I have to do something else?

cweiske · Joined: 08 Dec 2005 Posts: 454 Location: Leipzig/Germany

Do you have a php.ini in your windows (or windows system) directory? if yes, please move it to the apache php installation.

But you don't have a semicolon in front of the "extension" -> ";extension=..."? If yes, remove it.

leon_pegg · Joined: 12 Jun 2006 Posts: 113 Location: hemel / UK

try running from the command line like this
c:\phpgtk2\php.exe -c c:\phpgtk2\php.ini c:\phpgtk2\myprograms\test.php

this ensures that the corect php.ini is used if not it will default to the c:\windows\php.ini

regrads leon pegg

weeda · Joined: 12 Jun 2006 Posts: 10

I don't have a semicolon in front of the extension.
The PHP is using the php.ini from the c:/windows/ directory.

cweiske · Joined: 08 Dec 2005 Posts: 454 Location: Leipzig/Germany

That's the problem: There are two php.ini files on your system.

Your webserver php uses the one in the windows dir, while the php-gtk one *should* use the one in C:\php-gtk2\. Apparently, it uses the one in the windows dir which fails.

So move the one from the windows dir to the apache/whatever directory, so that only the webserver php sees it. That should fix it for php-gtk2.

weeda · Joined: 12 Jun 2006 Posts: 10

should i use a specific port for mysql_connect at the "mysql.default_port =" or what's the procedure here ?

weeda · Joined: 12 Jun 2006 Posts: 10

It's working Very Happy

Thanks for the help...