PHP 使用 PDO 连接数据库

$mysql_conf = array(
        'host'    => '47.103.124.141',       //连接地址
        'db'      => 'scdd',                 //数据库名称
        'db_user' => 'scdd',                 //用户名
        'db_pwd'  => 'SePdY6MSZ74AD8mx',     //密码
    );
    $pdo = new PDO("mysql:host=" . $mysql_conf['host'] . ";dbname=" . $mysql_conf['db'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);//创建一个pdo对象
    $pdo->exec("set names 'utf8'");
    $sql = "select * from user";
    $data = $pdo->prepare($sql);
    $rs = $data->execute();
    if ($rs) {
        while ($row = $data->fetch(PDO::FETCH_ASSOC)) {
            print_r($row);
        }
    }else{
        echo '连接失败';
    }