{
        session_start();
        if ($_SESSION['login_status'] == "" && $_SESSION['user'] == "") {
            header("Location:admin.php");
        } else {
            $this->show_info();
        }
    }
    public function show_info()
    {
        $dir = "http://duomeiti.sky31.com/multimedia/media/";
        $sql = "select * from media";
        $conn = new mysqli(HOST, UserName, PassWord, DataBase);
        if ($conn->connect_error) {
            die('数据库连接错误:' . $conn->connect_error);
        }
        $conn->query("set names UTF8");
        $result = $conn->query($sql);
        while ($row = $result->fetch_assoc()) {
            $filename1 = $row['school_no'] . ".mp3";
            $filename2 = $row['school_no'] . ".wav";
            echo "<tr>\n                <td>{$row['UserID']}</td>\n                <td>{$row['name']}</td>\n                <td>{$row['sex']}</td>\n                <td>{$row['school_no']}</td>\n                <td>{$row['mobile']}</td>\n                <td>{$row['school']}</td>\n                <td>{$row['qq']}</td>\n                <td>{$row['used']},{$row['other']}</td>\n                <td>{$row['interesting']}</td>\n                <td>{$row['learn']}</td>\n                <td>{$row['media_type']}</td>\n                <td><a href ={$dir}{$filename1}>mp3</a>&nbsp;&nbsp;<a href ={$dir}{$filename2} >wav</a></td>\n                <td><a href='sudo.php?action=del&UserID={$row['UserID']}' class='btn btn-primary btn-xs'>删除</a>&nbsp;&nbsp;&nbsp;<a href='sudo.php?action=pass&UserID={$row['UserID']}' class='btn btn-danger btn-xs'>录取</a>&nbsp;&nbsp;&nbsp;<a href='sudo.php?action=pending&UserID={$row['UserID']}' class='btn btn-warning btn-xs'>待定</a>&nbsp;&nbsp;&nbsp;<a href='sudo.php?action=die_out&UserID={$row['UserID']}' class='btn btn-success btn-xs'>淘汰</a></td>\n                <td>{$row['status']}</td>\n\n            </tr>\n\n\n            ";
        }
    }
}
$show = new manage();
$show->is_login();
echo " </table>\n    </div>\n</div>\n</div>\n<div class=\"row\">\n    <div class=\"col-md-12\">\n        <h6><font color=\"#3a87ad\">&copy; 2004-2015 多媒体</font></h6>\n    </div>\n</div>\n</div>\n</body>\n</html>";
?>