PHP cannot access mySQL

PHP cannot access mySQL

am 01.11.2007 20:37:07 von le.nhan

Hi,
I have IIS 5.1 with PHP 5 and MySQL 4.1
With a client tool (such as MySQL Front) I can access MySQL. But my PHP page
cannot, with the same username and passord.
Why? What can I do?

Thanks
Nhan

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP cannot access mySQL

am 02.11.2007 00:36:14 von dmagick

Nhan wrote:
> Hi,
> I have IIS 5.1 with PHP 5 and MySQL 4.1
> With a client tool (such as MySQL Front) I can access MySQL. But my PHP page
> cannot, with the same username and passord.
> Why? What can I do?

What is the error message?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP cannot access mySQL

am 02.11.2007 11:44:33 von le.nhan

I can retrieve no errormessage. PHP script ran to the line, where connection
to MySQL is build. I think, I must setup the IIS so, that it error message
is displayed (???). With the following code is shown only the string "before
connecting".
How can I do?

My PHP code:

echo "
before connecting";

$link = mysql_connect(const_HOSTNAME, const_USERNAME, const_PASSWORD);
if (!$link)
die("no connection is possible...: " .mysql_error());


echo "
after link";
return;

"Chris" wrote in message
news:472A62EE.4070204@gmail.com...
> Nhan wrote:
>> Hi,
>> I have IIS 5.1 with PHP 5 and MySQL 4.1
>> With a client tool (such as MySQL Front) I can access MySQL. But my PHP
>> page cannot, with the same username and passord.
>> Why? What can I do?
>
> What is the error message?
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP cannot access mySQL

am 02.11.2007 11:56:02 von le.nhan

which cmmand tell PHP, that the script may ignore error and run further.?



"Chris" wrote in message
news:472A62EE.4070204@gmail.com...
> Nhan wrote:
>> Hi,
>> I have IIS 5.1 with PHP 5 and MySQL 4.1
>> With a client tool (such as MySQL Front) I can access MySQL. But my PHP
>> page cannot, with the same username and passord.
>> Why? What can I do?
>
> What is the error message?
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP cannot access mySQL

am 02.11.2007 12:04:03 von le.nhan

OK, now I have the errormessage:

Fatal error: Call to undefined function mysql_connect()

Why?

"Chris" wrote in message
news:472A62EE.4070204@gmail.com...
> Nhan wrote:
>> Hi,
>> I have IIS 5.1 with PHP 5 and MySQL 4.1
>> With a client tool (such as MySQL Front) I can access MySQL. But my PHP
>> page cannot, with the same username and passord.
>> Why? What can I do?
>
> What is the error message?
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP cannot access mySQL

am 02.11.2007 18:05:55 von niccguard-dev

--0-53843259-1194023155=:31597
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Is Mysql configured in PHP to be usable? Just having both installed isn't =
enough, there is configuration to 'enable' mysql. Try this link: http=
://www.php.net/manual/en/ref.mysql.php Based on the fact that it is sa=
ying mysql_connect() is undefined, I'd say that mysql functions aren't enab=
led/configured. Aaron =0A----- Original Message ----=0AFrom: Nhan=
=0ATo: php-db@lists.php.net=0ASent: Friday, November 2=
, 2007 5:04:03 AM=0ASubject: Re: [PHP-DB] PHP cannot access mySQL OK, =
now I have the errormessage: Fatal error: Call to undefined function=
mysql_connect() Why? "Chris" wrote in mess=
age =0Anews:472A62EE.4070204@gmail.com...=0A> Nhan wrote:=0A>> Hi,=0A>> I h=
ave IIS 5.1 with PHP 5 and MySQL 4.1=0A>> With a client tool (such as MySQ=
L Front) I can access MySQL. But my PHP =0A>> page cannot, with the same us=
ername and passord.=0A>> Why? What can I do?=0A>=0A> What is the error mess=
age?=0A>=0A> -- =0A> Postgresql & php tutorials=0A> http://www.designmagick=
..com/ -- =0APHP Database Mailing List (http://www.php.net/)=0ATo unsu=
bscribe, visit: http://www.php.net/unsub.php
--0-53843259-1194023155=:31597--

Re: PHP cannot access mySQL

am 03.11.2007 22:05:45 von le.nhan

OK, I have it.
I didn't install MySQL extension during installing.

Thanks
Nhan
""Nhan"" wrote in message
news:15.BE.02860.7EA2A274@pb1.pair.com...
> Hi,
> I have IIS 5.1 with PHP 5 and MySQL 4.1
> With a client tool (such as MySQL Front) I can access MySQL. But my PHP
> page cannot, with the same username and passord.
> Why? What can I do?
>
> Thanks
> Nhan

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php