Connection problems - PHP MySQL

[Schmalz]

Hi all. Probably not an original posting but I have searched high and low
for a satisfactory resolution to this problem. I am using Windows XP, IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create a
database connection I get the "Your PHP server doesn't have the MySQL module
loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe I
have already made the required changes to the php.ini file however this may
not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

[Johnny]

"Schmalz" <gp****@hotmail.comwrote in message
news:45**********************@un-2park-reader-01.sydney.pipenetworks.com.au.
...

Hi all. Probably not an original posting but I have searched high and low
for a satisfactory resolution to this problem. I am using Windows XP, IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create a
database connection I get the "Your PHP server doesn't have the MySQL

module

loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe

I

have already made the required changes to the php.ini file however this

may

not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

make yourself a phpinfo.php file that has a call to phpinfo() and run that
to see what's loaded, what points to where, the dir of your ini file, etc.,
etc.

[Jerry Stuckle]

Schmalz wrote:

Hi all. Probably not an original posting but I have searched high and low
for a satisfactory resolution to this problem. I am using Windows XP, IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create a
database connection I get the "Your PHP server doesn't have the MySQL module
loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe I
have already made the required changes to the php.ini file however this may
not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

Did you stop and restart your server?

For the mysql connections, you need the following in your php.ini file:

extension=php_mysql.dll

If you want to use mysqli, you need:

extension=php_mysqli.dll

(you can specify both).

And watch for any errors when you start your server. Check your server
log to see if there are any errors, also.

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

[ukiEMAIL]

Schmalz napisal(a):

Hi all. Probably not an original posting but I have searched high and low
for a satisfactory resolution to this problem. I am using Windows XP, IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create a
database connection I get the "Your PHP server doesn't have the MySQL module
loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe I
have already made the required changes to the php.ini file however this may
not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

On which server are ou configuring it??

I've got the same problem on IIS if you have so I can help you.

[Schmalz]

Yes, I am using IIS as well. Any advice would be welcome.

<uk******@gmail.comwrote in message
news:11**********************@d34g2000cwd.googlegr oups.com...

>
Schmalz napisal(a):

>Hi all. Probably not an original posting but I have searched high and
low
for a satisfactory resolution to this problem. I am using Windows XP,
IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create
a
database connection I get the "Your PHP server doesn't have the MySQL
module
loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe
I
have already made the required changes to the php.ini file however this
may
not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

On which server are ou configuring it??

I've got the same problem on IIS if you have so I can help you.

[Schmalz]

Hi,

I have done that now. What specifically should I be looking for? Let me
know what particular information I need and I will tell you what it says.

Thanks.

"Johnny" <re*****************@hotmail.comwrote in message
news:htTSg.463$UJ2.162@fed1read07...

>
"Schmalz" <gp****@hotmail.comwrote in message
news:45**********************@un-2park-reader-01.sydney.pipenetworks.com.au.
..

>Hi all. Probably not an original posting but I have searched high and
low
for a satisfactory resolution to this problem. I am using Windows XP,
IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to create
a
database connection I get the "Your PHP server doesn't have the MySQL

module

>loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I believe

I

>have already made the required changes to the php.ini file however this

may

>not be 100% right. Any further advice and/or assistance would be greatly
appreciated.

make yourself a phpinfo.php file that has a call to phpinfo() and run that
to see what's loaded, what points to where, the dir of your ini file,
etc.,
etc.

[Schmalz]

Hi and thanks.

Anything specifically I should be looking for in the log etc?
"Jerry Stuckle" <js*******@attglobal.netwrote in message
news:Sq******************************@comcast.com. ..

Schmalz wrote:

>Hi all. Probably not an original posting but I have searched high and
low for a satisfactory resolution to this problem. I am using Windows
XP, IIS 5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to
create a database connection I get the "Your PHP server doesn't have the
MySQL module loaded or you can't use the mysql_(p)connect functions"
error. I have downloaded the latest mysqli and mysql extensions (PHP
5.1.6 and MySQL Server 5.0.24a) and copied these into my C:\PHP\ext
directory. I believe I have already made the required changes to the
php.ini file however this may not be 100% right. Any further advice
and/or assistance would be greatly appreciated.

