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