Weird problem connecting to MySQL

[tupakapoor]

Hi,

I get the following error when trying to connect to mysql:

Fatal error: Call to undefined function mysqli_query() in /home/kapoora/public_html/dirtybirdreport.com/functions.php on line 10

I've seen in other posts that this function works for everyone else, so I'm not sure what the problem is. Here's my code (i included the text of a required file):

$host = 'mysql.x10hosting.com';
$port = 3306;
$username = XXX;
$pwd = XXX;
$db = XXX;

function dbConnect() {
    return mysqli_connect($host, $username, $pwd, $db, $port);
}

function dbQuery($query, $DBConn) {
// line 10-->    return mysqli_query($DBConn, $query);
}

function dbClose($DBConn) {
    mysqli_close($DBConn);
}

What am I doing wrong? TIA.

[bugfinder]

Im puzzled why you have mysqli_ why the i? perhaps this is what your problem stems from.. Im not sure the improved client is installed - you could check this of course with a phpinfo.

[tupakapoor]

Im puzzled why you have mysqli_ why the i? perhaps this is what your problem stems from.. Im not sure the improved client is installed - you could check this of course with a phpinfo.

ha - trying to run phpinfo throws a server 500 error. searching the forums for mysqli_query brings up a couple posts where someone was able to successfully use mysqli. oh well, guess i'll try regular old mysql.

[bugfinder]

Perhaps they have a different lvl of php to you - if you cant do a phpinfo, Im guessing either you have the basic one or you didnt quite type it right.

I agree try the more compatibile methods of mysql connection

[tupakapoor]

sigh...switched back to regular mysql commands and now i get "Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ". Anyone? Bueller?

[tupakapoor]

btw my site is fantasycentral.x10hosting.com

not dirtybirdreport.x10hosting.com as originally reported :hsughno:

[Starshine]

If you are on Absolut :

http://forums.x10hosting.com/server-...e-absolut.html

Well, looks like the database hard drive that we JUST GOT died.
"I apologize, but due to the amount of errors coming from the disk, it is almost definitely impossible to recover data from this drive. Even if one could recover data from this drive, the failure messages above indicate that data retrieved may be corrupted. We would recommend that your best course of action would be to have the disk replaced and then restore from any backups that you have taken.

Davy S.
SoftLayer CSA"

Problem after problem =\

We do have a backup of all the databases, I just need to figure out how we're going to fix this since they are mixed together with every other server.

[tupakapoor]

If you are on Absolut :

On cossacks. I'll stick to this thread, sorry.

[Corey]

Do you know if you ever upgraded to intermediate PHP?

[tupakapoor]

Do you know if you ever upgraded to intermediate PHP?

It says my upgrade is pending on the account page. Is there something I need to do on my end to complete this?


Edit:
just to add to this thread, when I go to Fantastico from cPanel it tells me that "Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance."

Perhaps there's a bigger problem here?