<?php
    include_once("functions/database.php");
    $name = $_POST["name"];
    $password = $_POST["password"];    
    mysql_select_db("news");
//检测用户名是否存在
	$sql = "select * from users where name = '$name'";
    get_connection();
    $resultSet = mysql_query($sql);
    if (mysql_num_rows($resultSet) > 0) {
        exit("用户名已被占用，请更换其他用户名");
    }
//插入数据
    $password = md5(md5("$name"));
    mysql_query("insert into users values(null,'$name','$password')");
	$userID = mysql_insert_id();
    $userSQL = "select * from users where user_id = '$userID'";
    $userResult = mysql_query($userSQL);
    if ($user = mysql_fetch_array($userResult)) {
        echo "您的注册用户名为：" . $user['name'];
    } else {
        exit("用户注册失败！");
    }
    close_connection();
?>