{ 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> <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> <a href='sudo.php?action=pass&UserID={$row['UserID']}' class='btn btn-danger btn-xs'>录取</a> <a href='sudo.php?action=pending&UserID={$row['UserID']}' class='btn btn-warning btn-xs'>待定</a> <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\">© 2004-2015 多媒体</font></h6>\n </div>\n</div>\n</div>\n</body>\n</html>"; ?>