error reg page

jammer1972 · 02/07/2011, 07:59

Use of undefined constant step2 - assumed 'step2' in C:\xampp\htdocs\regg\register.php on line 5
Use of undefined constant step2 - assumed 'step2' in C:\xampp\htdocs\regg\register.php on line 18

Notice: Use of undefined constant step2 - assumed 'step2' in C:\xampp\htdocs\regg\register.php on line 5

Notice: Use of undefined constant step2 - assumed 'step2' in C:\xampp\htdocs\regg\register.php on line 5

Notice: Use of undefined constant ZoneGroup - assumed 'ZoneGroup' in C:\xampp\htdocs\regg\register.php on line 27

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_user'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\regg\register.php on line 34

Warning: odbc_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\regg\register.php on line 35

Warning: odbc_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\regg\register.php on line 36

Notice: Use of undefined constant username - assumed 'username' in C:\xampp\htdocs\regg\register.php on line 38

Notice: Use of undefined constant username - assumed 'username' in C:\xampp\htdocs\regg\register.php on line 40

Notice: Use of undefined constant username - assumed 'username' in C:\xampp\htdocs\regg\register.php on line 41

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 43

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 44

Notice: Use of undefined constant username - assumed 'username' in C:\xampp\htdocs\regg\register.php on line 46

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 46

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 48

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 49

Notice: Use of undefined constant password2 - assumed 'password2' in C:\xampp\htdocs\regg\register.php on line 51

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 51

Notice: Use of undefined constant question - assumed 'question' in C:\xampp\htdocs\regg\register.php on line 53

Notice: Use of undefined constant question - assumed 'question' in C:\xampp\htdocs\regg\register.php on line 54

Notice: Use of undefined constant answer - assumed 'answer' in C:\xampp\htdocs\regg\register.php on line 55

Notice: Use of undefined constant answer - assumed 'answer' in C:\xampp\htdocs\regg\register.php on line 56

Notice: Use of undefined constant mail - assumed 'mail' in C:\xampp\htdocs\regg\register.php on line 58

Notice: Use of undefined constant password1 - assumed 'password1' in C:\xampp\htdocs\regg\register.php on line 71

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'user_profile'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\regg\register.php on line 81

Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_user'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\regg\register.php on line 82

Notice: Undefined variable: success in C:\xampp\htdocs\regg\register.php on line 12

Notice: Use of undefined constant step2 - assumed 'step2' in C:\xampp\htdocs\regg\register.php on line 13

Notice: Use of undefined constant step1 - assumed 'step1' in C:\xampp\htdocs\regg\register.php on line 13
can any one help me with this

gedimazs · 02/07/2011, 12:50

How do you think people can help you when they don't see your whole code? How do they know what is in you 5th line or 18th and etc.

҉ THT ҉ · 02/07/2011, 15:20

Try adding quotes (") and the last 2 errors. you can read it

jammer1972 · 02/08/2011, 03:59

Quote:

Originally Posted by gedimazs

How do you think people can help you when they don't see your whole code? How do they know what is in you 5th line or 18th and etc.

<?php

require_once "config.inc.php";

if(isset($_SESSION[step2]) && isset($_POST[step2])) {
//ÌáÈ¡µÄ×îºóÒ»²½
$errorStr = formStep3();
if($errorStr!=null){
require_once('register.html');
}else{
require_once('success.html');
$suc=$success;
unset($_SESSION[step2], $_SESSION[step1]);
}}
else {
//×¢²áµÄµÚ¶þ²½
require_once('register.html');
$_SESSION[step2] = 1; }

//ÅÐ¶ÏÓÃ»§Ìá½»µÄ±íµ¥µÄÊý¾ÝµÄ ×¼È·ÐÔ ºÍ ±£´æÌá½»Êý¾Ý µÄº¯Êý
function formStep3(){
$errors = array();
$errorStr = null;
//²éÑ¯ÓÃ»§ÃûÊÇ·ñ´æÔÚ
$strSql="select * from Tbl_user where user_id='$_POST[username]'";
if ($_POST[ZoneGroup]=="zone1") {
$account_odbc = odbc_connect('account','account','account');
} elseif ($_POST[ZoneGroup]=="zone2") {
$account_odbc = odbc_connect('account2','sa','55555');
} else {
die ("·ÖÇøÑ¡Ôñ´íÎó!");
}
$user_result=odbc_do($account_odbc,$strSql);
$result_query=odbc_fetch_row($user_result);
if (odbc_result($user_result,1)!= "") $errors[] = "¸ÃÃû³ÆÒÑ¾*±»Õ¼ÓÃ£¬ÇëÖØÐÂÊäÈë";
//ÑéÖ¤ÓÃ»§ÃûÊÇ·ñ¹æ·¶
if(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST[username])) $errors[]="Ö»ÄÜÓÃÓ¢ÎÄ´óÐ¡Ð´×ÖÄ¸Êý×ÖµÄ×éºÏ×÷ÎªÓÃ»§Ãû";
//ÑéÖ¤ÓÃ»§Ãû³¤¶È
if(strlen($_POST[username])<6) $errors[] = "ÓÃ»§ÃûµÄ³¤¶È²»ÄÜÐ¡ÓÚ6Î»";
if(strlen($_POST[username])>12) $errors[]= "ÓÃ»§ÃûµÄ³¤¶È²»ÄÜ³¬¹ý12Î»";
//ÑéÖ¤ÃÜÂëÊÇ·ñ¹æ·¶
if(!preg_match("/^[0-9a-zA-Z]{6,12}$/i", $_POST[password1])) $errors[]="Ö»ÄÜÓÃÓ¢ÎÄ´óÐ¡Ð´×ÖÄ¸Êý×ÖµÄ×éºÏ×÷ÎªÃÜÂë";
if(preg_match("/^[0-9]{6,12}$/i",$_POST[password1])) $errors[]="²»¿ÉÊ¹ÓÃ´¿Êý×Ö×÷ÎªÃÜÂë";
//ÑéÖ¤ÓÃ»§ÃûºÍÃÜÂëÊÇ·ñÏàÍ¬
if($_POST[username]==$_POST[password1]) $errors[]= "ÕÊºÅºÍÃÜÂë²»ÄÜÏàÍ¬";
//ÑéÖ¤ÃÜÂë³¤¶È
if(strlen($_POST[password1])<6) $errors[] = "ÃÜÂëµÄ³¤¶È²»ÄÜÐ¡ÓÚ6Î»";
if(strlen($_POST[password1])>12) $errors[] = "ÃÜÂë³¤¶È²»ÄÜ´óÓÚ12Î»";
//ÑéÖ¤ÃÜÂëÒ»ÖÂÐÔ
if($_POST[password2]!=$_POST[password1]) $errors[] = "ÊäÈëµÄÃÜÂë²»Ò»ÖÂ";
//ÑéÖ¤ÕÒ»ØÃÜÂëÎÊÌâ´ð°¸³¤¶È
if(strlen($_POST[question])>20) $errors[] = "ÕÒ»ØÃÜÂëÎÊÌâ´óÓÚ20Î»£¬Çë·µ»ØÖØÐÂÊäÈë";
if(strlen($_POST[question])<10) $errors[] = "ÕÒ»ØÃÜÂëÎÊÌâÐ¡ÓÚ10Î»£¬Çë·µ»ØÖØÐÂÊäÈë";
if(strlen($_POST[answer])>20) $errors[] = "ÕÒ»ØÃÜÂë´ð°¸´óÓÚ20Î»£¬Çë·µ»ØÖØÐÂÊäÈë";
if(strlen($_POST[answer])<10) $errors[] = "ÕÒ»ØÃÜÂë´ð°¸Ð¡ÓÚ10Î»£¬Çë·µ»ØÖØÐÂÊäÈë";
//ÑéÖ¤ÓÃ»§emailÕýÈ·ÐÔ
if(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST[mail])) $errors[]="EmailµØÖ·²»ÕýÈ·£¬ÇëÖØÐÂÊäÈëÕýÈ·µÄEmailµØÖ·";

