No mysql when running phpinfo.PHP???

[Patrick]

Hi

I am a newbie and was just getting started working on a guestbook
tutorial when I got an error message upon running my PHP code:

Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\h tdocs\add.php on line 6

So I searched the web for hours trying stuff to no avail. I think
something needs to be copied/pasted from a directory to another or
something needs to be enabled in php.INI. But what?

When I run localhost/phpinfo.PHP there is no mention of Mysql, I know
it should be in there.

I am running Windows XP pro/Apache server/PHP 5/Mysql.
Mysql works fine at the prompt, I create, delete tables and databases
at will.

One more point I do have the libMySQL.dll in C:\WINDOWS\SYST EM32.

I hope someone can help me

Thanks a lot

Patrick

[Tony Marston]

You have to enable the mysql extension in your php.ini file. Seek out the
entry which says ';extension=php _mysqli.dll' and remove the leading
semi-colon.

--
Tony Marston

http://www.tonymarston.net

"Patrick" <va******@netze ro.net> wrote in message
news:a3******** *************** ***@posting.goo gle.com...

Hi

I am a newbie and was just getting started working on a guestbook
tutorial when I got an error message upon running my PHP code:

Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\h tdocs\add.php on line 6

So I searched the web for hours trying stuff to no avail. I think
something needs to be copied/pasted from a directory to another or
something needs to be enabled in php.INI. But what?

When I run localhost/phpinfo.PHP there is no mention of Mysql, I know
it should be in there.

I am running Windows XP pro/Apache server/PHP 5/Mysql.
Mysql works fine at the prompt, I create, delete tables and databases
at will.

One more point I do have the libMySQL.dll in C:\WINDOWS\SYST EM32.

I hope someone can help me

Thanks a lot

Patrick

[zergchen]

there looks has some problems for PHP5 work with MYSQL. I still have
the same problem about the PHP5. try PHP4 first.
I tried PHP4, and it working stable.

[Tony Marston]

I am using PHP 5.0.2 with MySQL 4.1.7 and Apache 2.0.52 on a Windows XP PC
without any problem. The MySQL client shows up as 4.1.3-beta.

--
Tony Marston

http://www.tonymarston.net

<ze******@gmail .com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

there looks has some problems for PHP5 work with MYSQL. I still have
the same problem about the PHP5. try PHP4 first.
I tried PHP4, and it working stable.

[varois83]

Tony Marston wrote:

You have to enable the mysql extension in your php.ini file. Seek out the entry which says ';extension=php _mysqli.dll' and remove the leading
semi-colon.

Tony

First-off thanks for taking the time to help, I really appreciate it.
The extension you mention isn't in my php.ini file and I checked both
since I have a "php.ini" in the C:Windows and another called
"php.ini-recommended" in the PHP 5 folder.
They appear identical. Here is pasted the extension section of the
php.ini file located in C:windows:

<Pasted starts>

;;;;;;;;;;;;;;; ;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;; ;;;;;;;
;
; If you wish to have an extension loaded automatically, use the
following
; syntax:
;
; extension=modul ename.extension
;
; For example, on Windows:
;
; extension=msql. dll
;
; ... or under UNIX:
;
; extension=msql. so
;
; Note that it should be the name of the module only; no directory
information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.
;Windows Extensions
;Note that ODBC support is built in, so no dll is needed for it.
;

;extension=php_ bz2.dll
;extension=php_ cpdf.dll
;extension=php_ curl.dll
;extension=php_ dba.dll
;extension=php_ dbase.dll
;extension=php_ dbx.dll
;extension=php_ exif.dll
;extension=php_ fdf.dll
;extension=php_ filepro.dll
;extension=php_ gd2.dll
;extension=php_ gettext.dll
;extension=php_ iconv.dll
;extension=php_ ifx.dll
;extension=php_ iisfunc.dll
;extension=php_ imap.dll
;extension=php_ interbase.dll
;extension=php_ ldap.dll
;extension=php_ mbstring.dll
;extension=php_ mcrypt.dll
;extension=php_ mhash.dll
;extension=php_ mime_magic.dll
;extension=php_ ming.dll
;extension=php_ mssql.dll
;extension=php_ msql.dll
;extension=php_ mysql.dll
;extension=php_ oci8.dll
;extension=php_ openssl.dll
;extension=php_ oracle.dll
;extension=php_ pdf.dll
;extension=php_ pgsql.dll
;extension=php_ shmop.dll
;extension=php_ snmp.dll
;extension=php_ sockets.dll
;extension=php_ sybase_ct.dll
;extension=php_ tidy.dll
;extension=php_ w32api.dll
;extension=php_ xmlrpc.dll
;extension=php_ xsl.dll
;extension=php_ yaz.dll
;extension=php_ zip.dll

