这个是注册确认菜单 <? $title="注册成功"; include("head.php"); require("config.php"); $useravatar=$_FILES['useravatar']; $ip=$_REQUEST['ip']; $regdate=$_REQUEST['regdate']; $lastvisit=$regdate; $username=$_REQUEST['username']; $password=$_REQUEST['password']; $repwd=$_REQUEST['repwd']; $gender=$_REQUEST['gender']; $email=$_REQUEST['email']; $truename=$_REQUEST['truename']; $year=$_REQUEST['year']; $month=$_REQUEST['month']; $day=$_REQUEST['day']; $bday=$year."-".$month."-".$day; $site=$_REQUEST['site']; $oicq=$_REQUEST['oicq']; $location=$_REQUEST['location']; $resume=$_REQUEST['resume']; $signature=$_REQUEST['signature']; $avatar=$_REQUEST['avatar']; $width=$_REQUEST['urlwidth']; $height=$_REQUEST['urlheight']; //以上为获取 [ register.php ] 中的变量 $uploadpath="upload/"; $time=date("YmdHis"); if(is_uploaded_file($useravatar)) { $size =getimagesize($useravatar); echo $size[0];echo $size[1]; if ($size[0]>120&&$size[1]>120) $width=120; //控制头像大小 $name=explode(".",$useravatar_name); //上传头像图片,修改名称为上船时间名称 $dt=$uploadpath.$time.".".$name[1]; copy ($useravatar,$dt); $avatarlc=$dt; echo $size[0]; } if(!is_uploaded_file($useravatar)) $avatarlc=$avatar; //处理个人简介部分 if(!empty($resume)) { $resume = trim($resume); $resume = str_replace("\t",NULL,$resume); $resume = str_replace("<","<",$resume); $resume = str_replace(">",">",$resume); } //处理签名部分 if(!empty($signature)) { include("code/wzcode.inc"); $signature = trim($signature); $signature = str_replace("\t",NULL,$signature); $signature = wz($signature); } ?> <table width="760" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center" valign="top"> <? @$link=mysql_pconnect($h,$u,$p) or die("<font class=error>无法连接到服务器</font>"); @mysql_select_db($db,$link) or die("<font class=error>无法连接到数据库</font>"); $query="insert into member (username,password,gender,email,ip,regdate,lastvisit) values ('$username','$password','$gender','$email','$ip','$regdate','$lastvisit')"; @ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>"); $query="update member(resume) values ('$resume') where username=$username"; @ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>"); ?> <div align="center"></div></td> </tr> </table> <? include("foot.php"); ?>-------------------------------------------------- 这个是数据库的 CREATE TABLE `member` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(20) NOT NULL default '', `password` varchar(20) NOT NULL default '', `gender` tinyint(1) NOT NULL default '0', `level` tinyint(1) NOT NULL default '1', `email` varchar(50) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `regdate` varchar(20) NOT NULL default '', `lastvisit` varchar(20) NOT NULL default '', `postnum` int(6) unsigned NOT NULL default '0', `credit` int(6) unsigned NOT NULL default '0', `site` varchar(255) NOT NULL default '', `oicq` int(15) NOT NULL default '0', `loaction` varchar(50) NOT NULL default '', `bday` date NOT NULL default '0000-00-00', `resume` text NOT NULL, `signature` text NOT NULL, `truename` varchar(30) NOT NULL default '', `avatarlc` varchar(255) NOT NULL default '', `width` tinyint(3) unsigned NOT NULL default '0', `height` tinyint(3) unsigned NOT NULL default '0', UNIQUE KEY `id` (`id`), KEY `id_2` (`id`), KEY `id_3` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=12 ;
太长了,你应该把问题简化出来(比如表格只有一两个字段).提醒一点: $query="insert into member (username,password) values ('$username','$password')";应该用: $query="insert into member (username,password) values (\"$username\",\"$password\")";就是要把'$username'改为,\"$username\",以防止你变量里有单引号(')会出错.
o ^)^ <? $username=$_REQUEST['username']; @$link=mysql_pconnect($h,$u,$p) or die("<font class=error>无法连接到服务器</font>"); @mysql_select_db($db,$link) or die("<font class=error>无法连接到数据库</font>"); $query="insert into member (username) values ('$username')"; @ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>"); ?>username为not null 假如username为空呢?即没有输入时?
<?
$title="注册成功";
include("head.php");
require("config.php");
$useravatar=$_FILES['useravatar'];
$ip=$_REQUEST['ip'];
$regdate=$_REQUEST['regdate'];
$lastvisit=$regdate;
$username=$_REQUEST['username'];
$password=$_REQUEST['password'];
$repwd=$_REQUEST['repwd'];
$gender=$_REQUEST['gender'];
$email=$_REQUEST['email'];
$truename=$_REQUEST['truename'];
$year=$_REQUEST['year'];
$month=$_REQUEST['month'];
$day=$_REQUEST['day'];
$bday=$year."-".$month."-".$day;
$site=$_REQUEST['site'];
$oicq=$_REQUEST['oicq'];
$location=$_REQUEST['location'];
$resume=$_REQUEST['resume'];
$signature=$_REQUEST['signature'];
$avatar=$_REQUEST['avatar'];
$width=$_REQUEST['urlwidth'];
$height=$_REQUEST['urlheight'];
//以上为获取 [ register.php ] 中的变量
$uploadpath="upload/";
$time=date("YmdHis");
if(is_uploaded_file($useravatar))
{
$size =getimagesize($useravatar);
echo $size[0];echo $size[1];
if ($size[0]>120&&$size[1]>120) $width=120; //控制头像大小
$name=explode(".",$useravatar_name); //上传头像图片,修改名称为上船时间名称
$dt=$uploadpath.$time.".".$name[1];
copy ($useravatar,$dt);
$avatarlc=$dt;
echo $size[0];
}
if(!is_uploaded_file($useravatar)) $avatarlc=$avatar;
//处理个人简介部分
if(!empty($resume))
{
$resume = trim($resume);
$resume = str_replace("\t",NULL,$resume);
$resume = str_replace("<","<",$resume);
$resume = str_replace(">",">",$resume);
}
//处理签名部分
if(!empty($signature))
{
include("code/wzcode.inc");
$signature = trim($signature);
$signature = str_replace("\t",NULL,$signature);
$signature = wz($signature);
}
?>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<?
@$link=mysql_pconnect($h,$u,$p) or die("<font class=error>无法连接到服务器</font>");
@mysql_select_db($db,$link) or die("<font class=error>无法连接到数据库</font>");
$query="insert into member (username,password,gender,email,ip,regdate,lastvisit) values ('$username','$password','$gender','$email','$ip','$regdate','$lastvisit')";
@ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>");
$query="update member(resume) values ('$resume') where username=$username";
@ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>");
?>
<div align="center"></div></td>
</tr>
</table>
<?
include("foot.php");
?>--------------------------------------------------
这个是数据库的
CREATE TABLE `member` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0',
`level` tinyint(1) NOT NULL default '1',
`email` varchar(50) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`regdate` varchar(20) NOT NULL default '',
`lastvisit` varchar(20) NOT NULL default '',
`postnum` int(6) unsigned NOT NULL default '0',
`credit` int(6) unsigned NOT NULL default '0',
`site` varchar(255) NOT NULL default '',
`oicq` int(15) NOT NULL default '0',
`loaction` varchar(50) NOT NULL default '',
`bday` date NOT NULL default '0000-00-00',
`resume` text NOT NULL,
`signature` text NOT NULL,
`truename` varchar(30) NOT NULL default '',
`avatarlc` varchar(255) NOT NULL default '',
`width` tinyint(3) unsigned NOT NULL default '0',
`height` tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`),
KEY `id_3` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;
$query="insert into member (username,password) values ('$username','$password')";应该用:
$query="insert into member (username,password) values (\"$username\",\"$password\")";就是要把'$username'改为,\"$username\",以防止你变量里有单引号(')会出错.
<?
$username=$_REQUEST['username'];
@$link=mysql_pconnect($h,$u,$p) or die("<font class=error>无法连接到服务器</font>");
@mysql_select_db($db,$link) or die("<font class=error>无法连接到数据库</font>");
$query="insert into member (username) values ('$username')";
@ mysql_query($query,$link) or die("<font class=error>无法操作数据库</font>");
?>username为not null
假如username为空呢?即没有输入时?
如果这样的话两种方法
第一:事先判断,如果为空,给他一个空格
第二:改数据库成可以为空
这么别扭:}
既然都是not null了你怎么能把null($resume没有输入变量)值插入呢?????