php留言板后台管理-查看代码

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
 mysql_select_db("xiaolie");
 if(!@$_GET["id"])
 {
  $jieguo = "select * from zhuce";
  $fasong = mysql_query($jieguo) or die(mysql_error());
  echo "<table border=1>
    <tr>
     <td>编号</td>
     <td>用户名称</td>
     <td>性别</td>
     <td>年龄</td>
     <td>注册时间</td>
     <td>详细信息</td>
    </tr>";
  while($nr=mysql_fetch_array($fasong))
  {
   echo "<tr>
     <td>".$nr["id"]."</td>
     <td>".$nr["name"]."</td>
     <td>".$nr["xingbie"]."</td>
     <td>".$nr["nianling"]."</td>
     <td>".$nr["zc_shijian"]."</td>
     <td><a href=ck_my.php?id=".$nr["id"].">查看</a></td>
    </tr>";
  }
  echo "</table>";
 }
 else
 {
  $jieguo = "select * from zhuce where id=".$_GET["id"];
  $fasong = mysql_query($jieguo);
  $nr = mysql_fetch_array($fasong);
  echo "编号：".$nr["id"]."<br>用户名称：".$nr["name"]."<br>性别：".$nr["xingbie"]."<br>年龄：".$nr["nianling"]."<br>注册时间：".$nr["zc_shijian"]."<br>";
  echo "<br><br><a href=ck_my.php>继续查询</a>";
 }
}

?>

function multi($total, $perPage, $curPage, $pageUrl, $maxPages = 0, $page = 10, $autoGoTo = TRUE, $simple = FALSE) {
 $multiPage = '';
 $pageUrl .= strpos($pageUrl, '?') ? '&amp;' : '?';
 $realPages = 1;
 if($total > $perPage) {
  $offset = 2;

  $realPages = @ceil($total / $perPage);
  $pages = $maxPages && $maxPages < $realPages ? $maxPages : $realPages;

  if($page > $pages) {
   $from = 1;
   $to = $pages;
  } else {
   $from = $curPage - $offset;
   $to = $from + $page - 1;
   if($from < 1) {
    $to = $curPage + 1 - $from;
    $from = 1;
    if($to - $from < $page) {
     $to = $page;
    }
   } elseif ($to > $pages) {
    $from = $pages - $page + 1;
    $to = $pages;
   }
  }

  $multiPage = ($curPage - $offset > 1 && $pages > $page ? '<a href="'.$pageUrl.'page=1" class="first"'.$ajaxtarget.'>1 ...</a>' : '').
   ($curPage > 1 && !$simple ? '<a href="'.$pageUrl.'page='.($curPage - 1).'" class="prev"'.$ajaxtarget.'>&lsaquo;&lsaquo;</a>' : '');
  for($i = $from; $i <= $to; $i++) {
   $multiPage .= $i == $curPage ? '<strong>'.$i.'</strong>' :
    '<a href="'.$pageUrl.'page='.$i.($ajaxtarget && $i == $pages && $autoGoTo ? '#' : '').'"'.$ajaxtarget.'>'.$i.'</a>';
  }

  $multiPage .= ($curPage < $pages && !$simple ? '<a href="'.$pageUrl.'page='.($curPage + 1).'" class="next"'.$ajaxtarget.'>&rsaquo;&rsaquo;</a>' : '').
   ($to < $pages ? '<a href="'.$pageUrl.'page='.$pages.'" class="last"'.$ajaxtarget.'>... '.$realPages.'</a>' : '').
   (!$simple && $pages > $page && !$ajaxtarget ? '<kbd><input type="text" name="custompage" size="3" onkeydown="if(event.keyCode==13) {window.location=''.$pageUrl.'page='+this.value; return false;}" /></kbd>' : '');

  $multiPage = $multiPage ? '<div class="pages">'.(!$simple ? '<em>&nbsp;'.$total.'&nbsp;</em>' : '').$multiPage.'</div>' : '';
 }
 $maxpage = $realPages;
 return $multiPage;
}

