Re: Are there plans to support Mysql 5 soon?
| From: | Holografix | Date: | Fri, 28 Oct 2005 00:55:00 +0000 |
| Subject: | Re: Are there plans to support Mysql 5 soon? | ||
| References: | 1 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-19770@lists.php.net to get a copy of this message | ||
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