newbie: configuration of MySQL in PHP5 (Windows XP)

Posted by Andrzej Magdziarz on March 15, 2008, 11:16 am

Please log in for more thread options

Hello,
I have installed and configured Apache, PHP5 and MySQL in Windows XP. I need
to configure PHP to use MySQL. So far I added to php.ini:

extension_dir = "c:\windows;c:\Program Files\php\ext"
extension=php_mysql.dll
extension=php_mysqli.dll

but it's not enough (I suspect) because when I open phpinfo.php I see no
information about MySQL.
What else I should do? Please help.
/RAM/

Posted by Rik Wasmus on March 15, 2008, 5:49 pm

Please log in for more thread options

On Sat, 15 Mar 2008 16:16:11 +0100, Andrzej Magdziarz =

show/hide quoted text
I =

show/hide quoted text
no
show/hide quoted text

php.net/mysql sais:
A file named libmysql.dll is included in the Windows PHP distribution an=
d =

in order for PHP to talk to MySQL this file needs to be available to the=
=

Windows systems PATH. See the FAQ titled "How do I add my PHP directory =
to =

the PATH on Windows" for information on how to do this. Although copying=
=

libmysql.dll to the Windows system directory also works (because the =

system directory is by default in the system's PATH), it's not recommend=
ed.

So, locate libmysql.dll and make sure it's available in the PATH. Settin=
g =

the extension_dir will NOT solve it, you really have to hat it in the PA=
TH.
-- =

Rik Wasmus

Posted by Jerry Stuckle on March 15, 2008, 11:05 pm

Please log in for more thread options

Andrzej Magdziarz wrote:
show/hide quoted text
Extension directory is a single directory, not a list. And you must
still have the MySQL client installed and accessible to PHP (i.e.
libraries in the PATH or otherwise accessible and security set to allow
access).

And ensure you're modifying the correct php.ini file - see what
phpinfo() shows PHP is looking for for your php configuration files.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Posted by AnrDaemon on April 6, 2008, 11:28 pm

Please log in for more thread options

Greetings, Andrzej Magdziarz.
In reply to Your message dated Saturday, March 15, 2008, 19:16:11,

show/hide quoted text

show/hide quoted text

show/hide quoted text

Not "else", but if You're using PHP as an Apache module, You can preload
required libraries using LoadFile directive in Apache configuration.
And make sure You're using right library, in case of
http://bugs.php.net/bug.php?id=41350

--

Posted by Jerry Stuckle on April 7, 2008, 9:03 am

Please log in for more thread options

AnrDaemon wrote:
show/hide quoted text

There is no need to preload the MySQL library. And even if he did, it
would not solve this problem.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================