1.数据库的连接问题
//数据库连接
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PWD','yangfan');
define('DB_NAME','testguest');
//创建数据库连接
$_conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD) or die('数据里连接失败');
//选择一款数据库
mysql_select_db(DB_NAME) or die('指定的数据库不存在');
//选择字符集
mysql_query('SET NAMES UTF8') or die('字符集错误');
2.新增用户
//测试新增用户
mysql_query("insert into tg_user(tg_username) values(‘小小’)")or die('执行失败');
//在新增之前,要判断用户名是否重复
$query = mysql_query("SELECT tg_username FROM tg_user WHERE tg_username='{$_clean['username']}'") or die('SQL错误');
if (mysql_fetch_array($query,MYSQL_ASSOC)) {
_alert_back('对不起,此用户已被注册!');
}
//新增用户 //在双引号里,直接放变量是可以的,比如$_username,但如果是数组,就必须加上{} ,比如 {$_clean['username']}
mysql_query(
"INSERT INTO tg_user (
tg_uniqid,
tg_active,
tg_username,
tg_password,
tg_question,
tg_answer,
tg_sex,
tg_face,
tg_email,
tg_qq,
tg_url,
tg_reg_time,
tg_last_time,
tg_last_ip
)
VALUES (
'{$_clean['uniqid']}',
'{$_clean['active']}',
'{$_clean['username']}',
'{$_clean['password']}',
'{$_clean['question']}',
'{$_clean['answer']}',
'{$_clean['sex']}',
'{$_clean['face']}',
'{$_clean['email']}',
'{$_clean['qq']}',
'{$_clean['url']}',
NOW(),
NOW(),
'{$_SERVER["REMOTE_ADDR"]}'
)"
) or die('SQL执行错误');
//关闭
mysql_close();
//跳转
_location('恭喜你,注册成功!','index.php');
} else {
$_SESSION['uniqid'] = $_uniqid = _sha1_uniqid();
}