Example #1
0
                continue;
            }
            $statement = $db->prepare(SQL_UPDATE_CHANNELS);
            $statement->execute(array($this->channel_title, $this->channel_description, $this->channel_keywords, $channel["id"]));
            $statement->execute();
        }
    }
    function main_videos()
    {
        $db = $this->get_db();
        $statement = $db->prepare(SQL_SELECT_VIDEOS);
        $statement->execute();
        $videos = $statement->fetchAll(PDO::FETCH_ASSOC);
        foreach ($videos as $video) {
            $this->video_id = $video["nicoVideoId"];
            $this->video_title = null;
            $this->video_description = null;
            $this->get_video_thumb();
            var_dump(array("title" => $this->video_title, "description" => $this->video_description));
            if (is_null($this->video_title) || is_null($this->video_description)) {
                continue;
            }
            $statement = $db->prepare(SQL_UPDATE_VIDEOS);
            $statement->execute(array($this->video_title, $this->video_description, $video["id"]));
            $statement->execute();
        }
    }
}
$meta = new Meta();
$meta->main_channels();
$meta->main_videos();