Posted by Bruce Douglas on 02/05/05 19:38

disregard if you've already done this...

you might want to do a quick php app with phpinfo, to determine if/what version of mysql php sees.. it's quite possible that php isn't seeing/interfacing with mysql.

php needs to not only be built with a version of mysql, but the php.ini file also needs to be setup correctly.

-bruce


-----Original Message-----
From: Jochem Maas <jochem@iamjochem.com>
Sent: Feb 5, 2005 8:46 AM
To: Sarah <weregirl@vitamortalis.org>
Cc: php-general@lists.php.net
Subject: Re: [PHP] Problems with PHP and MySQL

Sarah wrote:
> Hi,
>
> I'm relatively new to PHP, but have already written a few functional
> web-based scripts. I recently decided to implement a MySQL-based system,
> but hit the following problem...
>
> I have PHP version 5.03, and MySQL v 4.19. I downloaded and compiled
> both, and both work perfectly alone. However, when I run a command-line
> app to manipulate my database, I get the following error:
>
> __________________________________________________________________________
> veep@tinsel:~# ./useradmin -a -u unclebulgaria -p uberwomble
> constructor called
>
> Fatal error: Call to undefined function mysql_connect() in
> veep/useradmin on line 16
>
> Fatal error: Call to undefined function mysql_close() in /veep/useradmin
> on line 22
> veep@tinsel:~#
> __________________________________________________________________________
>

I _think_, given the version of MySQL you are using, you should compile in
and use the mysqli extension iso of the mysql extension.
^----!

these to links may help you:

http://www.zend.com/php5/articles/php5-mysqli.php
http://be.php.net/mysqli

failing that you might want to check this page for an overview of funcs you
can use to determine exactly what is available, with more accuracy than phpinfo()
e.g.:

var_dump( extension_loaded("mysql"),
extension_loaded("mysqli"),
get_loaded_extensions(),
get_extension_funcs ("mysql"),
get_extension_funcs ("mysqli") );

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

[Back to original message]