RE: PHP £ Mysql

harris · Guest

Hi,
I started my apache server with the PHPs modules loded
and I also installed the php3-mysql1_3.0-1.deb pakage for PHP3 to support mysql. The problem is the PHP always complains sth like:"Call to unsupported or undefined function mysql_connect()" when I load the phtml page.
Can anyone help me on that?

Thanks

Simon · Guest

Basically you need to load the module manually, in PHP3.INC or compile it in from the outset.

I took the latter choice as so much of my site is MySQL based.

I haven't seen the .deb for it (FreeBSD for real work + Win95 for offline dev) . Basically you'll either need to find / the module or recompile with MySQL enabled + therefore built-in.

I know the latter sounds a little messy but it is preferable.

If you use the module you have to have mod_so for Apache and have the compiled MySQL so.

To insert it automatically (so it's always available) you'll also have to edit php3.ini (wherever you put it). Failing that it's manual load - which is extremely messly.

Given a little time to spend on the thing (I take it this is mission critical to you) compile it into php from the start. If you're only after getting MySQL and PHP to work there are example simple instructions in both the Apache & PHP docs. If you're going much past that it starts (rapidly) to become a headache. You'll also need a pre-installed with the libs etc version of MySQL.

I know the compile it in option may well sound like a nightmare but it's not all that bad. Just read the docs and it's easily do-able. You're only likely to encounter headaches if you try something fancy (too me ages to do mine - Apache, mod_ssleay, PHP, mod_mysql).

I can't recomment the last optional enough. mod_mysql gives you .htaccess through a MySQL database. It's superb!!!