注册页面出现Column count doesn't match value count at row 1
session_start();
define('IN_TG',true);
require 'include/global.//require dirname(__FILE__).'/include/header.require 'include/register.inc.
if (@$_GET['action']=='2'){

check_code($_POST['yzm'],$_SESSION['code']);
$_clean=array();
$_clean['uniqid']=check_uniqid($_POST['uniqid'], $_SESSION['uniqid']);
$_clean['active']=active_uniqid();
$_clean['username']=check_username($_POST['username'],2,40);
$_clean['password']=check_password($_POST['password'], $_POST['notpassword'],6);
$_clean['passt']=check_question($_POST['passt'], 4, 20);
$_clean['passd']=check_answer($_POST['passt'],$_POST['passd'],2,20);
$_clean['sex']=check_sex($_POST['sex']);
$_clean['email']=check_mail($_POST['email'],6,40);
$_clean['$_qq']=check_qq($_POST['qq']);
$_clean['$_url']=check_url($_POST['url'],40);

@mysql_query( "INSERT INTO project.test1(
tg_id,
tg_uniqid,
tg_active,
tg_usename,
tg_password,
tg_passt,
tg_passd,
tg_email,
tg_qq,
tg_url,
tg_sex,
tg_reg_time,
tg_last_time,
tg_last_ip
)
values(
'{$_clean['uniqid']}',
'{$_clean['active']}',
'{$_clean['username']}',
'{$_clean['password']}',
'{$_clean['passt']}',
'{$_clean['passd']}',
'{$_clean['email']}',
'{$_clean['qq']}',
'{$_clean['url']}',
'{$_clean['sex']}'
'now()',
'now()',
'{$_SERVER["REMOTE_ADDR"]}'
)")or die(mysql_error());
mysql_close();
location('恭喜你,注册成功','1.}else{$_SESSION['uniqid']=$_uniqid=sha1(uniqid(rand(),true));}

?>



数据库字段名
tg_id mediumint(8) UNSIGNED 否 无
tg_uniqid char(40) utf8_general_ci 否 无
tg_active char(40) utf8_general_ci 否 无

09-19 10:07