function dhtmlspecialchars($string) {
 if(is_array($string)) {
  foreach($string as $key => $val) {
   $string[$key] = dhtmlspecialchars($val);
  }
 } else {
  $string = preg_replace('/&amp;((#(d{3,5}|x[a-fA-F0-9]{4})|[a-zA-Z][a-z0-9]{2,5});)/', '&\1',
  str_replace(array('&', '"', '<', '>'), array('&amp;', '&quot;', '&lt;', '&gt;'), $string));
 }
 return $string;
}

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
 mysql_select_db("xiaolie");
 if(!$_GET)
 {
  $xuanbiao = "select * from zhuce";
  $fasong = mysql_query($xuanbiao) or die(mysql_error());
  echo "<table border=1>
    <tr>
     <td>编号</td>
     <td>用户名称</td>
     <td>性别</td>
     <td>年龄</td>
     <td>注册时间</td>
     <td>操作</td>
    </tr>";
  while($nr=mysql_fetch_array($fasong))
  {
   echo "<tr>
     <td>".$nr["id"]."</td>
     <td>".$nr["name"]."</td>
     <td>".$nr["xingbie"]."</td>
     <td>".$nr["nianling"]."</td>
     <td>".$nr["zc_shijian"]."</td>
     <td><a href=gx_my.php?id=".$nr["id"].">编辑</a></td>
    </tr>";
  }
  echo "</table>";
 }
 else
 {
  if(!$_POST)
  {
   $xianid = "select * from zhuce where id=".$_GET["id"];
   $fasong = mysql_query($xianid) or die(mysql_error());
   $nr = mysql_fetch_array($fasong);
   ?>
            <form method=post action="gx_my.php?id=<?php echo $_GET["id"];?>">
            <?php
             echo $nr["id"]."<br>";
   ?>
            <input type="hidden" name="id" value=<?php echo $nr["id"];?>>
            姓名<input type="text" name="name" value=<?php echo $nr["name"];?>><br>
            性别<input type="text" name="xingbie" value=<?php echo $nr["xingbie"];?>><br>           
            年龄<input type="text" name="nianling" value=<?php echo $nr["nianling"];?>><br>
            注册时间<input type="text" name="zc_shijian" value=<?php echo $nr["zc_shijian"];?>><br>
            <input type="submit" name="ok" value="提交">
            </form>
            <?php
  }
  else
  {
   $gx = "update zhuce set name='".$_POST["name"]."',xingbie='".$_POST["xingbie"]."',nianling='".$_POST["nianling"]."',zc_shijian='".$_POST["zc_shijian"]."' where id='".$_POST["id"]."'";
   $fasong = mysql_query($gx);
   if($fasong){
    echo "记录已经成功修改<br><a href=gx_my.php>继续修改记录</a>";}
   else{
    echo "记录修改失败<br><a href=gx_my.php?id=".$_POST["id"].">返回</a>"; } 
  }
 }
}

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
 mysql_select_db("xiaolie");
 if($_GET)
 {
  $a = $_GET["id"];
  $sc = "delete from zhuce where id=$a";
  $fasong = mysql_query($sc) or die(mysql_error());
  if($fasong)
   echo "记录已经成功删除<a href=sc_my.php>继续删除记录</a>";
  else
   echo "删除记录失败<br><a href=sc_my.php>返回</a>";
   
  
 }
 else
 {
  $fasong = mysql_query("select * from zhuce") or die(mysql_error());
  echo "<table border=1>
    <tr>
     <td>编号</td>
     <td>用户名称</td>
     <td>性别</td>
     <td>年龄</td>
     <td>注册时间</td>
     <td>操作</td>
    </tr>";
  while($nr = mysql_fetch_array($fasong))
  {
   echo "<tr>
     <td>".$nr["id"]."</td>
     <td>".$nr["name"]."</td>
     <td>".$nr["xingbie"]."</td>
     <td>".$nr["nianling"]."</td>
     <td>".$nr["zc_shijian"]."</td>
     <td><a href=sc_my.php?id=".$nr["id"].">删除</a></td>
    </tr>";
  }
  echo "</table>";
 }
}
?>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");

if(@$_POST["ok"])
{
 mysql_select_db("xiaolie");
//插入数据
 $shuju = " insert into hao (name,neirong,shijian) values ('".$_POST["name"]."','".$_POST["neirong"]."','".date("Y-m-d H:m:s")."')";
 $fasong = mysql_query($shuju) or die(mysql_error());
 if($fasong)
 {
  header("location:/a2/ly.php");
 }
 else
 {
  echo "内容发表失败<br><a href=fb_my.php>返回</a>";
 }
}
else
{
/* mysql_select_db("xiaolie");
 //发送查询
 $fasong = mysql_query("select * from hao") or die(mysql_error());
 while($nr = mysql_fetch_array($fasong))
 {
  echo "<table border=1>
    <tr>
     <td width='60'>第 ".$nr["id"]." 楼</td>
     <td width='140'>发表用户：".$nr["name"]."</td>
     <td width='230'>发表时间：".$nr["shijian"]."</td>
    </tr>
    <tr><td colspan='3' width='430'>".$nr["neirong"]."</td></tr>
   </table>";
 }
*/
?>
<form method=post action=fb_my.php>
    姓名<input type=text name="name" /><br>
    发表<br><textarea name="neirong" cols="50" rows="5"></textarea><br>
    <input type=submit name="ok" value="好的" />
</form>
<?php

}

?>