Trouble connecting to the mysql

Website URL: ebenezer.000.pe

(please specify the URL of the site on which you are experiencing the problem)

Error Message: No error message, the browser just has a blank screen, I am sending input data by way of the POST method to the director which I have temporarily copied the connect into. Here is what I get when I list the resulting source code:

Free Bible Studies And, Here is what I have entered for the connect data: $servername = "sql213.infinityfree.com"; $username = "if0_35279171"; $password = "More than one password tried!"; $database = "if0_35279171_ebenezer";

(please share the FULL error message you see, if applicable)
None given, see above

Other Information

I have run this entire program on my own server, and it does fine, Please help me get connected to the sql?
(other information and details relevant to your question)

Can you try enabling display errors through cpanel->alter php config?

7 Likes

Ok, did that now I’m getting something, but don’t know what it means exactly.
Here’s what I got:

Fatal error: Uncaught Error: Class “mysqli_connect” not found in /home/vol10_3/infinityfree.com/if0_35279171/htdocs/director.php:16 Stack trace: #0 {main} thrown in /home/vol10_3/infinityfree.com/if0_35279171/htdocs/director.php on line 16

I edited line 16 in my php code that read:
$con=new mysqli_connect($servername,$username,$password,$database);
to:
$con = new mysqli($servername,$username,$password,$database);
but it keeps coming back with the same error:
Uncaught Error: Class “mysqli_connect”
eventhough the _connect is not even in the code anymore!

1 Like

Did you save the modified file?

1 Like

It appears to still be in the code:

This is a screenshot from the director.php code, around line 16, which the error message also refers to.

Please choose for yourself whether you want to use MySQLi in procedural style or object oriented style. It’s completely your choice.

6 Likes

ok, I think i have that fixed, but where do I go from here?
I changed:
$con = new mysqli_connect($servername,$username,$password,$database);
to:
$con = new mysqli($servername,$username,$password,$database);
And I’m now getting this error:

Fatal error: Uncaught mysqli_sql_exception: Access denied for user ‘if0_35279171’@‘192.168.0.42’ (using password: YES) in /home/vol10_3/infinityfree.com/if0_35279171/htdocs/director.php:16 Stack trace: #0 /home/vol10_3/infinityfree.com/if0_35279171/htdocs/director.php(16): mysqli->__construct(‘sql213.infinity…’, ‘if0_35279171’, Object(SensitiveParameterValue), ‘if0_35279171_eb…’) #1 {main} thrown in /home/vol10_3/infinityfree.com/if0_35279171/htdocs/director.php on line 16

Make sure the passwird is correct.

3 Likes

I am thinking you must have a time with people like me, (I’m just learning), now I am down to where it is complaining about line 26 where I am trying to select the table to look at inside the database. I am thinking that I might be able to handle this one though…
Wish me luck, and I’ll let you know.

FYI: With MySQLi, you already need to specify the database name when making the connection, so you don’t need to select the database afterwards like you may be used to with the old mysql_ style API. So you can probably just remove that call entirely.

6 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.