<Pasted ends>

I have tried several goofy things as sometimes it's like the lotto you
get lucky, but to no avail.

What I tried:

-I tried to change "extension=php_ mysql.dll" to
"extension=php_ mysqli.dll" with semi-colon removed, restarted apache
got error message saying unable to start dynamic library.
-Went into my PHP 5 folder and copied the "libmysqli. dll" file to
C:windows/system32, restarted apache got error message. Left the
"libmysqli. dll" in system 32 and added "extension=php_ mysqli.dll" to
php.ini, restarted apache, error message again.

I hope the kind help keeps on coming, I think I am close.
Thanks again

Patrick

[varois83]

Hi again

This is the original poster again. I was just searching the web for
help on my problem (I must be on 5 hours on this now!) and something
keeps on poping up here and there but I don't know how to implement it
if that's my solution.
It seems the dynamic extension section of the "php.ini" file needs a
line like the following:

extension_dir=" C:\PHP5\ext\"

My php.ini doesn't have one. Could that be it? I saw it mentionned
twice in answers to poster's problems on various forums.

My php extensions folder directory is:

C:\php-5.0.0-Win32\ext

I of course tried several of those "extension_ dir" lines to no avail
after restarting Apache.

Thanks again

Patrick

[Tony Reed]

On Mon, 6 Dec 2004 18:12:34 -0000
"Tony Marston" <to**@NOSPAM.de mon.co.uk> wrote:

:I am using PHP 5.0.2 with MySQL 4.1.7 and Apache 2.0.52 on a Windows XP PC
:without any problem. The MySQL client shows up as 4.1.3-beta.

I'd be interested in knowing what packages you down-loaded, and what
install "method" you followed, i.e. did you add PHP and MySQL to your
PATH environment, or move the *.dll files around?

I have the same setup on an older NT 4 machine, and my client shows in
php_info() as 3.23.57. This doesn't affect any of the stuff I use the
setup for, but it's a mystery. There was a thread about this very
subject last week. I have a feeling that the .dll that comes with PHP
is "at fault" in my case, since mysql reports it's sever version as
4.1.7. I'm wondering if perhaps I shouldn't down-load and install
another PHP package that might be up-to-date.

I have the same setup on my OS X machine, and there, I get the same
results you do, but in that case, I compiled PHP (and Apache).

--
Tony Reed
<tr***@altern.o rg>

[Tony Marston]

Your PHP installation seems funny to me. I downloaded the zip package from
http://www.php.net/downloads.php, not the one with the msi installer as this
only gives you the cgi version of PHP. I suggest you use this to install a
*complete* version of PHP. Do not forget to read the contents of file
install.txt as this contains valuable information.

--
Tony Marston

http://www.tonymarston.net

"varois83" <va******@netze ro.net> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com...

Hi again

This is the original poster again. I was just searching the web for
help on my problem (I must be on 5 hours on this now!) and something
keeps on poping up here and there but I don't know how to implement it
if that's my solution.
It seems the dynamic extension section of the "php.ini" file needs a
line like the following:

extension_dir=" C:\PHP5\ext\"

My php.ini doesn't have one. Could that be it? I saw it mentionned
twice in answers to poster's problems on various forums.

My php extensions folder directory is:

C:\php-5.0.0-Win32\ext

I of course tried several of those "extension_ dir" lines to no avail
after restarting Apache.

Thanks again

Patrick

[Tony Marston]

"Tony Reed" <tr***@altern.o rg> wrote in message
news:Q5******** ************@ne ws20.bellglobal .com...

On Mon, 6 Dec 2004 18:12:34 -0000
"Tony Marston" <to**@NOSPAM.de mon.co.uk> wrote:

:I am using PHP 5.0.2 with MySQL 4.1.7 and Apache 2.0.52 on a Windows XP
PC
:without any problem. The MySQL client shows up as 4.1.3-beta.

