469,645 Members | 1,984 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Connect to MySQL Database using PHP

Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');

$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>

When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.

Thanks very much for your help and I look forward to hearing from you
in the near future.

May 7 '07 #1
9 2897
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');

$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>

When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.

Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:

<?php
phpinfo();
?>

May 7 '07 #2
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:


Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.

Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:

<?php
phpinfo();
?>- Hide quoted text -

- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.

May 7 '07 #3
ch***************@yahoo.co.uk wrote:
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
>On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:


>>Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:

<?php
phpinfo();
?>- Hide quoted text -

- Show quoted text -

Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,

Does phpinfo() have a mysql section? It will have items like:

Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external

and so on.

Your symptom is indicates that the mysql extension is not loaded in php.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
May 7 '07 #4
On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
>Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:
<?php
phpinfo();
?>- Hide quoted text -
- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.

Christopher,

Does phpinfo() have a mysql section? It will have items like:

Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external

and so on.

Your symptom is indicates that the mysql extension is not loaded in php.

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

- Show quoted text -
Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.

Thanks very much for your help in this matter

May 7 '07 #5
ch***************@yahoo.co.uk wrote:
On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
>christopher_bo...@yahoo.co.uk wrote:
>>On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:
<?php
phpinfo();
?>- Hide quoted text -
- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,

Does phpinfo() have a mysql section? It will have items like:

Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external

and so on.

Your symptom is indicates that the mysql extension is not loaded in php.

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

- Show quoted text -

Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.

Thanks very much for your help in this matter
Check the php.ini( find path with phpinfo()
find and replace for php_mysql.dll
make sure it is enable

example:
with ";" in front of the extention is disable
;extension=php_msql.dll ( disable)
extension=php_mysql.dll ( enable )
hope it work
May 7 '07 #6
ch***************@yahoo.co.uk wrote:
On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
>christopher_bo...@yahoo.co.uk wrote:
>>On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:
<?php
phpinfo();
?>- Hide quoted text -
- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,

Does phpinfo() have a mysql section? It will have items like:

Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external

and so on.

Your symptom is indicates that the mysql extension is not loaded in php.

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

- Show quoted text -

Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.

Thanks very much for your help in this matter
OK, then the MySQL extension is not loaded. You need to add it in your
php.ini file.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
May 7 '07 #7
On 7 May, 23:38, Daniele <"dankan775{["@]}yahoo.itwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');
$dbname = 'pmoneytest';
mysql_select_db($dbname);
?>
When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.
Thanks very much for your help and I look forward to hearing from you
in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:
<?php
phpinfo();
?>- Hide quoted text -
- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,
Does phpinfo() have a mysql section? It will have items like:
Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external
and so on.
Your symptom is indicates that the mysql extension is not loaded in php.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================- Hide quoted text -
- Show quoted text -
Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.
Thanks very much for your help in this matter

