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

Question

// 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数据库的呢？

Answer 1

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 前面的分号，并且重启服务