469,353 Members | 2,041 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,353 developers. It's quick & easy.

Connection problems - PHP MySQL

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.
Sep 28 '06 #1
8 9350

"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.

Sep 28 '06 #2
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
==================
Sep 28 '06 #3

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.

Sep 28 '06 #4
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.

Sep 29 '06 #5
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.

Sep 29 '06 #6
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
==================

Sep 29 '06 #7
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
==================
Sep 29 '06 #8

"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.

Oct 1 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Jim Sabatke | last post: by
1 post views Thread by JackM | last post: by
1 post views Thread by Israel | last post: by
reply views Thread by Bruno Barberi Gnecco | last post: by
3 posts views Thread by tulika dutta | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.