Re: MySQL5 & PHP5

From: Andy Hassall (andy_at_andyh.co.uk)
Date: 12/03/04 

Date: Fri, 03 Dec 2004 22:24:14 +0000

On Thu, 02 Dec 2004 18:58:24 -0500, Sarah Tanembaum <sarahtanembaum@yahoo.com>
wrote:

>Hi Andy, I did replace c:\php5\libmysql.dll with
>c:\mysql5\lib\opt\libmysql.dll, restart the apache2, and check again.
>Unfortunately, nothing change, it still say 3.23.57.

 See my other message in reply to Tony Reed - unless you recompile PHP, you
have to stick with the bundled 3.23.57 library.

>Perhaps I need newer c:\php5\ext\php_mysql.dll for mysql5. Where can I
>get the binaries for php5/mysql5 dlls?

 Not so much newer, but just recompiled against a later MySQL version. Maybe
you could search Google.

 Having said all this, there's still the question whether running with a
3.23.57 client actually makes any difference - you won't get any new features
with a new client library. Maybe there's bug fixes or performance issues. Don't
know.

>How do you use mysqli anyway? Is it not compatible with the mysql version?

 See http://php.net/mysqli. The mysql extension doesn't support any new
features past 3.2. If you want to use some of the new MySQL features, you use
mysqli. 

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Relevant Pages

  • RE: Postgres, MySQL, and Firebird.
    ... Well since I neglected to mention what those features are I guess I ... MySQL doesn't support subselects which will come in very handy for many ... Firebird has them. ... It's threading model seems better than Postgres. ...
    (RedHat)
  • Re: PostgreSQL or MySQL ?
    ... I'm not going to argue that PostgreSQL isn't superior technology, ... This is the case for MySQL now too. ... MySQL 5.0 supports these features in its ... so old that MySQL has discontinued support for them. ...
    (comp.databases)
  • Re: OT - Re: IS it possible to connect to a MySQL database in asp?
    ... > what rdbms features doesn't it have? ... For the free/unrestricted versions of MySQL, ... failover/clustering support ...
    (microsoft.public.inetserver.asp.db)
  • Re: PostgreSQL or MySQL ?
    ... This is the case for MySQL now too. ... it's true that the syntax diagrams cover only ... MySQL 5.0 supports these features in its ... so old that MySQL has discontinued support for them. ...
    (comp.databases)
  • Updating PHP and MySQL on Raq2
    ... Anyone know of any guides to recompile php and mysql for the raq2? ...
    (comp.sys.sun.admin)