PHP学习之Mysql

<?php
 $host = "localhost";  
    $user = "root";  
    $pass = "root";  
    $db = "users";  
    //创建一个mysql连接  
    $connection = mysql_connect($host, $user, $pass) or die("Unable to connect!");  
    mysql_query("set names 'utf8'");
    //选择一个数据库  
    mysql_select_db($db) or die("Unable to select database!");  
    //查
    $query = "SELECT * FROM user";   
    //执行SQL语句  
    $result = mysql_query($query) or die("Error in query: $query. ".mysql_error()); 


    if(mysql_num_rows($result)>0){
    while($row=mysql_fetch_row($result)){  
          print_r($row);
        }  
    }
    //插入数据
    $sql = "insert into user (id,name,age,sex) values ('