链接mysql数据库代码如何改写呢?

// SQL server connection information
$sql_details = array(
    'user' => 'root',
    'pass' => 'root',
    'db'   => 'table_demo',
    'host' => 'localhost'
);
    static function sql_connect ( $sql_details )
    {
        try {
            $db = @new PDO(
                "mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
                $sql_details['user'],
                $sql_details['pass'],
                array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
            );
        }
        catch (PDOException $e) {
            self::fatal(
                "An error occurred while connecting to the database. ".
                "The error reported by the server was: ".$e->getMessage()
            );
        }

        return $db;
    }

以上链接SQL server数据库的代码,如何写成链接mysql数据库的呢?

static function sql_connect ( $sql_details )
    {
        try {
            $db = @new PDO("mysql:host=".$sql_details['host'].";port=".$sql_details['port'].";dbname=".$sql_details['db'].";charset=".$sql_details['charSet'];, $sql_details['user'],$sql_details['pass'],array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ));
        }
        catch (PDOException $e) {
            self::fatal(
                "An error occurred while connecting to the database. ".
                "The error reported by the server was: ".$e->getMessage()
            );

        }
        return $db;
    }

$sql_details = array(
        'user' => 'root',
        'pass' => 'root',
        'db'   => 'table_demo',
        'host' => 'localhost',
        'port' => 3306,
        'charSet' => 'utf8'
    );

试试看吧,要保证已经开启了PDO链接方式,就是到php.ini配置文件中 注销掉extension=php_pdo_mysql.dll 前面的分号,并且重启服务

这只是一个变量吧,存取对应数据库链接信息,改成你mysql对应的username、password、database和host就好了。

PDO 提供的是一个数据访问抽象层,不管使用哪种数据库,都可以用相同的函数(方法)来查询和获取数据。因此换个MySQL服务器的连接信息(数据库用户名、密码、端口、数据库名、服务器IP地址)就可以了。