求按照CI框架分离html页面
在网上找了一个移序的功能，但是代码是php、mysql、html混搭的，现在用的是CI框架，刚接触框架不久，不会分离，请各位帮忙照着CI框架的模式分离这个页面
数据库页面：class_moder.php
处理页面：admin.php
html页面：sort.html
<br /> <br /> <br /> <br /><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <br /><title>实现新闻的上移下移功能</title> <br /> <br /> <br /><body> <br /><style> <br />*{font-size:12px;} <br />td{height:24px; line-height:24px; text-align:center} <br /></style> <br /> <br /><?php <br />header("Content-type:text/html;charset=gb2312"); <br />include("<p>5本文来源gao!daima.com搞$代!码#网#</p><pre>搞代gaodaima码
mysql.class.php”);
$conn=new mysql(“localhost”,”root”,”root”,”test”,” “,”gbk”);
if(!emptyempty($_GET[“weight”])){
if($_GET[“move”]==”up”){
//获取上一条新闻信息
$query=$conn->query(“select * from `article` where `weight` > ‘$_GET[weight]’ order by `weight` asc limit 1”);
if($conn->db_num_rows(query)>0){
$rows=$conn->fetch_array($query);
$conn->query(“update `article` set `weight`=’$rows[weight]’ where `weight`=’$_GET[weight]'”);
$conn->query(“update `article` set `weight`=’$_GET[weight]’ where `ID`=’$rows[ID]'”);
}else{
echo “<script>alert(‘已经在最顶上’);</script>”;
}
}else if($_GET[“move”]==”down”){
//获取下一条新闻信息
$query=$conn->query(“select * from `article` where `weight` < '$_GET[weight]' order by `weight` desc limit 1");
if($conn->db_num_rows(query)>0){
$rows=$conn->fetch_array($query);
$conn->query(“update `article` set `weight`=’$rows[weight]’ where `weight`=’$_GET[weight]'”);
$conn->query(“update `article` set `weight`=’$_GET[weight]’ where `ID`=’$rows[ID]'”);
}else{
echo “<script>alert(‘已经在最底下’);</script>”;
}
}
}
?>
| ID | 标题 | 移动 |
