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);