> anyway mysql_connect() won't work in php5 - although I do believe it's
> possible to compile in the 'old' mysql lib yourself.
No, PHP5 does indeed have some new (and different) functions for mysql,
but it supports (properly, nothing old about it) the normal mysql
functions as well. The change for PHP5 is that it no longer enables
mysql functions by default (you need to now compile it with
--with-mysql), and it no longer bundles the client libraries.
- MySQL support. There has been some confusion with regards to the
disabling of MySQL by default in PHP 5. This simply means that in
order to use MySQL you must explictly use --with-mysql just like
you do with most every other extension. Also, the client libraries
are no longer bundled, this means you must use your MySQL sources
instead of optionally using the version that comes with PHP 4.
People can still use --with-mysql[=DIR], this move isn't a big deal.
The reason for this action is three-fold:
- MySQL 3 (which is bundled in PHP 4) : This bundled library
was no longer properly maintained.
- MySQL 4 (never bundled) : Is GPL, so doesn't fit with the PHP
- PHP is attempting to bundle less third party libraries.
- Also listed in the following faq:
( That link doesn't work for me, without some help:
I have to admit to not understanding exactly why mysqli functions
would be available when mysql functions aren't - seems fundamentally
wrong, unless they're somehow using a library that the php developers
themselves are actively maintaining, or someone else is maintaining and
releasing under a compatible license. Given their statement is they're
trying to bundle fewer third party libraries, that's all I can see.
The new functions for mysql are meant to be used with mysql 4.1.3+ only,
and they have some neat new things like bind variables. I can't speak
as to whether one would gain performance from using mysqli_query over
mysql_query (though I would hope one wouldn't lose it!).
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php