hi... after further reading/screams... it appears that only php-5.0.0 supports the "mysqli" interface. however, there appear to be numerous issues/problems with getting this up/running.
my setup. i have rh8.0 linux, with php-5.0.0 source. i'm trying to build from souce, to do the configure/make/make install. i have tried the following configure statements... they all seem to go through the process with no error.... ./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with -mysql=/usr --with-mysqli=/usr/bin/mysql_config --with-ldap --with-pgsql ./configure --with-config-file-path=/etc --with-mysql=/usr/local/mysql --w ith-mysqli=/usr/local/mysql/bin/mysql_config --with-apxs2=/usr/sbin/apxs --w ith-ldap --with-pgsql ./configure --disable-all --with-pcre-regex --with-config-file-path=/etc -- with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --with-apxs2=/usr/sbin/apxs --with-ldap --with-pgsql ./configure --with-config-file-path=/etc --with-mysql=/usr/local/mysql --w ith-mysqli=/usr/local/mysql/bin/mysql_config --with-ldap --with-pgsql after each configure step, i then did a "make clean", followed by a "make". never have been able to get the "make" to work... in fact it dies with the following errors... gcc -Iext/mysqli/ -I/usr/src/php-5.0.0/ext/mysqli/ -DPHP_ATOM_INC -I/usr/sr c/php-5.0.0/include -I/usr/src/php-5.0.0/main -I/usr/src/php-5.0.0 -I/usr/sr c/php-5.0.0/Zend -I/usr/include/libxml2 -I/usr/local/mysql/include -I/usr/s rc/php-5.0.0/TSRM -g -O2 -c /usr/src/php-5.0.0/ext/mysqli/mysqli.c -o ext/mysqli/mysqli.o && echo > ext/mysqli/mysqli.lo In file included from /usr/src/php-5.0.0/ext/mysqli/mysqli.c:31: /usr/src/php-5.0.0/ext/mysqli/php_mysqli.h:50: parse error before "MYSQL_STMT" /usr/src/php-5.0.0/ext/mysqli/php_mysqli.h:50: warning: no semicolon at end of struct or union /usr/src/php-5.0.0/ext/mysqli/php_mysqli.h:54: parse error before '}' token /usr/src/php-5.0.0/ext/mysqli/php_mysqli.h:54: warning: data definition has no type or storage class /usr/src/php-5.0.0/ext/mysqli/php_mysqli.h:116: parse error before '*' token /usr/src/php-5.0.0/ext/mysqli/mysqli.c:91: parse error before '*' token /usr/src/php-5.0.0/ext/mysqli/mysqli.c: In function `php_clear_stmt_bind': /usr/src/php-5.0.0/ext/mysqli/mysqli.c:93: `stmt' undeclared (first use in this function) /usr/src/php-5.0.0/ext/mysqli/mysqli.c:93: (Each undeclared identifier is reported only once /usr/src/php-5.0.0/ext/mysqli/mysqli.c:93: for each function it appears in.) /usr/src/php-5.0.0/ext/mysqli/mysqli.c: In function `mysqli_objects_free_storage': /usr/src/php-5.0.0/ext/mysqli/mysqli.c:145: parse error before ')' token /usr/src/php-5.0.0/ext/mysqli/mysqli.c: In function `zm_startup_mysqli': /usr/src/php-5.0.0/ext/mysqli/mysqli.c:445: `STMT_ATTR_UPDATE_MAX_LENGTH' undeclared (first use in this function) /usr/src/php-5.0.0/ext/mysqli/mysqli.c:495: `MYSQL_NO_DATA' undeclared (first use in this function) /usr/src/php-5.0.0/ext/mysqli/mysqli.c: In function `php_mysqli_fetch_into_hash': /usr/src/php-5.0.0/ext/mysqli/mysqli.c:604: `MYSQL_STMT' undeclared (first use in this function) /usr/src/php-5.0.0/ext/mysqli/mysqli.c:604: parse error before ')' token make: *** [ext/mysqli/mysqli.lo] Error 1 i've seen various issues relating to this on google, but no real solution.. any ideas/comments/pointers/etc.. i need to be able to do transactional processing which means i need to start looking at "mysqli" which means i need php-5.0.0!!! thanks -bruce -----Original Message----- From: bruce [mailto:[EMAIL PROTECTED] Sent: Saturday, July 17, 2004 1:12 PM To: [EMAIL PROTECTED] Subject: [PHP] building php to have mysqli support... hi... i'm trying to upgrade/install php-4.3.8 to include mysqli support. i'm running on a rh8.0 linux with mysql-4.x. i used the php-4.3.8 src rpm, and built using the following config ./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with -mysql --with-mysqli=/usr/bin/mysql_config --with-ldap --with-pgsql i then used the following commands.. make clean ./configure make make install everything seemed to go ok, as everything appeared to run to completion and i didn't see any errors... i do appear to have created a new libphp4.so.... however, when i look in the php-dist.ini it has no mention of "mysqli"... so my question, have i screwed up somewhere?? or am i just looking for the php.ini file in the wrong location. has anybody managed to get php to work so you can actually use both mysql/mysqli??? pointers/criticisms/assistance is greatly appreciated! searching through google/php.net/etc.. hasn't turned up information on where i've gone wrong. thanks.. -bruce -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php