Can't connect to mysql server

[Pr0t0n]

Hey guys,

 

I am having problems when I started a class for mysql queries, and I am trying to connect in the __construct() but it doesnt matter how many diffrent servers I try it won't freaking connect PLEASE HELP lol.

 

Code is below:

function __construct() {
       
    $db 	= new mysqli($db_login_cred);
//    $db_conn	= mysqli_connect() or die(mysqli_error($db));
 
 if (mysqli_connect_error()) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}

echo 'Success... ' . $db->host_info . "\n";
    
/*
    if(isset($db_conn)) {
	echo "Verbinding met de MySQL backend tot stand gebracht.";
    } else {
	echo "Kan de MySQL-backend niet bereiken.<br /><br />
	      Foutmelding:<br />"
	     .$error = $db_conn->mysqli_connect_error()
	     .$error;
    }
*/

There's some of my own code which is commented out in a try to use standard code from php.net to see if I made a typo or whatever.

 

 

I will keep this page open so if u need additional info I can supply it fast hopefully.

 

if u also want to see the output: http://odins.co.nf/

[Barand]

your credentials need to to be four separate string values

$db = new mysqli(HOST,USERNAME,PASSWORD,DATABASE);

[Pr0t0n]

I know why you're saying that but I came from four credentials and kept adding to be sure hes not using a wrong setting.

 

See this: http://nl3.php.net/manual/en/mysqli.construct.php and scroll to "Parameters" u will see all the parameters u can add to it.

[Pr0t0n]

Solved it, it seems the variable for the credentials wasnt passed to the __construct()