PDO: Are there plans to support Mysql 5 soon?

Hi

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

What's the problem with MySQL 5 ?
Did you try ext/mysqli ( http://php.net/mysqli ) ?

--
Wbr,
Antony Dovgal

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

I use PDO with MySQL 5 every day. What's the problem?

--
Jasper Bryant-Greene
General Manager
Album Limited

e: jasper@album.co.nz
w: http://www.album.co.nz/
p: 0800 4 ALBUM (0800 425 286) or +64 21 232 3303
a: PO Box 579, Christchurch 8015, New Zealand

Hi

I am almost sure I read a message from Wez Furlong saying that pdo doesn't
actualy support mysql 5 sometime ago.
I will try it in a couple of hours. Now it's time to dinner and watch a
football game.
Thank you very much.

Best regards
holo

""Holografix"" holografix@gmail.com escreveu na mensagem
news:12.DE.22886.21BBF534@pb1.pair.com...

Hi

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

Best regards

Hi

I'm having this problems with php 5.1 latest snapshot and mysql 5.0.15 only
on linux FC4. On windows works fine.

This code:

$pdo = new PDO('mysql:host=localhost;dbname=dbtest', 'user', 'pass');
$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

$stmt = $pdo->prepare('select * from words limit 10');
$stmt->execute();

$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

or this code:

$pdo = new PDO('mysql:host=localhost;dbname=dbteste', 'root',
'solaris2002');
$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

$rows = array();
foreach ($pdo->query('select * from words limit 10') as $row) {
$rows[] = $row;
}

===> [Fri Oct 28 01:43:38 2005] [notice] child pid 1949 exit signal
Segmentation fault (11)

This code:

$link = mysqli_connect('localhost', 'user', 'pass', 'dbtest'); (line 5)

$res = mysqli_query($link, 'select * from words limit 1000');

$rows = array();
while ($row = mysqli_fetch_assoc($res)) {
$rows[] = $row;
}

or this code:

$link = new mysqli('localhost', 'user', 'pass', 'dbtest'); (line 5)

$res = $link->query('select * from words limit 10');

$rows = array();
while ($row = $res->fetch_assoc()) {
$rows[] = $row;
}

===> Fatal error: Trying to clone an uncloneable object of class mysqli in
/wwwroot/home/testes/php_my2.php on line 5

PHP Configure
./configure --prefix=/usr/local
--with-apxs2=/usr/local/apache2/bin/apxs
--enable-force-cgi-redirect
--enable-magic-quotes
--enable-memory-limit
--with-libxml-dir=/usr/local
--with-openssl=/usr/local/ssl
--with-zlib=/usr/local
--enable-calendar
--enable-mbstring
--enable-exif
--enable-ftp
--with-curl=/usr/local
--with-curlwrappers
--with-gd
--with-jpeg-dir=/usr/local
--with-png-dir=/usr/local
--with-zlib=/usr/local
--with-freetype-dir=/usr/local
--enable-gd-native-ttf
--with-imap=/usr/local
--with-imap-ssl=/usr/local/ssl
--with-mhash=/usr/local
--with-mcrypt=/usr/local
--with-mysql=/usr/local/mysql
--with-zlib-dir=/usr/local
--with-mysqli=/usr/local/mysql/bin/mysql_config
--with-pgsql=/usr/local
--enable-pdo=yes
--with-pdo-mysql=/usr/local/mysql
--with-pdo-pgsql=/usr/local/pgsql
--enable-simplexml
--with-libxml-dir=/usr/local
--with-xsl=/usr/local
--enable-soap
--with-libxml-dir=/usr/local
--with-dom=/usr/local
--with-zlib-dir=/usr/local
--with-iconv=/usr/local
--with-tidy=/usr/local
--enable-wddx
--with-xmlreader
--with-libxml-dir=/usr/local
--with-xmlrpc
--enable-sysvsem
--enable-sysvshm
--enable-sockets
--disable-debug \

Mysql Configure
./configure --prefix=/usr/local/mysql
--with-named-z-libs=/usr/local
--with-mysqld-user=mysql
--with-charset=latin1
--with-collation=latin1_general_ci
--enable-local-infile
--without-debug
--without-bench
--without-docs
--without-man \

mysql_xxxx functions works fine.

All of this samples works with php 5.1 and mysql 4.0.15 (linux).

Best regards

""Holografix"" holografix@gmail.com escreveu na mensagem
news:12.DE.22886.21BBF534@pb1.pair.com...

Hi

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

Best regards

Sorry
There are only problems with pdo

mysqli problems were due to zend.ze1_compatibility_mode = On. Now it's off
and no mysqli errors.

best regards

""Holografix"" holografix@gmail.com escreveu na mensagem
news:12.DE.22886.21BBF534@pb1.pair.com...

Hi

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

Best regards

Hi

Sorry to bother all of you with silly questions
I kept php.ini and my.cnf, deleted every single presence of php 5.1/mysql 5
files. Downloaded last snapshot, compile with same configure options and
everything is working fine. I can't figure out my mistake.
I apologize one more time.

best regards and have a nice weekend
holo

""Holografix"" holografix@gmail.com escreveu na mensagem
news:12.DE.22886.21BBF534@pb1.pair.com...

Hi

With PHP 5.1 knocking at the door, I guess many people would like to take
advantage og mysql 5 new features.

Best regards