PHP + MySQL

[Anon]

Hi,

I've installed MySQL and PHP3 and apace and now i want to access my database made in mySQL. If i use a MySQL client and connect to the MySQL server i can see my database and browse through it. But now if i want to see the database via a webpage using php3 i get the following error:
"Fatal error: Call to unsupported or undefined function mysql_connect() in /home/httpd/html/db.php3 on line 9"

How does this come? to me it looks like php doens't even knows the command mysql_connect()

line 9 of the db.php3 file is simply: mysql_connect();

i haven't filled in my user and password and host because i've filled that already in in the php3.ini file.

What am i doing wrong? how to solve this?

thanks,

Harm de Vries

[Anon]

The problem is that you need to have PHP compiled with mysql support. If the parser doesn't recognize the connect command, you don't have support compiled in. You'll have to recompile PHP for this!

go into the PHP directory (where the source is) and issue the following commands:

make clean (make distclean if you really want to start over)
./configure --help (read the instructions closely so you can compile PHP with the right set of options!)
./configure --with-your-options --with-mysql
-- note : PHP4 comes bundled with a mysql library, so it will probably work with your version of mysql without adding =/path/to/mysql/libraries

make
make install (must be run as root)

and restart the apache server, all should be well.

HTH,

AC

[Anon]

Hi Adam-

I came across your reply to this message on PHP and MySQL. I was having the same error as the gentleman you replied to. When I tried the steps you suggested to get the mysql_connect() function working, however, it didn't seem to work. I did all the steps you outline in your message (except "make distclean" - I just did "make clean). My configure seemed to go fine, as did the make, make install, and httpd restart steps. But when I tried to use my page, I got the "Fatal error: Call to unsupported or undefined function mysql_connect()."

Do you have any idea why this might be occurring? I'm running the latest version of PHP (just compiled it a few months ago), on a new Linux system, as a CGI, with Apache. Frankly, the only of those parameters that should matter is the version of PHP, and it's certainly new enough to support MySQL functions.

Thanks in advance for any help you can give.

--David
[e-mail]