/** * @param $fenyePage */ function getFenyePage($fenyePage) { $sqlhelper = new SqlHelper(); $sql1 = "select * from emp limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize; echo "当前页:" . $fenyePage->pageNow . "<br/>"; echo $sql1; $sql2 = "select count(id) from emp"; $sqlhelper->exectue_dql_fenye($sql1, $sql2, $fenyePage); $sqlhelper->close_conn(); }
public function checkAdmin($id, $password) { $sql = "select password,name from admin where id={$id}"; $sqlhelper = new SqlHelper(); $res = $sqlhelper->execute_dql($sql); if ($row = mysqli_fetch_assoc($res)) { if (md5($password) == $row['password']) { return true; } } mysqli_free_result($res); $sqlhelper->close_conn(); return false; }