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 stackoverflow.com/questions/25281467/… — ᴄʀᴏᴢᴇᴛ
– ᴄʀᴏᴢᴇᴛ, Commented Feb 24, 2017 at 10:58
looks to me the MySQLi php library is not enabled.. check it with <?php phpinfo(); ?> — Raymond Nijland
– Raymond Nijland, Commented Feb 24, 2017 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
– seherez, Commented Feb 24, 2017 at 11:08
You just have to remove ; from php.ini extension=php_mysqli.dll and ofcource restart apache — Shishil Patel
– Shishil Patel, Commented Feb 24, 2017 at 11:12

Ian · Accepted Answer · 2017-02-24 15:15:22Z

1

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

edited Feb 24, 2017 at 15:15

Ian

3,7064 gold badges32 silver badges50 bronze badges

answered Feb 24, 2017 at 12:50

stren-12

572 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related