foreach ($res as $r) {
switch ($_GET['action']) {
case 'imdb':
$mov = json_decode(file_get_contents('http://www.omdbapi.com/?i=' . $r['imdb']));
$query = 'UPDATE movies SET
genres = "' . $mov->Genre . '",
directors = "' . $mov->Director . '",
writers = "' . $mov->Writer . '",
actors = "' . $mov->Actors . '",
poster = "' . $mov->Poster . '",
length = "' . (int) $mov->Runtime . '",
mpaa = "' . $mov->Rated . '"
WHERE id = ' . $r['id'];
//$query = 'UPDATE movies SET mpaa = "'. $mov->Rated .'" WHERE id = '.$r['id'];
$query = 'UPDATE movies SET category = "movie" WHERE category = "feature"';
if ($db->dc($query)) {
echo $mov->Title . '<br>';
}
break;
case 'index':
$tech = array();
//sound, three_d
if (!empty($r['sound'])) {
$tech[] = $r['sound'];
}
if (!empty($r['3d'])) {
$tech[] = '3D';
}
$media = array();
//bluray, dvd, digital
if (!empty($r['bluray'])) {
<?php
include '../../db/db.php';
$db = new Database();
switch ($_POST['action']) {
case 'delete':
echo $db->dc('DELETE FROM comments WHERE id=' . $_POST['id']) ? 'true' : 'false';
break;
case 'approve':
$query = 'UPDATE comments SET
status="approved",
comment="' . $_POST['comment'] . '"
WHERE id=' . $_POST['id'];
echo $db->dc($query) ? 'true' : 'false';
break;
}
include '../../db/db.php';
$db = new Database();
$url = $db->prepURL($_POST['title']);
$status = $_POST['submit'] == 'Publish' ? 'published' : 'saved';
switch ($_POST['action']) {
case 'insert':
$query = 'INSERT INTO blog
(title, url, article, color, to_edges, film, timestamp, status) VALUES (?, ?, ?, ?, ?, ?, ?, "' . $status . '")';
$params = array($_POST['title'], $url, $_POST['blogpost'], $_POST['color'], $_POST['to_edges'], $_POST['film'], $_POST['timestamp']);
break;
case 'update':
$query = 'UPDATE blog SET
title=?,
url=?,
article=?,
color=?,
to_edges=?,
film=?,
timestamp=?,
status = "' . $status . '"
WHERE id =' . $_POST['id'];
$params = array($_POST['title'], $url, $_POST['blogpost'], $_POST['color'], $_POST['to_edges'], $_POST['film'], $_POST['timestamp']);
break;
case 'delete':
$db->dc('DELETE FROM blog WHERE id=' . $_POST['id']);
break;
}
if ($db->dcParams($query, $params)) {
header('Location: rssgenerator.php');
exit;
}
