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(); }