Fatal error: Uncaught mysqli_sql_exception

[Tech_Penguin]

Website URL

https://internet-diving.infinityfreeapp.com/

Error Message

Fatal error : Uncaught mysqli_sql_exception

Other Information

The error reads:

Fatal error: Uncaught mysqli_sql_exception: Connection refused in /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php:10 Stack trace: #0 /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php(10): mysqli->__construct('127.0.0.1', 'fighter', Object(SensitiveParameterValue), 'fighter') #1 {main} thrown in /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php on line 10

Line 10 currently reads

$mysqli = new mysqli($servername, $username, $password, $database);

I have tried replacing the details with the actual details. But I always come back to this

[Greenreader9]

Show the values you are entering for everything except password

[KangJL]

There you have it

@Tech_Penguin

'127.0.0.1', 'fighter', Object(SensitiveParameterValue)

Please read

Common MySQL Connection Errors

Many websites use MySQL databases to store information and settings. However, there are some reasons why the connection to the database may fail. This article describes some commonly seen error messages when connecting to a database, as well as some general tips to keep in mind when setting up a database connection. Common Error Messages Using MySQL is great, but the error message returned if there is an issue logging in to your database can be quite confusing. Here are some commonly seen error…

[Tech_Penguin]

@Tech_Penguin

Object(SensitiveParameterValue)

I have tried this, and get the below error instead

Fatal error : Uncaught mysqli_sql_exception: Connection refused in /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php:10 Stack trace: #0 /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php(10): mysqli->__construct(‘127.0.0.1’, ‘fighter’, Object(SensitiveParameterValue), ‘fighter’) #1 {main} thrown in /home/vol7_3/infinityfree.com/if0_36011463/htdocs/index.php on line 10

[Admin]

The error clearly shows that the database hostname and username are incorrect. Maybe the password is too, but we can’t tell.

Please make sure to use the right connection settings for your database. You can find them on the MySQL Databases pages for your account in the client area.

[Tech_Penguin]

Well, it’s the only database in phpmyadmin

Unless it’s because nowhere in the code does it say which table the data is meant to go into

[Admin]

@Tech_Penguin

Well, it’s the only database in phpmyadmin

Again:

@Admin

The error clearly shows that the database hostname and username are incorrect. Maybe the password is too, but we can’t tell.

Of course the database works in phpMyAdmin. That’s because phpMyAdmin uses the correct connection settings. Your code very clearly does not.

---

In case it’s not clear:

@Tech_Penguin

mysqli->__construct(‘127.0.0.1’, ‘fighter’, Object(SensitiveParameterValue), ‘fighter’)

This tells me you are using the database hostname 127.0.0.1, username fighter and database name fighter. All of those cannot be correct. Please check the client area for the right settings to use.