473,382 Members | 1,571 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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 9563

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: AMC | last post by:
Hi, I'm using an include file to store the connection string to a database. Whenever I try to reference that string to open a connection in the page that includes the file I get the error 'empy...
14
by: Jim Sabatke | last post by:
When I installed MySQL (SuSE 9.0) and first started it, it told me that I needed to set a password for machine.domain.name. I tried following the directions, but it would only setup a password...
1
by: JackM | last post by:
Just wondering... I have a script running that accesses a mysql database on a shared server. Suddenly the log in and password that have worked for months are being rejected since yesterday. On...
1
by: Israel | last post by:
I'm running into this problem where my database connection seems to get disconnected by something unknown to me. My server is running locally so any network problems shouldn't have any affect on...
3
by: Ted | last post by:
In WSAT, I get the following error when trying to set up my provider: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site...
0
by: Bruno Barberi Gnecco | last post by:
I'm using stored procedures in a PHP site, with mysql. I'm having problems with stored procedures. Of the two I'm using, one works all the time, consistently. The other works correctly, but the...
3
by: tulika dutta | last post by:
after 8 hrs my MySQL connection with JDBC gets time out. It gives the error java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying...
2
by: aidanhaylock | last post by:
Morning, This one is really driving me insane. I am developing a site for a client who doesn't particularly want to move their hosting away from their current provider. The current host are...
5
by: xoise | last post by:
Warning: mysql_connect() : Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /webs/sites/monetized.com/includes/mysql_connect.inc.php on line 2 Lost...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.