PHP 连接 mysql 基本操作

<?php
    /connect db
     $conn = @mysql_connect("localhost","root","root") or die("数据库错误");
    if(!$conn)
    {
     die('could not connect:'.mysql_error());
    }
    ///if exist drop///
    if(mysql_query("exist users"))
    {
    //    mysql_query("drop database users");
    }
    else
    {
        mysql_query("drop database users");
    }
    ///create db///
    if(mysql_query("CREATE DATABASE users",$conn))
    {
        echo "database users created"."<br />";
        mysql_select_db("users",$conn);
    //create table/            
        $sql = "CREATE TABLE persons
            (
            pid int not null auto_increment,
            primary key(pid),
            name varchar(255),
            pwd varchar(255),
            age int
            )";
        mysql_query($sql,$conn);
    ///insert 
        for($i = 0 ; $i <=10; $i++)
        {
        $user = "user".$i;
        mysql_query("insert into persons (name,pwd,age)
                values('$user','mima','$i')");
        }
        //mysql_query("insert into persons (name ,pwd,age)
        //        values('user2','mima','20')");
    /read //
        mysql_select_db("users",$conn);
        $result = mysql_query("select * from persons");
        if(is_resource($result))
        {
            echo "<table border ='1'>
            <tr>
            <th>id</th>
            <th>name</th>
            <th>pwd</th>
            <th>age</th>
            </tr>";
            while($row = mysql_fetch_array($result))
            {
//                echo $row['pid']." ".$row['name']." ".$row['pwd'];
//                echo "<br />";
                echo "<tr>";
                echo "<td>".$row['pid']."</td>";
                echo "<td>".$row['name']."</td>";
                echo "<td>".$row['pwd']."</td>";
                echo "<td>".$row['age']."</td>";
                echo "</tr>";
            }
            echo "</table>";
        }
        else
        {
            die( "Error reading db:no result "."<br />");
        }
        
    }
    else
    {
        die("Error creating database:".mysql_error()."<br />");
    }

    mysql_close($conn);

?>