Undefined function mysqli_connect() when try to connect to mysql database why?

Question

I have this PHP code:

define('DB_SERVER', 'localhost:3306');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'viadonau');
define('DB_DATABASE', 'vinoservice');
echo DB_SERVER ;
echo DB_USERNAME;
echo DB_PASSWORD;
echo DB_DATABASE;
$link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

I alway get a fatal error and i dont know why....on mysql workbench i can connect to the database...and in PHPStorm i can also configure the data source and i can run a query but in php i cant connect. Thanks for help!!!

the error seems to say that the mysqli extension is not installed/activated see http://stackoverflow.com/questions/25281467/fatal-error-call-to-undefined-function-mysqli-connect?rq=1 — ᴄʀᴏᴢᴇᴛ, Feb 24 '17 at 10:58
looks to me the MySQLi php library is not enabled.. check it with `` — Raymond Nijland, Feb 24 '17 at 10:58
I add these two lines but not working yet :S : extension=php_mysqli.dll extension=C:\Utils\php\ext\php_mysqli.dll — seherez, Feb 24 '17 at 11:08
You just have to remove ; from php.ini `extension=php_mysqli.dll` and ofcource restart apache — Shishil Patel, Feb 24 '17 at 11:12

score 1 · Answer 1 · edited Feb 24 '17 at 15:15

If you create a new PHP file and add the following to it, it should show if MySQLi is enabled or not.

<?php phpinfo(); ?>

If you don't have MySQLi then it will show up with no mysqli

If you do have it, it will show mysqli

You can install the MySQLi extension through terminal by using the following, if on PHP5

apt-get install php5-mysqli

However if you use php 7 use

apt-get install php7.0-mysqli

Undefined function mysqli_connect() when try to connect to mysql database why?

1 Answers1