后台管理 5 即将完成

<?php

include("conn.php");
//include("p_mysql_class.php");
include('fckeditor.php') ;

global $z;$zz;
$z=0;$zz=0;
static $ye=0;
static $id=0;
static $x=0;
//global $_array_bt;
$sBasePath = $_SERVER['PHP_SELF'] ;
$sBasePath = dirname($sBasePath).'/';
  $oFCKeditor = new FCKeditor('pgy') ;
   $oFCKeditor->BasePath   = $sBasePath ; $oFCKeditor->Value="123" ;

//$oFCKeditor->Create();

//if($_POST['sub']){

// echo $d = "fck内容".$_POST[pgy];
// echo $biaoti="标题：".$_POST[biaoti];
// echo "作者:".$_POST[textfield2];
// $db= new mysql_class("localhost","root","","houtai");
////$db->fg_insert('houtaiguanli',"id,ip,title,name,neirong","'','biaoti','xub','123456','$biaoti','黄成','$d'");

//$db->fg_insert('houtaiguanli',"id,title,p_user,pass,xinwen,zuozhe","'','$_POST[biaoti]','ddd','fff','$_POST[pgy]','$_POST[textfield2]'");

//}

//$db->fg_select('houtaiguanli');

//$numq=mysql_query("SELECT * FROM `houtaiguanli`");
// $num = mysql_num_rows($numq);
  //--------------------------分页
$pagesize=18;
$url=$_SERVER["REQUEST_URI"];
echo "$url<br>";
$url=parse_url($url);
echo "$url<br>";
$url=$url[path];

echo $url;
$numq=mysql_query("SELECT * FROM `houtaiguanli`");
$num = mysql_num_rows($numq);
echo $num;
if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';
}



if($num > $pagesize){
if($pageval<=1)$pageval=1;
"共 $num 条".
        " <a href=$url?page=".($pageval-1).">上一页</a> <a href=$url?page=".($pageval+1).">下一页</a>";
}


   $SQL="SELECT * FROM `houtaiguanli` limit $page $pagesize ";
    $query=mysql_query($SQL);
    while($row=mysql_fetch_array($query)){

     "<hr><b>".$row[title]." | ".$row[0];
   //print_r ("<hr><b>".$row[user]);
    }
for($i=$pagesize+$pagesize*($pageval-1);$j<=$i;$j++){

    $sql =mysql_query ("SELECT * FROM `houtaiguanli` WHERE id =($j)");
   // $query=mysql_query($sql);
    $row=@mysql_fetch_array($sql);
    $id_array[$j]=($row[0]);//id
    $_array[$j]=($row[1]); //标题
    $_array1[$j]=($row[4]);//新闻内容
    $_array2[$j]=($row[5]); //作者

   // if ($row[0]==""){  //id=""循环总数加1 读取limie也同时加1
   //$i=$i+1;
   //    $pagesize=$pagesize+1;
   //      if ($i>=$num){//当循环等于数据库的总量时 推出循环

        //     break;
       //  }


   // }
      if($_array[$j]!=""and $_array1[$j]!=""and $_array2[$j]!=""){
        $_array_id[$z]=($row[0])."<br>";//id
         $_array_bt[$z]=($row[1])."<br>"; //标题
        $_array_nr[$z]=($row[4]."<br>");//新闻内容
        $_array_zz[$z]=($row[5]); //作者

               if ($z==18){
                //$i=0;
               $j=0;
              // echo $x=$x+1;

              //echo "你好";
              echo $id=$row[0];//记住每一页最后一次的id
                 //echo $row[0];
                 //echo $pagesize;
               }
          $z++;

       }//if


}//for



if ($_POST['Submit1']){
        $z=1+$pagesize*($pageval-1);

         $_array_bt[$z]=($row[1])."<br>";

       $oFCKeditor->Value="$_array_nr[$z]" ;
       //$oFCKeditor->Create();
}

if ($_POST['Submit2']){
         $z=2+$pagesize*($pageval-1);
         $oFCKeditor->Value="$_array_nr[$z]" ;
}
if ($_POST['Submit3']){
        $z=3+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}
if ($_POST['Submit4']){
        $z=4+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit5']){
        $z=5+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}