//´íÎóÐÅÏ¢Êä³ö
if(sizeof($errors)>0){
$errorStr .= " ";
$errorStr .= "ÐÅÏ¢ÊäÈë´íÎó£º";
foreach($errors as $error)
$errorStr .= "<li>$error</li>";
$errorStr .= " ";
}else{

//¼ÓÃÜÃÜÂë
$passwd_user=md5($_POST[password1]);
//»ñÈ¡user_no
$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);
//ÓÃ»§×¢²áÓï¾ä
$dk_account_query="insert into user_profile(user_no,user_id,user_pwd,resident_no, user_type,login_flag,login_tag,ipt_time,login_time ,logout_time,user_ip_addr,server_id) values('$dk_user_no','$_POST[username]','$passwd_user','801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')";
//ÓÃ»§×ÊÁÏ±£´æ
$dk_account_query2="insert into Tbl_user(user_no,user_id,user_pwd,user_mail,user_a nswer,user_question) values('$dk_user_no','$_POST[username]','$_POST[password1]','$_POST[mail]','$_POST[answer]','$_POST[question]')";
//Ö´ÐÐÓÃ»§×¢²áºÍ×ÊÁÏ±£´æÓï¾ä
$dk_account_result1=odbc_do($account_odbc,$dk_acco unt_query);
$dk_account_result2=odbc_do($account_odbc,$dk_acco unt_query2);
odbc_close($account_odbc);

}
//·µ»Ø´íÎóÏûÏ¢µ½Ò³Ãæ
return $errorStr;
}

?>
ok here it is

*[F]rea[K]* · 02/08/2011, 05:59

try this script

jammer1972 · 02/08/2011, 06:46

Quote:

Originally Posted by *[F]rea[K]*

try this script

this is what i get when i try that one

Notice: Undefined index: activ in C:\xampp\htdocs\register.php on line 21

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register.php on line 80

gedimazs · 02/08/2011, 08:03

Quote:

Originally Posted by jammer1972

this is what i get when i try that one

Notice: Undefined index: activ in C:\xampp\htdocs\register.php on line 21

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\register.php on line 80

have you filled this part

Code:

// fill in your mssql info here
$mssql = array(
		'host' => "localhost",
		'user' => "sa",
		'pass' => "server"

with you connect to DB info?

jammer1972 · 02/09/2011, 02:18

Quote:
Originally Posted by gedimazs
have you filled this part
Code:
// fill in your mssql info here
$mssql = array(
		'host' => "localhost",
		'user' => "sa",
		'pass' => "server"
with you connect to DB info?

yes i have lol i just cant get it to work

gedimazs · 02/09/2011, 08:32

this reg page uses ODBC connections. Have you linked you account.dbo with your ODBC?

҉ THT ҉ · 02/09/2011, 17:55

$account_odbc = odbc_connect('account2','sa','55555');

Is that correct?

jammer1972 · 02/09/2011, 22:17

Quote:

Originally Posted by ҉ THT ҉

$account_odbc = odbc_connect('account2','sa','55555');

Is that correct?

i didnt leave rifght password here

҉ THT ҉ · 02/10/2011, 02:08

No,, I mean did you fill that in(with the right information) on your webserver?