Register page appears column count doesn ' t match value count at row 1
Session_Start ();
Define (' In_tg ', true);
Require ' include/global.php ';
Require DirName (__file__). ' /include/header.php ';
Require ' include/register.inc.php ';
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 (' Congratulations, registration successful ', ' 1.php ');
}else{$_session[' uniqid ']=$_uniqid=sha1 (Uniqid (rand (), True));}
?>
<title>Multi-user Message system--Registration</title>
Define (' script ', ' register ');
Require DirName (__file__). ' /include/tittle.php ';
?>
Require DirName (__file__). ' /include/header.php ';
?>
Member Registration
Require DirName (__file__). ' /include/footer.php ';
?>
database field Name
tg_id Mediumint (8) UNSIGNED No
Tg_uniqid char (UTF8_GENERAL_CI) No No
Tg_active char (UTF8_GENERAL_CI) No No