php之mysql扩展库方式连接数据库

create table user(
id int primary key not null,
name varchar(32) not null,
password varchar(64) not null,
email varchar(128) not null,
age tinyint unsigned not null
);

alter table user change id id int(11) not null auto_increment;
alter table user change id id int(11) auto_increment;

insert into user(name,password,email,age) values('zs',md5('123456'),'zs@souhu.com',30);
insert into user(name,password,email,age) values('ls',md5('123456'),'ls@souhu.com',40);
insert into user(name,password,email,age) values('ww',md5('123456'),'ww@souhu.com',50);
insert into user(name,password,email,age) values('单凯',md5('123456'),'sk@souhu.com',21);

<?php
    //利用mysql扩展库连接数据库
    //获取链接
    $conn=mysql_connect("localhost","root","955219");
    if(!$conn)
    {
        //显示错误信息
        die("连接数据库失败".mysql_error());
    }
    else 
    {
        echo "成功<br/>";
    }
    //选择数据库
    mysql_select_db("practice");
    //设置字符集
    mysql_query("set name utf8");
    //发送sql语句
    $sql="select * from user";
    $res=mysql_query($sql,$conn);
    //接收结果并处理
    var_dump($res);
//     mysql_free_result($res);
    mysql_close($conn);
    while($row=mysql_fetch_row($res))
    {
        echo "<br/>";
        var_dump($row);
        echo "<br/>";
//         echo "$row[0]------$row[1]------$row[2]";
        foreach ($row as $key=>$val)
        {
            echo "------$val";
        }
    }
    //释放链接，关闭资源
    //释放结果集
    mysql_free_result($res);
    //关闭连接（这句话可以没有，没有什么用，写这句话之后链接也不是马上关闭的）
    //mysql_close($conn);
?>