if ($_POST['Submit6']){
        $z=6+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit7']){
        $z=7+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit8']){
        $z=8+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit9']){
        $z=9+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit10']){
        $z=10+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit11']){
        $z=11+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit12']){
        $z=12+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit13']){
        $z=13+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}


if ($_POST['Submit14']){
        $z=14+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit15']){
        $z=15+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}

if ($_POST['Submit16']){
        $z=16+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}
if ($_POST['Submit17']){
        $z=17+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}
if ($_POST['Submit18']){
        $z=18+$pagesize*($pageval-1);
$oFCKeditor->Value="$_array_nr[$z]" ;
}





if ($_POST['Submit0']){//修改保存

  echo $d = "fck内容".$_POST[pgy];
  echo $biaoti="标题：".$_POST[biaoti];
  echo "作者:".$_POST[textfield2];
       $db->fg_Update(houtaiguangli,title,xinwen,zuozhe,$id);
}



function diaoyon_submit(){

    echo "$row[$z]";


}

$sql =mysql_query ("SELECT * FROM `zhiliao`");
while($row=mysql_fetch_array($sql)){
    //echo $row;
    $b_array[1]=$row[uid];
    $b_array[2]=$row[jingpingwenzhang];
    $b_array[3]=$row[fatiezongshu];
    $b_array[4]=$row[zaixianshijian];
    $b_array[5]=$row[jifen];
    $b_array[10]=$row[jinbi];
    $b_array[6]=$row[haoyou];
    $b_array[7]=$row[paihang];
    $b_array[8]=$row[liuyan];
    $b_array[9]=$row[jibie];
    "<hr><b>".$row[1]." | ".$row[0];
   //print_r ("<hr><b>".$row[user]);
    }
//echo $name=$_GET['ver'] ;

