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'];