function select($id)
{
$db = new DBconnect();
$conn = $db->open();
$sql = "select * from news where id = " . $id;
$result = mysql_query($sql, $conn);
$row = mysql_fetch_array($result);
$arr = array('id' => $row['id'], 'typeid' => $row['typeid'], 'title' => $row['title'], 'content' => $row['content'], 'time' => $row['time']);
mysql_free_result($result);
//释放结果集
$db->close($conn);
return $arr;
}
function update($id, $rid, $title, $editer, $image, $time)
{
$db = new DBconnect();
$msg = "";
$conn = $db->open();
$sql = "update lzu_st_news set rid='{$rid}',title='{$title}',editer='{$editer}',image='{$image}',time='{$time}' where id=" . $id;
if (mysql_query($sql, $conn)) {
$msg = "任务更新成功";
} else {
$msg = "任务更新失败";
}
$db->close($conn);
return $msg;
}
<?php
/*
*/
include 'admin/dbconnect.php';
include 'smarty_init.php';
//从数据库中取出相关信息
$dbconnect = new DBconnect();
$conn = $dbconnect->open();
//显示
$sql = "select * from lzu_st_news order by id desc ";
$res = mysql_query($sql, $conn);
$i = 1;
if (mysql_num_rows($res) > 0) {
while ($row = mysql_fetch_array($res)) {
if ($row['rid'] == 0) {
$t0[$i]['title'] = $row['title'];
$t0[$i]['time'] = $row['time'];
$t0[$i]['id'] = $row['id'];
$i++;
continue;
}
if ($row['rid'] == 1) {
$t1[$i]['title'] = $row['title'];
$t1[$i]['time'] = $row['time'];
$t1[$i]['id'] = $row['id'];
$i++;
continue;
}
if ($row['rid'] == 2) {
$t2[$i]['title'] = $row['title'];
