Example #1
0
 public static function storePage(Page $page, $rootUrl)
 {
     $mysqli = self::connect();
     $query = "INSERT INTO news_retriever_page (date, title, siteroot, pageurl, content) VALUES(?,?,?,?,?)";
     $statement = $mysqli->prepare($query);
     $date = $page->getDate()->format('Y-m-d');
     $title = $page->getTitle();
     $content = $page->getPageAsHtml();
     $statement->bind_param('sssss', $date, $title, $rootUrl, $page->getPageUrl(), $content);
     $statement->execute();
     $mysqli->close();
 }