This Weird Error With MySQL and PHP

[ksportal]

Okay so I have a website and I have a website I am working on I’d give you all the URL, but I am trying to keep it private(ish) for now. I have no issues on the locally hosted, it works great. But not on infinity free hosting.

Fatal error: Uncaught Error: Call to a member function bind_param() on bool in /home/vol2_8/infinityfree.com/if0_34940695/htdocs/submit_post_community.php:70 Stack trace: #0 {main} thrown in /home/vol2_8/infinityfree.com/if0_34940695/htdocs/submit_post_community.php on line 70

I don’t think it’s an issue with the database, or is it? I get an error 59 or something if I have wrong details or the database doesn’t exist.

[ChrisPAR]

@ksportal

I don’t think it’s an issue with the database, or is it?

Looking up the error message, a connection issue cannot be thrown out as it occurs when prepare returns false.

Check if there’s a possibility of any of the issues here affecting the connection:

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…

Going on a hunch since you’ve transferred from localhost, I’m suspecting this:

@Admin

Make sure you are using the right database hostname (not localhost)

Most hosting providers use localhost for the database hostname. This does not work for InfinityFree. The database hostname should look like sql123.epizy.com. You can find your database hostname in your control panel in the MySQL Databases section.

[Admin]

@ksportal

Call to a member function bind_param() on bool

I agree with @ChrisPAR that it’s a database problem. But I suspect it’s a problem with your query, not the connection, as you wouldn’t be able to create a prepared statement if there was no connection.

So I suspect that your database connection is fine, but MySQL is rejecting the query you’ve provided, which is why mysqli_prepare or mysqli_stmt_prepare is returning false, which is why you get the “on bool” error.

This post may give you some ideas on how to handle the error reporting for this: php - MySQLi prepared statements error reporting - Stack Overflow