无法使用PHP脚本连接到本地托管的mysql

我正在尝试构建一个自托管的PHP站点，但是从我的PHP脚本连接到数据库时遇到了问题.

I am trying to build a self-hosted PHP site, but I am having trouble connecting to the database from my PHP script.

请注意以下内容

1).这段代码使我可以从总站毫无问题地连接到MAMP，因此我知道MySQL可以正常工作等

1). This code allows me to connect to MAMP from my * without problem so I know MySQL is working etc

mysql --host=127.0.0.1 --port=8889 --user=root -p 

2)当我尝试在远程托管平台上构建站点时，此代码允许我从php脚本连接到删除服务器上的MySQL，因此我知道此代码本身没有什么问题，但是它在我的计算机上无法正常工作.

2) When I tried to build a site on a remote hosted platform, this code allowed me to connect from my php script to MySQL on the remove server, so I know there is nothing wrong with this code per se, but it didn't work on my computer.

defined('DB_SERVER') ? null : define("DB_SERVER","host");
defined('DB_USER') ? null : define("DB_USER","username");
defined('DB_PASS') ? null : define("DB_PASS","password");
defined('DB_NAME') ? null : define("DB_NAME","photo_gallery");

3我已经能够在计算机上运行一个自托管的wordpress网站，但是我没有为此建立数据库连接(它在代码中的某个位置)，所以我没有做错什么.可通过以下路径访问该站点. http://localhost:8888/wordpress/，即使它已连接到端口8889(根据mysql)

3 I have been able to run a self-hosted wordpress site on my computer, but I didn't establish the database connection for that (it's somewhere in the code) so I don't what I'm doing wrong. That site is accessible at the following path. http://localhost:8888/wordpress/ even though it is connected at port 8889 (according to mysql)

4 MAMP告诉我可以使用这种格式从自己的脚本连接到数据库

4 MAMP tells me that I can connect to the database from my own scripts using this format

Host    localhost
Port    8889
User    root
Password    root

因此，我添加了这一行

defined('DB_PORT') ? null : define("DB_PORT","8889");

像这样

defined('DB_SERVER') ? null : define("DB_SERVER","host");
    **defined('DB_PORT') ? null : define("DB_PORT","8889");**
    defined('DB_USER') ? null : define("DB_USER","username");
    defined('DB_PASS') ? null : define("DB_PASS","password");
    defined('DB_NAME') ? null : define("DB_NAME","photo_gallery");

但是它仍然没有用.当我尝试测试数据库连接时，被告知数据库连接失败.

but it still didn't work. I'm being told database connection fails when I try to test it.

有什么想法吗?

编辑.我试图将端口放置在localhost旁边，但是它不起作用.

EDIT. I tried to put the port next to the localhost but it's not working.

defined('DB_SERVER') ? null : define("DB_SERVER","localhost:8889");
defined('DB_USER') ? null : define("DB_USER","root");
defined('DB_PASS') ? null : define("DB_PASS","root");
defined('DB_NAME') ? null : define("DB_NAME","photo_gallery");

编辑.上面的代码在config.php中，该文件已包含在database.php中.

EDIT. The above code was in the config.php which was included into the database.php which is this

<?php 

require_once("config.php");

class MySQLDatabase {

    private $connection;

    function __construct(){
        $this->open_connection();
    }

    public function open_connection(){
        $this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
    if(!$connection){
        die("Database connection failed:" . mysql_error());
        } else {
        $db_select = mysql_select_db(DB_NAME, $this->connection);
        if (!$db_select) {
            die("Database selection failed: " . mysql_error());
        }
        }
    }

    public function close_connection(){

        if(isset($this->connection)){
            mysql_close($this->connection);
            unset($this->connection);
        }
    }


    public function query($sql) {
    $result = mysql_query($sql, $this->connection);
    $this->confirm_query($result);
        return $result;
    }

    public function mysql_prep( $value ) {
        $magic_quotes_active = get_magic_quotes_gpc();
        $new_enough_php = function_exists( "mysql_real_escape_string" ); // i.e. PHP >= v4.3.0
        if( $new_enough_php ) { // PHP v4.3.0 or higher
            // undo any magic quote effects so mysql_real_escape_string can do the work
            if( $magic_quotes_active ) { $value = stripslashes( $value ); }
            $value = mysql_real_escape_string( $value );
        } else { // before PHP v4.3.0
            // if magic quotes aren't already on then add slashes manually
            if( !$magic_quotes_active ) { $value = addslashes( $value ); }
            // if magic quotes are active, then the slashes already exist
        }
        return $value;
    }

    private function confirm_query($result){
        if(!$result){
            die("Database query failed:" . mysql_error());
        }
    }

}


$database = new MySQLDatabase();


?>