I'd be interested in knowing what packages you down-loaded, and what
install "method" you followed, i.e. did you add PHP and MySQL to your
PATH environment, or move the *.dll files around?
(a) I used the full zip package.
(b) I added PHP and MySQL to my PATH environment variable.
I have the same setup on an older NT 4 machine, and my client shows in
php_info() as 3.23.57. This doesn't affect any of the stuff I use the
setup for, but it's a mystery. There was a thread about this very
subject last week. I have a feeling that the .dll that comes with PHP
is "at fault" in my case, since mysql reports it's sever version as
4.1.7. I'm wondering if perhaps I shouldn't down-load and install
another PHP package that might be up-to-date.
PHP 5 for windows comes with the new improved php_mysqli extension for
accessing MySQL client version 4.1.3 and above. Use this instead of the
original mysql extension.
I have the same setup on my OS X machine, and there, I get the same
results you do, but in that case, I compiled PHP (and Apache).

--
Tony Reed
<tr***@altern.o rg>

[lig]

varois83 wrote:

Tony Marston wrote:

You have to enable the mysql extension in your php.ini file. Seek

out the

entry which says ';extension=php _mysqli.dll' and remove the leading
semi-colon.
Tony

First-off thanks for taking the time to help, I really appreciate it.
The extension you mention isn't in my php.ini file and I checked both
since I have a "php.ini" in the C:Windows and another called
"php.ini-recommended" in the PHP 5 folder.
They appear identical. Here is pasted the extension section of the
php.ini file located in C:windows:

<Pasted starts>

;;;;;;;;;;;;;;; ;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;; ;;;;;;;
;
; If you wish to have an extension loaded automatically, use the
following
; syntax:
;
; extension=modul ename.extension
;
; For example, on Windows:
;
; extension=msql. dll
;
; ... or under UNIX:
;
; extension=msql. so
;
; Note that it should be the name of the module only; no directory
information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.
;Windows Extensions
;Note that ODBC support is built in, so no dll is needed for it.
;

;extension=php_ bz2.dll
;extension=php_ cpdf.dll
;extension=php_ curl.dll
;extension=php_ dba.dll
;extension=php_ dbase.dll
;extension=php_ dbx.dll
;extension=php_ exif.dll
;extension=php_ fdf.dll
;extension=php_ filepro.dll
;extension=php_ gd2.dll
;extension=php_ gettext.dll
;extension=php_ iconv.dll
;extension=php_ ifx.dll
;extension=php_ iisfunc.dll
;extension=php_ imap.dll
;extension=php_ interbase.dll
;extension=php_ ldap.dll
;extension=php_ mbstring.dll
;extension=php_ mcrypt.dll
;extension=php_ mhash.dll
;extension=php_ mime_magic.dll
;extension=php_ ming.dll
;extension=php_ mssql.dll
;extension=php_ msql.dll
;extension=php_ mysql.dll
;extension=php_ oci8.dll
;extension=php_ openssl.dll
;extension=php_ oracle.dll
;extension=php_ pdf.dll
;extension=php_ pgsql.dll
;extension=php_ shmop.dll
;extension=php_ snmp.dll
;extension=php_ sockets.dll
;extension=php_ sybase_ct.dll
;extension=php_ tidy.dll
;extension=php_ w32api.dll
;extension=php_ xmlrpc.dll
;extension=php_ xsl.dll
;extension=php_ yaz.dll
;extension=php_ zip.dll

<Pasted ends>

I have tried several goofy things as sometimes it's like the lotto

you get lucky, but to no avail.

What I tried:

-I tried to change "extension=php_ mysql.dll" to
"extension=php_ mysqli.dll" with semi-colon removed, restarted apache
got error message saying unable to start dynamic library.
-Went into my PHP 5 folder and copied the "libmysqli. dll" file to
C:windows/system32, restarted apache got error message. Left the
"libmysqli. dll" in system 32 and added "extension=php_ mysqli.dll" to
php.ini, restarted apache, error message again.

I hope the kind help keeps on coming, I think I am close.
Thanks again

Patrick

Please see http://www.php.net/manual/en/install...extensions.php.
Note in the PHP extension table php_mysql.dll and php_mysqli.dll that
they require an additional library to be installed - "PHP >= 5.0.0,
requires libmysql.dll (bundled)"