session_start();
if (!session_is_registered("LLC"))
{
// if session check fails, invoke error handler
header("Location: ../loginform.php");
exit();
}
$user = $_SESSION['UNAME'];
include("../include/dbconfig.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
mysql_select_db($db_name);
?>
Online Audio/Video Management
User List
print <<
Add |
User Name |
END;
$query = "SELECT UserName from MM_user";
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
Delete |
$row1[0] |
|
END;
}
$query = "SELECT count(*) from MM_user";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
|
Total: $row[0] |
END;
?>
Title List
print <<
Add |
Language |
Title Name |
END;
$query = "SELECT Language, Title from MM_titles";
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
Delete |
$row1[0] |
$row1[1] |
END;
}
$query = "SELECT count(*) from MM_titles";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
|
Total: |
$row[0] |
END;
?>
|