Check the php.ini( find path with phpinfo()
find and replace for php_mysql.dll
make sure it is enable

example:
with ";" in front of the extention is disable
;extension=php_msql.dll ( disable)
extension=php_mysql.dll ( enable )

hope it work- Hide quoted text -

- Show quoted text -
Hi. I have enabled extension=php_mysql.dll and when I go onto
phpinfo(); it then comes up with an error that says

PHP Warning: PHP Startup: Unable to load dynamic library './
php_msql.dll' - The specified module could not be found. in Unknown on
line 0 PHP Warning: PHP Startup: Unable to load dynamic library './
php_mysql.dll' - The specified module could not be found. in Unknown
on line 0.

What can I try now

May 9 '07 #8
ch***************@yahoo.co.uk wrote:
On 7 May, 23:38, Daniele <"dankan775{["@]}yahoo.itwrote:
>christopher_bo...@yahoo.co.uk wrote:
>>On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
>On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
>>Hi all. I am trying to connect to a MySQL Database using PHP on a
>>local machine using locahost. I am using the following code
>><?php
>>$dbhost = 'localhost';
>>$dbuser = 'root';
>>$dbpass = 'password';
>>$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
>>die ('Error connecting to mysql');
>>$dbname = 'pmoneytest';
>>mysql_select_db($dbname);
>>?>
>>When I view the page it then comes up with an error that says
>>PHP Fatal error: Call to undefined function mysql_connect() in C:
>>\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
>>the problem is as I got the code from the Internet and it seems to be
>>the same on all the different website that I look at.
>>Thanks very much for your help and I look forward to hearing from you
>>in the near future.
>Make sure that you've enabled the MySQL extension in php.ini. You can
>check this by running the following script and examining the output:
><?php
>phpinfo();
>?>- Hide quoted text -
>- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,
Does phpinfo() have a mysql section? It will have items like:
Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external
and so on.
Your symptom is indicates that the mysql extension is not loaded in php.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================- Hide quoted text -
- Show quoted text -
Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.
Thanks very much for your help in this matter
Check the php.ini( find path with phpinfo()
find and replace for php_mysql.dll
make sure it is enable

example:
with ";" in front of the extention is disable
;extension=php_msql.dll ( disable)
extension=php_mysql.dll ( enable )

hope it work- Hide quoted text -

- Show quoted text -

Hi. I have enabled extension=php_mysql.dll and when I go onto
phpinfo(); it then comes up with an error that says

PHP Warning: PHP Startup: Unable to load dynamic library './
php_msql.dll' - The specified module could not be found. in Unknown on
line 0 PHP Warning: PHP Startup: Unable to load dynamic library './
php_mysql.dll' - The specified module could not be found. in Unknown
on line 0.

What can I try now
Do you have the libmysql.dll installed in a directory in your PATH
statement?

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

Jerry Stuckle wrote:
ch***************@yahoo.co.uk wrote:
On 7 May, 23:38, Daniele <"dankan775{["@]}yahoo.itwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 23:14, Jerry Stuckle <jstuck...@attglobal.netwrote:
christopher_bo...@yahoo.co.uk wrote:
On 7 May, 21:11, ZeldorBlat <zeldorb...@gmail.comwrote:
On May 7, 3:59 pm, christopher_bo...@yahoo.co.uk wrote:
>Hi all. I am trying to connect to a MySQL Database using PHP on a
>local machine using locahost. I am using the following code
><?php
>$dbhost = 'localhost';
>$dbuser = 'root';
>$dbpass = 'password';
>$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
>die ('Error connecting to mysql');
>$dbname = 'pmoneytest';
>mysql_select_db($dbname);
>?>
>When I view the page it then comes up with an error that says
>PHP Fatal error: Call to undefined function mysql_connect() in C:
>\Inetpub\wwwroot\PHPTest\connection.php on line 6. I can't see what
>the problem is as I got the code from the Internet and it seems to be
>the same on all the different website that I look at.
>Thanks very much for your help and I look forward to hearing from you
>in the near future.
Make sure that you've enabled the MySQL extension in php.ini. You can
check this by running the following script and examining the output:
<?php
phpinfo();
?>- Hide quoted text -
- Show quoted text -
Hi. I have checked the phpinfo(); and MySQL seems to be ok as it is
pointing to where the server is installed. But the internet page still
doesn't work. Is there anything else that I can try.
Christopher,
Does phpinfo() have a mysql section? It will have items like:
Active Persistent Links 0
Active Links 0
Client API version 5.0.32
MYSQL_MODULE_TYPE external
and so on.
Your symptom is indicates that the mysql extension is not loaded in php.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================- Hide quoted text -
- Show quoted text -
Hi. There isn't actually heading called MySQL but it does have Active
Persistent Links 0. The things that you mentioned are not
shown in phpinfo();.
Thanks very much for your help in this matter
Check the php.ini( find path with phpinfo()
find and replace for php_mysql.dll
make sure it is enable

example:
with ";" in front of the extention is disable
;extension=php_msql.dll ( disable)
extension=php_mysql.dll ( enable )

hope it work- Hide quoted text -

- Show quoted text -
Hi. I have enabled extension=php_mysql.dll and when I go onto
phpinfo(); it then comes up with an error that says

PHP Warning: PHP Startup: Unable to load dynamic library './
php_msql.dll' - The specified module could not be found. in Unknown on
line 0 PHP Warning: PHP Startup: Unable to load dynamic library './
php_mysql.dll' - The specified module could not be found. in Unknown
on line 0.

What can I try now

Do you have the libmysql.dll installed in a directory in your PATH
statement?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Hi. I have managed to get it working. The problem was that I had to
copy the dll files that were in a zip file to the root of the php
program folder.

May 9 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Mr Dygi | last post: by
6 posts views Thread by Eric W. Holzapfel | last post: by
7 posts views Thread by atlasyeo | last post: by
4 posts views Thread by bettina | last post: by
5 posts views Thread by news.telia.net | last post: by
2 posts views Thread by Martin | last post: by
nathj
10 posts views Thread by nathj | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.