PHP - mysqli_connect doesn't exist but mysqli is enabled?

Splenden · 01-10-2007, 10:13 PM

Hi,

I apologize for asking so many questions on this board. Hopefully soon I can gain a little knowledge and start helping others :-)

I have PHP 5 (latest version available as of today) set up 5.2.0 set up with Apache 2.2. I'm trying to install something which requires MySQL support, but it says there is no MySQLi support, and I compiled with MySQLi.

My phpinfo says the following:

MysqlI Support enabled
Client API library version 4.1.13
Client API header version 4.1.13
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off

But, for some reason, the mysqli_connect function does not exist.

Thanks!

Splenden

Splenden · 01-12-2007, 11:31 AM

I was able to fix this myself. In case someone else has the issue, here's the answer:

For some reason, when I installed PHP with MySQL, the php.ini didn't load the extension mysqli.so. I recompiled everything by that time with mysql and mysqli, plus a bit more. So I added "extension mysqli.so" (without the quotes) on its own line to the php.ini file and all was fine.

yifangt · 04-23-2012, 10:39 PM

It seems the "mysqli_connect()" function is not there or not working properly. When change

Code:

mysqli_connect("localhost", "username", "password", "database")

to

Code:

mysqli("localhost", "username", "password", "database")

then it is working fine. Can anybody explain?
Thanks!