$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database); $sql="SELECT id , name ,sex , tel, email, info , ip, DATE_FORMAT(time_at,'%Y年 %m月 %d日 %T') FROM `liuyanban` ORDER BY `id` DESC"; $result=mysql_db_query($mysql_database,$sql,$conn); while($row=mysql_fetch_row($result)) { $row1[0]--; if($row[2]==1) $men="先生"; else $men="小姐";
<?
require('database.php');
//------------------------------------
$ip=getenv('REMOTE_ADDR');
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$sql="INSERT INTO `liuyanban` ( `id` , `name` , `sex` , `tel` , `email`,`info` , `ip` , `time_at` ) VALUES ('', '$name', '$sex', '$tel','$email', '$info', '$ip', NOW( ) )";
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);
header('location:liuyanban.php');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
<?
echo $name;
echo $sex;
echo $tel;
echo $email;
echo $info;
?><p> </p>
</body>
</html>
<?
$mysql_server_name="localhost";
$mysql_username="root";
$mysql_password="";
$mysql_database="information";
//-----------
if(!$name || !$password)
{
header('location:goon_false.php');
}
else{
$sql="SELECT name FROM `lend` WHERE name = '$name' ";
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
//显示
//print_r($row);
mysql_free_result($result);
if(!$row)
{
header('location:goon_false.php');
break;
}
else{
$sql="SELECT password FROM `lend` WHERE name='$name' AND password=sha1('$password')";
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
//显示
//print_r($row);
mysql_free_result($result);
if(!$row)
{
header('location:goon_false.php');
break;
}
}
}
$sql="SELECT count(*) FROM `liuyanban` ";
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$result=mysql_db_query($mysql_database,$sql,$conn);
$row1=mysql_fetch_row($result);
//显示
//print_r($row1);
mysql_free_result($result);
$row1[0]+=1;
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
$sql="SELECT id , name ,sex , tel, email, info , ip, DATE_FORMAT(time_at,'%Y年 %m月 %d日 %T') FROM `liuyanban` ORDER BY `id` DESC";
$result=mysql_db_query($mysql_database,$sql,$conn);
while($row=mysql_fetch_row($result))
{
$row1[0]--;
if($row[2]==1)
$men="先生";
else
$men="小姐";
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言板</title>
<style type="text/css">
<!--
.style1 {
font-size: 16px;
font-family: "华文新魏";
}
.style3 {
font-size: 14px;
color: #FF6600;
}
.style5 {color: #0066FF}
.style7 {
font-size: 18px;
color: #FF3333;
}
.style8 {
font-size: 20px;
color: #0033CC;
}
.style9 {color: #9933CC}
.style10 {color: #996666}
body,td,th {
font-size: 16px;
}
.style11 {
font-size: 24px;
color: #CC3399;
}
.style12 {font-size: 12px}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}function MM_popupMsg(msg) { //v1.0
alert(msg);
}
//-->
</script>
</head><body>
<table width="950" border="0" cellpadding="0" cellspacing="1" bgcolor="#0033FF">
<tr>
<td bgcolor="#66FFCC" >
<span class="style3"><?=$row[7] ?></span>(<span class="style5"><?=$row[6]?></span>) [<A href="modify.php?id=<?=$row[0] ?>del1=<?=$del1?>" class="style12" target="_blank">修改</A>] [<A href="del.php?id=<?=$row[0] ?>del1=<?=$rand ?>del2=<?=$i?>" class="style12" onClick="MM_popupMsg('确定删除本条留言?')">删除</A>]<br>
<span class="style7"><?=$row[1] ?></span><span class="style8"><?=$men ?></span><<span class="style9"><a href="mailto:<?=$row[4] ?>" target="_blank"><?=$row[4] ?></a></span>> <span class="style10">第<span class="style11">
<?=$row1[0] ?>
</span>留言</span>:</td>
</tr>
<tr>
<td width="" bgcolor="#FFFFFF"><span class="style1"><?=nl2br($row[5]) ?></span></td>
</tr>
</table><br>
<hr size=2 color=#999999 width="950" align="left"><br>
<?
//print_r([row]);
}
mysql_free_result($result);
?>
<table width="950" border="0" cellpadding="0" cellspacing="1" id="02">
<tr>
<td> </td>
<td> </td>
</tr>
<tr align="right" valign="middle">
<td colspan="2"><form name="form1" method="post" >
GO
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option selected>----</option>
<option value="lyshow.php">01</option>
<option value="lyshow002.php">02</option>
</select>
</form></td>
</tr>
</table>
<p> </p>
</body>
</html>
里面很详细,有你想要的所有
自己看看!