mysqli problem

[waynew]

I've decided to start using mysqli. I've been trying to create myself a class, yet for some reason, its telling me that it cant connect to my database.

 

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'localhost:8080' (11004) in C:\Program Files\Apache Group\Apache2\htdocs\CommonCode\PHP Classes\db.class.php on line 14

 

Warning: Database::__construct() [database.--construct]: Couldn't fetch mysqli in C:\Program Files\Apache Group\Apache2\htdocs\CommonCode\PHP Classes\db.class.php on line 15

 

Warning: mysqli::query() [mysqli.query]: Couldn't fetch mysqli in C:\Program Files\Apache Group\Apache2\htdocs\CommonCode\PHP Classes\db.class.php on line 16

 

As you might imagine, I didn't get very far with this class:

 

<?php

class Database{

private $socket = "localhost:8080";
private $pass = "";
private $user = "root";
private $database = "43hsyejsm";
private $mysqli = NULL;

function __construct(){
	$mysqli = new mysqli($this->socket,$this->user,$this->pass,$this->database);
	echo $mysqli->error;
	$query = $mysqli->query("SELECT id FROM indigo_user_details LIMIT 1", MYSQLI_STORE_RESULT);

}

}

?>

 

 

[waynew]

Bump. For great justice.

[waynew]

Btw, the query you see inside the constructor is only me testing.

[waynew]

Another bump. Board is fast tonight.

[waynew]

Bump now because I'm off to bed. If you're wondering, my MySQL is on localhost:8080. 100% sure of that.

[DarkWater]

I'd be willing to bet that MySQL is not on port 8080.  3306 is the default, and you can leave it off. Just saw your post.  And you're 100% sure it's on port 8080? >_<  Can you connect to it with like, phpMyAdmin or anything?

[wildteen88]

Try leaving of the the port number. I think you're confusing MySQL with your http server. HTTP servers (such as Apache or IIS) usually run on port 80 and sometimes port 8080. MySQL on the other hand runs on port 3306.

 

When leaving of the port PHP will by default try port 3306.

[Mchl]

mysqli::__construct  ([ string $host  [, string $username  [, string $passwd  [, string $dbname  [, int $port  [, string $socket  ]]]]]] )

 

Whatever your port is, you pass it as fifth parameter, not in the first one.

 

 

[DarkWater]

I didn't know that, because mysqli_connect() (the non-oop one) takes a string formatted like host:port as the $host parameter (I happened to look it up instead of the constructor by accident and didn't realize it. xD)

[Mchl]

I didn't know that, because mysqli_connect() (the non-oop one) takes a string formatted like host:port as the $host parameter

 

That's mysql_connect(), not even part of mysqli

[DarkWater]

That's SO weird.  http://www.php.net/mysqli_connect links to mysql_connect().  Sorry about the confusion, I'll report that bug to php.net soon. >_<  That REALLY threw me off, good catch.

[Mchl]

Yeah. They messed up on this url.

[DarkWater]

I've personally never used mysqli_connect() (I've used the OOP one plenty of times though, except I've always used the default port), so I didn't notice the error on the link.  Sorry about any confusion. >_<  I wonder why that glitch even exists...and it's weird because http://us2.php.net/manual/en/mysqli.connect.php links to the correct function.  Why the . in between the two parts of the name instead of an underscore?  Meh.

[waynew]

mysqli::__construct  ([ string $host  [, string $username  [, string $passwd  [, string $dbname  [, int $port  [, string $socket  ]]]]]] )

 

Whatever your port is, you pass it as fifth parameter, not in the first one.

 

 

 

Thanks. Worked. You see, my Apache is on localhost, port 80, and my MySQL is on localhost, port 8080. I had specifically set it to that.

[Mchl]

Any specific reason for that?