session_start();
if (!$_SESSION["username"]) {
$url = $_SERVER['REQUEST_URI'];
echo "<meta http-equiv=\"refresh\" content=\"0;url=Login.php?url={$url}\">";
}
require 'UserPlaylists.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Add Playists</title>
</head>
<body>
<?php
if (isset($_POST['submit'])) {
$ip = getRealIpAddr();
$p_id = addPlaylist($_POST["title"]);
}
?>
<div class='form' >
<form method="POST" action="" enctype="multipart/form-data">
<br/>Playlist Name:
<input type='text' class="tb" name='title'/><input type="submit" class="button" name="submit" value="Create"/>
</form>
</div>
</body>
</html>
//CREATED TRIGGER FOR THESE QUERIES INSTEAD
// if($stmt->prepare("SELECT `p_id` FROM `Playlists` WHERE `p_name` = ?")) {
// $stmt->bind_param("s", $p_name);
// $stmt->execute();
// $stmt->bind_result($p_id);
// while($stmt->fetch()) {
// echo("2: " . $p_name);
// }
// }
// if($stmt->prepare("INSERT INTO `Creates`(`Username`, `p_id`, `p_name`) VALUES (?, ?, ?)")) {
// $stmt->bind_param('sss', $user, $p_id, $p_name);
// $user = $uName;
// $stmt->execute();
// //$stmt->bind_result($title, $name, $s_id);
// while($stmt->fetch()) {
// echo("3: " . $p_name);
// }
// }
if ($stmt->prepare("UPDATE `Creates` SET `Username` = ? WHERE Username = p_id")) {
$stmt->bind_param('s', $uName);
$stmt->execute();
$stmt->bind_result();
}
}
$p_name = $_GET['p_name'];
addPlaylist($p_name);
if ($_SESSION['loggedin'] == 'admin') {
header('Location: http://plato.cs.virginia.edu/~ams5da/ListenUp/adminPlaylists.html');
} else {
header('Location: http://plato.cs.virginia.edu/~ams5da/ListenUp/Home.html');
}
<?php
// configuration
require "../includes/config.php";
require "../includes/mediaService.php";
$db = new mysql_db(SERVER, USERNAME, PASSWORD, DATABASE);
$username = $_SESSION["username"];
if (isset($_POST["playlist"])) {
$playlistname = $_POST["playlist"];
addPlaylist($playlistname, $username);
}
$playlists = showPlaylists($username);
render("playlist_template.php", ["title" => "playlist", "playlists" => $playlists]);
$db->sql_close();
?>
function addPage($link, $name, $description)
{
$link = "playlist/" . $link;
$title = $name . " Playlist";
$page = new page();
$page->addPage($link, $title, $description, "Switch", "VideoChunk");
}
if (isset($_GET['name']) && isset($_GET['link']) && isset($_GET['status']) && isset($_GET['autoPlaylist']) && isset($_GET['description'])) {
$name = $_GET['name'];
$link = $_GET['link'];
$status = $_GET['status'];
$autoPlaylist = $_GET['autoPlaylist'];
$description = $_GET['description'];
$db = new db();
$db->connect();
$id = addPlaylist($name, $link, $status);
addAutoPlaylist($autoPlaylist, $id);
addPage($link, $name, $description);
mysql_close();
exit;
}
?>
<!DOCTYPE html>
<html>
<head>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
function submit(){
var name = $("#input-name").val();
var link = $("#input-link").val();
var status = $("#input-status").val();
