Can't connect to database "Fatal error: Call to undefind function mysqli_connect()"

Question

I've been scouring this site for 5 hours now trying to get this sorted, I rarely ask for help but this is one of the weirdest and most annoying things I've encountered.

First of all I'd like to say that this DID work fine, I have limited examples of what the cause is but I'll list them anyway.

Here's the full error message:

Fatal error: Call to undefind function mysqli_connect() in C:\wamp\www\game\connect.php on line 3

And here's the code

<?php
// Create connection
$con=mysqli_connect("localhost","root","","game");

// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


$select_db = mysqli_select_db($con, 'game');
if (!$select_db){
die("Database Selection Failed" . mysql_error());
}
?>

Weird thing is, it was working completely fine and just suddenly stopped, this has happened more than once.

Here's what I've tried:

Checking the extensions are enabled - Rebooting various times - Setting the correct php path - Using many example codes that "work" -

I also had some code that inputted data straight from phpdesigner into the database, which successfully worked, but that no longer works and I've made literally 0 changes.

The last time it stopped working, I filled out a registration form on my site as a test (that doesn't work either) and it suddenly went off. When filling in the form I click register and nothing happens besides a refresh.

Bit extra: In my httpd file the pfp and pfpinidir are as follows

php5_module"c:/wamp/bin/php/php5.5.12/php5apache2_4.dll"

PHPIniDir "C:\wamp\bin\apache\apache2.4.9\bin\php.ini"

Answer 1

Your mysqli extension might not be enabled. so u need to enable that.

You have two PHP binaries on your machine. One is connected to the Apache, and is the one u use when you surf to a web page. The phpinfo() shows you which php.ini file is used by the web php binary. u need to edit this file and in it activate the mysqli extension

Answer 2

You're trying to connect to DB twice, plus you're mixing MySQL APIs with mysql_error(), they do not mix together.

The 4th parameter is the DB name which is what you've done in the first example.

Use either:

<?php
// Create connection
$con=mysqli_connect("localhost","root","","game");

// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

?>

or omit ,"game" from mysqli_connect() - while mysqli_error() requires DB connection parameter.

<?php
// Create connection
$con=mysqli_connect("localhost","root","");

// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


$select_db = mysqli_select_db($con, 'game');
if (!$select_db){
die("Database Selection Failed" . mysqli_error($con));
}
?>