(这个不知道有传上图片) 我的留言板里,留言了,但是留言人没显示出来。。我发现不了 - -!求指点、代码奉上(不知道是这段代码不) (我的数据库也没用户名,也是空白的)
<?php
/*
* Created on 2012-3-23
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include_once("comm.php");
$conn = mysql_connect("localhost","root","123456") or die("无法建立连接!"); mysql_select_db("lyb") or die(mysql_error()."数据库无法打开"); $title = $_POST['title']; $type = $_POST['type']; $content = $_POST['content']; $date_time = date("Y-m-d H:m:s"); $author = $_SESSION['user']; if($content!="" and $title!=""){
$sql = "insert into lyb_table (subject,type,content,publish_time,user) values('$title','$type','$content','$date_time','$author')";
mysql_query("set names 'gb2312'");
mysql_query($sql,$conn);
get_show_msg("lyb.php","留言成功!");
}else{
get_show_msg("lyb.php","留言填写错误,请重新填写!");
} mysql_close($conn);
?>
<?php
/*
* Created on 2012-3-23
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include_once("comm.php");
$conn = mysql_connect("localhost","root","123456") or die("无法建立连接!"); mysql_select_db("lyb") or die(mysql_error()."数据库无法打开"); $title = $_POST['title']; $type = $_POST['type']; $content = $_POST['content']; $date_time = date("Y-m-d H:m:s"); $author = $_SESSION['user']; if($content!="" and $title!=""){
$sql = "insert into lyb_table (subject,type,content,publish_time,user) values('$title','$type','$content','$date_time','$author')";
mysql_query("set names 'gb2312'");
mysql_query($sql,$conn);
get_show_msg("lyb.php","留言成功!");
}else{
get_show_msg("lyb.php","留言填写错误,请重新填写!");
} mysql_close($conn);
?>
include "comm.php";
user_check($_SESSION['uid'],$_SESSION['shell'],2);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>在线留言-留言板</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
MARGIN: 0px
}
</STYLE>
<LINK href="css/css.css" type=text/css rel=stylesheet>
<STYLE type=text/css>.STYLE1 {
FONT-FAMILY: "宋体"
}
</STYLE><META content="MSHTML 6.00.2900.6003" name=GENERATOR></HEAD>
<BODY><TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: #c0c0c0 1px solid; BORDER-LEFT: #c0c0c0 1px solid; BORDER-BOTTOM: #c0c0c0 1px solid"
vAlign=top width=140 bgColor=#eeeeee>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=left_bg2><A class=link3
href="login.php">用户登录</A></TD></TR>
<TR>
<TD class=left_bg2><A class=link3
href="view.php">查看留言</A></TD></TR>
<TR>
<TD class=left_bg1><A class=link2
href="lyb.php">在线留言</A></TD></TR>
<TR>
<TD class=left_bg2><A class=link3
href="logout.php?action=logout">退出登录</A></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD><IMG height=288 src="css/25.gif"
width=140></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=8></TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=bt>用户留言</TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=10 width="100%" border=0>
<TBODY>
<TR>
<TD height=450>
<TABLE cellSpacing=1 cellPadding=6 width="100%" bgColor=#ff9900
border=0>
<TBODY>
<TR>
<TD
bgColor=#fff2e6>查看用户提出的需求、意见和建议,并可进行回复。</TD></TR></TBODY></TABLE><BR>
<TABLE borderColor=#111111 cellSpacing=0 cellPadding=4 width="100%"
bgColor=#ffffff border=0> <DIV></DIV>
<TBODY>
<tr><td>序号</td><td>留言标题</td><td>留言人</td><td>类型</td><td>留言时间</td></tr>
<?php
$conn = mysql_connect("localhost","root","123456") or die(mysql_error()."数据服务器连接失败!");
mysql_select_db("lyb");
$sql = "select * from lyb_table";
mysql_query("set names 'gb2312'");
$result = mysql_query($sql,$conn);
$no = 1;
//每页显示的条数
$page_size = 5;
//总条目数
$nums = mysql_num_rows($result);
//每次显示的页数
$sub_pages=10;
//得到当前是第几页
$pageCurrent=$_GET["p"];
if(!$pageCurrent) $pageCurrent=1;
$sql = "select * from lyb_table limit ".($pageCurrent-1)*$page_size.",$page_size";
$curr_result = mysql_query($sql,$conn);
$page = new Pages($page_size,$nums,$pageCurrent,$sub_pages,"view.php?p=",2);
while($row=mysql_fetch_array($curr_result)){
echo "<tr>";
echo "<td>$no</td>";
echo "<td><a href='disp.php?id=".$row['id']."'>".$row['subject']."</a></td>";
echo "<td>".$row['author']."</td>";
switch($row['type']){
case 1:
echo "<td>求助</td>";
break;
case 2:
echo "<td>建议</td>";
break;
case 3:
echo "<td>投诉</td>";
break;
case 4:
echo "<td>表扬</td>";
break;
case 5:
echo "<td>业务联系</td>";
break;
}
echo "<td width=200>".$row['publish_time']."</td>";
echo "</tr>";
$n_sql = "select * from lyb_reply where c_id='".$row['id']."'";
$n_result = mysql_query($n_sql,$conn);
while($n_row = mysql_fetch_array($n_result)){
echo "<tr>";
echo "<td> </td>";
echo "<td>┗回复人:".$n_row['author']."</td>";
echo "<td colspan=2>回复内容:".substr($n_row['r_content'],0,20)."...</td>";
echo "<td >回复时间:".$n_row['r_time']."</td>";
echo "</tr>";
}
$no++;
} ?>
</TBODY>
<DIV></DIV></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</BODY></HTML>
echo date("Y-m-d H:m:s");
?>
include "comm.php";
user_check($_SESSION['uid'],$_SESSION['shell'],2);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>在线留言-留言板</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
MARGIN: 0px
}
</STYLE>
<LINK href="css/css.css" type=text/css rel=stylesheet>
<STYLE type=text/css>.STYLE1 {
FONT-FAMILY: "宋体"
}
</STYLE>
<script type="text/javascript">
function check(){ if(myform.title.value==""){
alert("标题不能为空!");
return false;
}
if(myform.content.value==""){
alert("留言内容不能为空!");
return false;
} return true;
}
</script>
<META content="MSHTML 6.00.2900.6003" name=GENERATOR></HEAD>
<BODY><TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: #c0c0c0 1px solid; BORDER-LEFT: #c0c0c0 1px solid; BORDER-BOTTOM: #c0c0c0 1px solid"
vAlign=top width=140 bgColor=#eeeeee>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=left_bg2><A class=link3
href="login.php">用户登录</A></TD>
<TD class=left_bg2><A class=link3
href="admin_mana.php">后台管理</A></TD>
</TR>
<TR>
<TD class=left_bg2><A class=link3
href="view.php">查看留言</A></TD></TR>
<TR>
<TD class=left_bg1><A class=link2
href="lyb.php">在线留言</A></TD></TR>
<TR>
<TD class=left_bg2><A class=link3
href="logout.php?action=logout">退出登录</A></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD><IMG height=288 src="css/25.gif"
width=140></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=8></TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=bt>用户反馈</TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=10 width="100%" border=0>
<TBODY>
<TR>
<TD height=350>
<TABLE cellSpacing=1 cellPadding=6 width="100%" bgColor=#ff9900
border=0>
<TBODY>
<TR>
<TD
bgColor=#fff2e6>感谢您提出的需求、意见和建议,我们会认真及时处理您的留言,并通过电子邮件给您回复。</TD></TR></TBODY></TABLE><BR>
<TABLE borderColor=#111111 cellSpacing=0 cellPadding=4 width="100%"
bgColor=#ffffff border=0>
<FORM id=myform name=myform action=submit.php method=post onsubmit="return check();">
<DIV></DIV>
<TBODY>
<TR>
<TD vAlign=bottom noWrap colSpan=2></TD></TR>
<TR>
<TD vAlign=bottom width=55>主题:</TD>
<TD vAlign=bottom><INPUT id=title size=40 name=title> * </TD></TR>
<TR bgColor=#f7f7f7>
<TD vAlign=bottom>类型:</TD>
<TD vAlign=bottom noWrap height=26><SPAN id=Type><INPUT
id=Type_0 type=radio CHECKED value=1 name=type> <LABEL
for=Type_0>求助</LABEL> <INPUT id=Type_1 type=radio value=2
name=type> <LABEL for=Type_1>建议</LABEL> <INPUT id=Type_2
type=radio value=3 name=type> <LABEL for=Type_2>投诉</LABEL>
<INPUT id=Type_3 type=radio value=4 name=type> <LABEL
for=Type_3>表扬</LABEL> <INPUT id=Type_4 type=radio value=5
name=type> <LABEL for=Type_4>业务联系</LABEL> </SPAN></TD></TR>
<TR>
<TD vAlign=top rowSpan=2>内容:</TD>
<TD><TEXTAREA id=content name=content rows=10 cols=50></TEXTAREA>
* </TD></TR>
<TR>
<TD><INPUT id=Btn_OK type=image src="css/btn_submit.gif"
name=Btn_OK> <A
href="http://www.sewworld.com/aboutus/khfk.html#"><IMG
onclick=document.myform.reset(); alt=重填
src="css/btn_reset.gif" border=0></A></TD></TR></TBODY>
<DIV></DIV></FORM></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</BODY></HTML><?php
include "comm.php";
if(isset($_POST['username'])){
user_login($_POST['username'],$_POST['pw']);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD><TITLE>在线留言-留言板</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
MARGIN: 0px
}
</STYLE>
<LINK href="css/css.css" type=text/css rel=stylesheet>
<STYLE type=text/css>.STYLE1 {
FONT-FAMILY: "宋体"
}
</STYLE>
<META content="MSHTML 6.00.2900.6003" name=GENERATOR>
</HEAD>
<BODY><TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: #c0c0c0 1px solid; BORDER-LEFT: #c0c0c0 1px solid; BORDER-BOTTOM: #c0c0c0 1px solid"
vAlign=top width=140 bgColor=#eeeeee>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=left_bg2><A class=link3
href="register.php">用户注册</A></TD></TR>
<TR>
<TD class=left_bg2><A class=link3
href="login.php">用户登录</A></TD></TR>
<TR>
<TD class=left_bg2><A class=link3
href="view.php">查看留言</A></TD></TR>
<TR>
<TD class=left_bg1><A class=link2
href="lyb.php">在线留言</A></TD></TR>
</TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD><IMG height=288 src="css/25.gif"
width=140></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=8></TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=bt>用户登录</TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=10 width="100%" border=0>
<TBODY>
<TR>
<TD height=150>
<TABLE cellSpacing=1 cellPadding=6 width="100%" bgColor=#ff9900
border=0>
<TBODY>
<TR>
<TD
bgColor=#fff2e6>请您登录后提出宝贵的需求、意见和建议,我们会认真及时处理您的留言,并通过电子邮件给您回复。</TD></TR></TBODY></TABLE><BR>
<TABLE borderColor=#111111 cellSpacing=0 cellPadding=4 width="100%"
bgColor=#ffffff border=0>
<FORM id=myform name=myform action="" method=post>
<DIV></DIV>
<TBODY>
<TR>
<TD vAlign=bottom noWrap colSpan=2></TD></TR>
<TR>
<TD vAlign=bottom noWrap width=70 bgColor=#f7f7f7>用户名:</TD>
<TD vAlign=bottom bgColor=#f7f7f7><INPUT id=name size=10
name=username></TD></TR>
<TR>
<TD vAlign=bottom>密码:</TD>
<TD vAlign=bottom><INPUT id=pw size=30 type=password name=pw></TD></TR>
<TR>
<TD><INPUT id=Btn_OK type=image src="css/btn_submit.gif"
name=Btn_OK> <A
href="http://www.sewworld.com/aboutus/khfk.html#"><IMG
onclick=document.myform.reset(); alt=重填
src="css/btn_reset.gif" border=0></A></TD></TR></TBODY>
<DIV></DIV></FORM></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</BODY></HTML>
那就是插入的时候出了问题。 $_SESSION['user']没值嘛。
测试一下 var_dump($_SESSION);
我没发现你那里用过session_start , 如 #5所说,给你#1的那段代码前加个 session_start();