Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:19770
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Message-ID: <89.20.22886.5C671634@pb1.pair.com>
To: internals@lists.php.net
References: <12.DE.22886.21BBF534@pb1.pair.com>
Date: Fri, 28 Oct 2005 01:55:00 +0100
Lines: 136
Subject: Re: Are there plans to support Mysql 5 soon?
From: holografix@gmail.com ("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"" <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