?>
<style type="text/css">
<!--
.STYLE7 {color: #FF00FF}
-->
</style>
<form action="" method="POST">
<img src="D:\wamp\www\wenjian_class\柳州合影.jpg" width="100%" height="75" />
<table width="100%" border="1">
  <tr>
    <td height="15" align="center" valign="middle"><span class="STYLE10 STYLE3 STYLE7"><span class="STYLE3 STYLE7">日期：</span>
        <?php date_default_timezone_set('UTC');echo date('j-m-y'); ?>
    </span></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE3 STYLE7">发帖总数:</span><?php echo $b_array[3];?></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE7">金币：</span><?php echo $b_array[10];?></td>
    <td width="178" align="left" valign="middle"><span class="STYLE4 STYLE7">好友人数：</span><?php echo $b_array[6];?></td>
    <td width="231" align="center" valign="middle"><span class="STYLE7"><a href="http://www.hao123.com/">论谈首页</span></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE4 STYLE7">留言信息</span><?php echo $b_array[8];?></td>
  </tr>
  <tr>
    <td height="15" align="center" valign="middle"><p class="STYLE3 STYLE7"><a href="http://www.hao123.com/">精品文章</p><?php echo $b_array[1];?></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE12 STYLE3 STYLE7">在线时间</span><?php echo $b_array[4];?><span class="STYLE3 STYLE7">:</span></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE7">积分：</span><?php echo $b_array[5];?></td>
    <td height="15" align="left" valign="middle"><span class="STYLE3 STYLE7">作者ip:</span><?php echo $ip = getenv('REMOTE_ADDR');?></td>
    <td height="15" valign="middle"><span class="STYLE11 STYLE6 STYLE7">文章id:</span><?php echo $_array_id[$z];?></td>
    <td height="15" colspan="2" align="left" valign="middle"><span class="STYLE7">排行榜：</span><?php echo $b_array[7];?></td>
  </tr>
  <tr>
    <td height="30"align="center" valign="middle"><span class="STYLE7">新闻列表</span><?php echo "共 $num 条".
        " <a href=$url?page=".($pageval-1).">上一页</a> <a href=$url?page=".($pageval+1).">下一页</a>";?></td>

    <td height="30" colspan="3"align="center" valign="middle"><span class="STYLE11 STYLE6 STYLE7">会员级别:</span></td>
    <td height="35" colspan="5" align="left" valign="middle"><span class="STYLE7">标题：</span>
        <span class="STYLE7"><input name="biaoti" type="text" class="STYLE12" value="<?php echo $_array_bt[$z];?>" size="50">
        作者：</span>
        <span class="STYLE7"><input name="textfield2" type="text" class="STYLE12" value="<?php echo $_array_zz[$z];?>" size="10">
        </span></td>
  </tr>
  <tr>
    <td width="138" align="left" valign="middle" bgcolor="#EADFFF"><a href="http://www.chinagames.net/"><?php echo $_array_bt[1+$pagesize*($pageval-1)];?></a></td>
    <td width="67" height="15" align="center" valign="middle" bgcolor="#EADFFF"><input name="Submit1" type="submit" value="修改"></td>
    <td height="15" colspan="5" rowspan="18" align="center" valign="middle" bgcolor="#CCCCCC">
        <span class="STYLE7">
        <?php $oFCKeditor->Create();$oFCKeditor->Width= '50%' ;
        $oFCKeditor->Height= '100' ;?>
    </span></td>
    <td width="95" align="center" valign="middle"><span class="STYLE5 STYLE7"><a href="http://www.hao123.com">友情链接</span></td>
  </tr>
  <tr>
    <td align="falt" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[2+$pagesize*($pageval-1)];?></a>
    <td height="7" align="falt" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit2" value="修改">
    <script type="text/javascript"src="oncilk.js"></script>
    <a href="#"onclick ="funphp100('o')">o</a>
    <td align="laft" valign="middle"><a href="#"><span class="STYLE7"><input type="submit" name="Submit30" value="上一页"></a></td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[3+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit3" value="修改"></td>
    <td align="laft" valign="middle"><a href="#"><span class="STYLE7"><input type="submit" name="Submit31" value="下一页"></a></td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[4+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit4" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[5+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit5" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[6+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit6" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[7+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit7" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[8+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit8" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[9+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit9" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[10+$pagesize*($pageval-1)];?></a></td>
    <td height="6" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit10" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[11+$pagesize*($pageval-1)];?></td>
    <td height="7" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit11" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[12+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit12" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[13+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit13" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[14+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit14" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[15+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit15" value="修改"></td>
    <td align="laft" valign="middle"> </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[16+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit16" value="修改">
    <script type="text/javascript"src="oncilk.js"></script>
    <a href="#"onclick ="funphp100('o')">o</a>
    <div id="php100"></div>    </td>
    <td align="laft" valign="middle" bgcolor="#FF00FF"><input type="submit" name="sub" value="添加新闻"/></td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[17+$pagesize*($pageval-1)];?></a></td>
    <td height="15" align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit17" value="修改"></td>
    <td align="laft" valign="middle" bgcolor="#00FFFF"><input type="submit" name="Submit0" value="修改提交">

       </td>
  </tr>
  <tr>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><a href="http://www.hao123.com"><?php echo $_array_bt[18+$pagesize*($pageval-1)];?></a></td>
    <td align="laft" valign="middle" bgcolor="#EADFFF"><input type="submit" name="Submit18" value="修改"></td>
    <td align="laft" valign="middle" bgcolor="#FF0000"><input type="submit" name="Submit" value="删除文章"></td>
  </tr>
</table>
<p><img src="D:\wamp\www\wenjian_class\wenbu.jpg" width="100%" height="100" /></p>

<script type="text/javascript"src="ajax1.js"></script>
<a href="#"onclick ="funphp100('o')">o</a>

<input type="button"><a href="#">***</a>

顶你一下

支持一下。

上图片预览一下好点

好的
你也可以复制粘贴  放到自己的平台 也可以知道的

Fatal error: Cannot instantiate non-existent class: fckeditor in D:\usr\www\group\test.php on line 15
$oFCKeditor = new FCKeditor('pgy') ;

你可以把 html代码复制到你所用的编辑器 就可以看到整个网站的概貌了

后台图

不错哦 呵呵

学习了，太有才了

我是一个初学者 有什么不对 请指出 和帮助我一下

不错不错！

    

下载下来研究一下。。呵呵

偶也是初学都的说

  学习一下。  

26讲 自定义mysql_class 类

    

支持下，

初学者？太牛叉了

路过,,,帮顶...

  

  

  

  

恩，非常不错，谢谢了

    

恩 努力学习中。