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;
}
$i++;
continue;
} else {
if ($row['rid'] == 2) {
$do[$i]['title'] = $row['title'];
$do[$i]['starttime'] = $row['starttime'];
$do[$i]['stoptime'] = $row['stoptime'];
$do[$i]['user'] = $row['user'];
$do[$i]['id'] = $row['id'];
$i++;
continue;
} else {
if ($row['rid'] == 1) {
$tasklist[$i]['title'] = $row['title'];
$tasklist[$i]['starttime'] = $row['starttime'];
$tasklist[$i]['stoptime'] = $row['stoptime'];
$tasklist[$i]['id'] = $row['id'];
$i++;
}
}
}
}
}
$smarty->assign('do', $do);
$smarty->assign('need', $need);
$smarty->assign('tasklist', $tasklist);
$smarty->display('backdisplay.html');
}
//关闭连接
$dbconnect->close($conn);
