[PHP-DEV] Re: Are there plans to support Mysql 5 soon?

[Holografix]

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"" <[EMAIL PROTECTED]> escreveu na mensagem 
news:[EMAIL PROTECTED]
> 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 

-- 
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php