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