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