<tr class="head"> <td align="center" height="22">视频列表</td> </tr> <tr><td> <table width=100% cellspacing="1" cellpadding="3"> <tr align="center"> <td class="td2" width="6%">ID</td> <td class="td2">视频标题</td> <td class="td2" width="20%">视频地址</td> <td class="td2" width="20%">添加日期</td> <td class="td2" width="4%">删除</td> </tr> <?php $page = $page ? (intval($page) - 1) * 10 : 0; $sql = "SELECT * FROM `video` LIMIT {$page},10"; $totalpage = my_count('video'); $pagelist = my_page($totalpage, 10, 10, 3, 'video_manager.php'); $query = $db->query($sql); while ($result = $db->fetch_array($query)) { echo '<tr align="center" class="b"><td>' . $result['id'] . '</td><td>' . $result['title'] . '</td><td><a href="' . $result['url'] . '">' . $result['url'] . '</a></td><td>' . $result['date'] . '</td><td><a onclick="return confirm(\'删除会连同其图片一起删除,确定?\')" href="?action=del&id=' . $result['id'] . '">删除</a></td>'; } ?> </table></td></tr> <tr><td align="center"><?php echo $pagelist['page_str']; ?> </td></tr> </table> <br /> <form method="post" name="link" id="link" action="video_manager.php?action=save" enctype="multipart/form-data"> <table class="tableborder2" cellspacing="1" cellpadding="4" width="99%" align="center" >
<td class="td2" width="7%">编辑</td> <td class="td2" width="4%">选取</td> </tr> <?php $sql = "SELECT uid,username,xingming,gender,dengji FROM `cdb_members`"; if (empty($dengji)) { $sql1 = ""; } else { $sql1 = "`dengji` = {$dengji} AND"; } if (empty($name)) { $totalpage = my_count('cdb_members'); } else { $keyword = $name; $sql1 .= " WHERE {$sql1} username LIKE '%{$keyword}%'"; $totalpage = my_count('cdb_members', "{$sql1}"); $sql .= $sql1; } $pagelist = my_page($totalpage, 15, 15, 3, 'member_manager.php'); $page = $_GET['page'] ? ($_GET['page'] - 1) * 15 : 0; $sql .= " ORDER BY uid DESC LIMIT {$page},15"; //echo $sql; $query = $db->query($sql); while ($result = $db->fetch_array($query)) { switch ($result['gender']) { case 0: $result['gender'] = "女性"; break; case 1: $result['gender'] = "男性"; break;