--- a/heuristics/metadataHeuristics.php +++ b/heuristics/metadataHeuristics.php @@ -1,7 +1,7 @@ 1 order by count */ /*- duplicated description @@ -14,8 +14,8 @@ $averageDuplicatedDescriptions = getAverageDuplicatedDescriptions(); $stddevDuplicatedDescriptions = getstddevDuplicatedDescriptions(); $query = 'select count(*) from contractnotice where description = "' . $agencyName . '"'; - $result = mysql_query($query); - $r = mysql_fetch_array($result, MYSQL_BOTH); + $result = $conn->query($query); + $r = $result->fetch(PDO::FETCH_BOTH); $dupeDesc = $r[0]; if ($dupeDesc == 1) $value = 0; else $value = abs($dupeDesc - $averageDuplicatedDescriptions) / $stddevDuplicatedDescriptions; @@ -48,11 +48,11 @@ { $query = "select avg(count),STDDEV(count) from ( SELECT description, count(*) as count -FROM `contractnotice` +FROM contractnotice group by description having count > 1 ) as a;"; - $result = mysql_query($query); - $r = mysql_fetch_array($result, MYSQL_BOTH); + $result = $conn->query($query); + $r = $result->fetch(PDO::FETCH_BOTH); $averageDuplicatedDescriptions = $r[0]; $stddevDuplicatedDescriptions = $r[1]; }