include "class.title.php"; include "{$_SERVER['DOCUMENT_ROOT']}/phase5/db/tvguruDB.php"; try { $con = new PDO(DB_CONNECTION_STRING, DB_USER, DB_PWD); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo $e->getMessage(); } if (isset($_POST['favorite'])) { switch ($_POST['favorite']) { case 'Favorite': favorite(); break; case 'Unfavorite': unfavorite(); break; } } if (isset($_POST['comment'])) { postComment($_POST['comment']); } $title = new Title(); function favorite() { session_start(); global $con; try { $sql = "UPDATE `users` SET `favorites` = CONCAT(`favorites`, :title) WHERE `users`.`username` = :name"; $sql = $con->prepare($sql); $title = $_SESSION['title'] . ",";
$servername = "okenso.com"; $username = "******"; $password = "******"; $dbname = "dev"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $error = false; $error_message = ""; $data = json_decode(file_get_contents('php://input'), true); $user = $data["username"]; $pid = $data["pid"]; $channelname = $data["channelname"]; $channelowner = $data["channelowner"]; unfavorite($conn, $user, $pid, $channelname, $channelowner); $conn->close(); $response = array('error' => $error, 'error_message' => $error_message, 'channelname' => $channelname, 'channelowner' => $channelowner, 'pid' => $pid); echo json_encode($response); function unfavorite($conn, $user, $pid, $channelname, $channelowner) { global $error, $error_message; $stmt = $conn->prepare("DELETE FROM users_fav_posts WHERE ufp_username=? AND ufp_chname=? AND ufp_chowner=? AND ufp_number=?"); $stmt->bind_param("sssi", $user, $channelname, $channelowner, $pid); $stmt->execute(); $stmt->close(); } ?>