phpデータベースの2つの操作方法

MySQLとMySQLの接続:

 static function util(){
        $conn = mysql_connect("localhost","root","root") or die("        ！");
        if($conn)
            echo "       "."
";
        else
            echo "    ".mysql_error($conn);
        mysql_select_db('mydb') or die("        ！");
        echo "       "."
";
        mysql_query("set names utf-8");
        return $conn;
    }

>       ：mysql_query（）（  ->：：           ）

取得したデータを巡回します.

 function listData($data=null){
        echo "<table><tr><td>idtd><td>  td><td>  td><td>  td><td>    td><td>  td><td>  td><td>    td><td>    td>tr>";
        while ($row = mysql_fetch_row($data,MYSQL_ASSOC)){
            echo "<tr><td>{$row['id']}td>".
                "<td>{$row['name']}td>".
                "<td>{$row['phone']}td>".
                "<td>{$row['pass']}td>".
                "<td>{$row['logo']}td>".
                "<td>{$row['money']}td>".
                "<td>{$row['status']}td>".
                "<td>{$row['isvalid']}td>".
                "<td>{$row['date']}td>tr>";
        }
        echo "table>";
    }

PDO-MySQL:データベースへの接続:

$dbhost = 'localhost:3306';  // mysql       
$dbuser = 'root';            // mysql   
$dbpass = '123456';          // mysql     
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
    die('Could not connect: ' . mysqli_error());
}
echo '       ！';
mysqli_close($conn);

 static function connect(){
        $dbms = 'mysql';
        $dbName = 'mydb';
        $user = 'root';
        $pwd = 'root';
        $host = 'localhost';
        $dsn = "$dbms:host=$host;dbname=$dbName";
        try{
            $pdo = new PDO($dsn,$user,$pwd);
            echo "PDO  MySQL  ";
            return $pdo;
        }catch (Exception $e){
            echo $e->getMessage().'
';
        }
    }

パス方法:

function listData($stmt){
        echo "<table><tr><td>idtd><td>  td><td>  td><td>  td><td>    td><td>  td><td>  td><td>    td><td>    td>tr>";
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
            echo "<tr><td>{$row['id']}td>".
                "<td>{$row['name']}td>".
                "<td>{$row['phone']}td>".
                "<td>{$row['pass']}td>".
                "<td>{$row['logo']}td>".
                "<td>{$row['money']}td>".
                "<td>{$row['status']}td>".
                "<td>{$row['isvalid']}td>".
                "<td>{$row['date']}td>tr>";
        }
        echo "table>";
    }