Did you stop and restart your server?

For the mysql connections, you need the following in your php.ini file:

extension=php_mysql.dll

If you want to use mysqli, you need:

extension=php_mysqli.dll

(you can specify both).

And watch for any errors when you start your server. Check your server
log to see if there are any errors, also.

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

[Jerry Stuckle]

Schmalz wrote:

"Jerry Stuckle" <js*******@attglobal.netwrote in message
news:Sq******************************@comcast.com. ..

>>Schmalz wrote:

>>>Hi all. Probably not an original posting but I have searched high and
low for a satisfactory resolution to this problem. I am using Windows
XP, IIS 5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to
create a database connection I get the "Your PHP server doesn't have the
MySQL module loaded or you can't use the mysql_(p)connect functions"
error. I have downloaded the latest mysqli and mysql extensions (PHP
5.1.6 and MySQL Server 5.0.24a) and copied these into my C:\PHP\ext
directory. I believe I have already made the required changes to the
php.ini file however this may not be 100% right. Any further advice
and/or assistance would be greatly appreciated.

Did you stop and restart your server?

For the mysql connections, you need the following in your php.ini file:

extension=php_mysql.dll

If you want to use mysqli, you need:

extension=php_mysqli.dll

(you can specify both).

And watch for any errors when you start your server. Check your server
log to see if there are any errors, also.

Hi and thanks.

Anything specifically I should be looking for in the log etc?

(top posting fixed)

Anything unusual, that's all. There are a lot of different warnings or
errors which may cause a problem like this.

And BTW - please don't top post. Thanks.

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

[Johnny]

"Schmalz" <gp****@hotmail.comwrote in message
news:45**********************@un-2park-reader-01.sydney.pipenetworks.com.au.
...

"Johnny" <re*****************@hotmail.comwrote in message
news:htTSg.463$UJ2.162@fed1read07...

"Schmalz" <gp****@hotmail.comwrote in message

news:45**********************@un-2park-reader-01.sydney.pipenetworks.com.au.

..

Hi all. Probably not an original posting but I have searched high and
low
for a satisfactory resolution to this problem. I am using Windows XP,
IIS
5.1, PHP 5.1.4 and MySQL 5.0.23 and Dreamweaver 8. When I try to

create

a
database connection I get the "Your PHP server doesn't have the MySQL

module

loaded or you can't use the mysql_(p)connect functions" error. I have
downloaded the latest mysqli and mysql extensions (PHP 5.1.6 and MySQL
Server 5.0.24a) and copied these into my C:\PHP\ext directory. I

believe

I

have already made the required changes to the php.ini file however this

may

not be 100% right. Any further advice and/or assistance would be

greatly

appreciated.

make yourself a phpinfo.php file that has a call to phpinfo() and run

that

to see what's loaded, what points to where, the dir of your ini file,
etc.,
etc.

Hi,

I have done that now. What specifically should I be looking for? Let me
know what particular information I need and I will tell you what it says.

Thanks.

At the top there'll be an entry:
Configuration File (php.ini) Path

Under php core there'll be an entry:
extension_dir

check they all point where you think they should, that is that you are using
the ini file you think you are and that your extensions are coming from the
right directory (you think it's C:\PHP\ext but what does php think it is?),
etc.

Then scroll down, there are module enries in alphabetical order, see if you
can see an entry for MySql.

If there's not one there MySql isn't loaded (but you knew that already right
;-) which could be for any one of a number of reasons.

If it's the right extensions directory and PHP is reading the correct ini
file that you modified then perhaps you haven't done all the things they say
here http://us3.php.net/manual/en/ref.mysql.php under PHP 5+

I note that it says "The supporting DLLs for the PHP 5 extensions are also
not in a seperate directory." in the manual install instructions so you may
want to check where php_mysql.dll is and also libmysql.dll (this should be
either in the windows system dir [not recommended] or the PATH variable
should have an enry that points to where it is).

You may also want to set
display_startup_errors = On

in the ini file until you have finished debugging, so you can see any errors
that occur on start up.

Good luck.