Ejemplo n.º 1
0
 private static function storeAssociation(AssocRule $rule)
 {
     $mysqli = self::connect();
     $query = "INSERT INTO p2000_news_assoc (p2000Id, newsId, date, score, " . "supportP2000, supportNews, supportTotal, confP2000, confNews, lift) " . "VALUES(?,?,?,?,?,?,?,?,?,?)";
     $statement = $mysqli->prepare($query);
     $p2000id = $rule->getP2000id();
     $newsId = $rule->getNewsId();
     $date = "";
     if ($rule->getDate()) {
         $date = $rule->getDate()->format("Y-m-d");
     }
     $score = $rule->getScore();
     $supportP2000 = $rule->getP2000Support();
     $supportNews = $rule->getNewsSupport();
     $supportTotal = $rule->getTotalSupport();
     $confP2000 = $rule->getConfidenceLeft();
     $confNews = $rule->getConfidenceRight();
     $lift = $rule->getLift();
     $statement->bind_param('iisddddddd', $p2000id, $newsId, $date, $score, $supportP2000, $supportNews, $supportTotal, $confP2000, $confNews, $lift);
     $statement->execute();
     $mysqli->close();
 }