php 连接 mysql 代码

   (1)$username='root';
        $userpass='123';
        $dbhost='127.0.0.1'; //不能加3306
        $dbdatabase='subscribe';
        $dsn='mysql:host='.$dbhost.';dbname='.$dbdatabase.';';
        $dbh=new PDO($dsn,$username,$userpass);
        $dbh->query('set names utf8;');
        // $sql = "insert into subscribe values(2,'123456','7','1','453566')";
        // $dbh -> exec($sql);
        $stmt = $dbh->prepare("SELECT * FROM subscribe");
        $stmt->execute();
        $allrows = $stmt->fetchAll(PDO::FETCH_ASSOC);       //以关联下标从结果集中获取所有数据
        print_r($allrows);


   (2)$dbhost = "127.0.0.1:3306";
        $username = 'root';
        $userpass = '123';
        $dbdatabase = 'subscribe';
        $db_connect= mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");
        mysql_select_db($dbdatabase,$db_connect);
        $result=mysql_query("SELECT * FROM subscribe");
        $row=mysql_fetch_array($result);
        var_dump($row);exit;