PHP - 指定端口设置的MySQL连接

Question

I've got my own DB.php and it was working before I changed the MySQL Port to something else other than 3306 which is default. It fails to connect now; I've configured the DB.php after port change like below :

class DB {
//    server    
    private $host = "192.168.1.15";
    private $uname = "user";
    private $pw = "iamuser";
    private $dbname = "matlab";
    private $con = null;
    private $port = "669";

public function __construct() {
        $this->con = mysql_connect($this->host,$this->port, $this->uname, $this->pw);
        if (!$this->con) {
            $this->db_error("Cannot connect to DBMS");
        }
        mysql_query("SET NAMES 'latin5'", $this->con);
        mysql_query("SET CHARACTER SET 'latin5'", $this->con);
        mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'", $this->con);
        mysql_select_db($this->dbname, $this->con) or db_error("Can not connect to Database");
    }

Can anyone tell me how I can make it work with the port number 669 again? Thanks.

Answer 1

The Fix:

You are passing wrong parameter to mysql_connect function, port is not a separate parameter. First parameter accept values as [hostname:port]. So it should be:

mysql_connect($this->host.':'.$this->port, $this->uname, $this->pw);

Reference:

http://php.net/manual/en/function.mysql-connect.php

P.S.

Note: MySQL library is deprecated please use MySQLi or PDO instead