<?php
include '../config.php';
date_default_timezone_set("America/New_York");
$con = Config::databaseConnection();
$videos = array();
$arguments = 'sort=top&t=week';
$json = file_get_contents('http://www.reddit.com/r/listentothis/top/.json?' . $arguments);
$obj = json_decode($json);
foreach ($obj->data->children as $single) {
if (strpos($single->data->domain, 'youtube') !== false) {
$ar = preg_split('/embed/', $single->data->secure_media->oembed->html);
$ar = preg_split('/\\//', $ar[1]);
$ar = preg_split('/\\?/', $ar[1]);
array_push($videos, $ar[0]);
}
}
foreach ($videos as $video) {
$sql = "INSERT INTO discovered (link) SELECT '" . $video . "' FROM DUAL WHERE NOT EXISTS (SELECT * FROM discovered WHERE link='" . $video . "')";
if (mysqli_query($con, $sql)) {
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
exit;
}
}
echo "Content Updated: " . count($videos) . " videos found.";
