关于注册中的问题 ,急!!!!
function adduser(){
//找出用户id
$conn=ocilogon("cht","cht","sm");
$query="select max(userid) from member";
$st=ociparse($conn,$query);
ociexecute($st);
$id=ociresult($st,userid);//这个id似为没有读出来,因为1,但此后的输出却没有
//echo"$id";为空什么也没有
$id=$id+1;
//echo"$id";此时为1,应为2
$sql="insert into member values('$id','$user_name','$user_pas',0)";
$stmt=ociparse($conn,$sql);
ociexecute($stmt);//第38行
ocifreestatement($stmt);
ocifreestatement($st);
ocilogoff($conn);
}
function adduserinfo(){
$joindate=date("d-m月-Y");
$conn=ocilogon("cht","cht","sm");
$sql="insert into memberinfo values('$user_name','$user_person','$joindate','$user_tel','$user_email','$user_add','$user_zip','$user_memo')";
$st=ociparse($conn,$sql);
ociexecute($st);//48行
ocifreestatement($st);
ocilogoff($conn);
}
Warning: OCIStmtExecute: ORA-01400: 无法将 NULL 插入 ("CHT"."MEMBER"."USERNAME") in D:\page\dzsw\regist.php on line 38
Warning: OCIStmtExecute: ORA-01843: 无效的月份 in D:\page\dzsw\regist.php on line 48
//在注册输入内容中没有为空的