function similar_doc($mat1) { $col_name = $mat1; $host = ""; // Host name $username = ""; // Mysql username $password = ""; // Mysql password $db_name = ""; // Database name $con = mysql_connect($host, $username, $password) or die(mysql_error()); mysql_select_db($db_name, $con) or die(mysql_error()); $doc1 = $col_name; $doc2 = "AaronPressman"; $doc3 = "AlanCrosby"; $doc4 = "AlexanderSmith"; $doc5 = "BenjaminKangLim"; $doc6 = "BernardHickey"; $doc7 = "BradDorfman"; $doc8 = "DarrenSchuettler"; $doc9 = "DavidLawder"; $var1 = doc_similarity($doc1, $doc2); $var2 = doc_similarity($doc1, $doc3); $var3 = doc_similarity($doc1, $doc4); $var4 = doc_similarity($doc1, $doc5); $var5 = doc_similarity($doc1, $doc6); $var6 = doc_similarity($doc1, $doc7); $var7 = doc_similarity($doc1, $doc8); $var8 = doc_similarity($doc1, $doc9); $sim_array = array(); $sorted_sim = array(); for ($i = 1; $i < 9; $i++) { $sim = ${'var' . $i}; array_push($sim_array, $sim); } $varnum = sort_resultarray($sim_array); $sim_col = ${'doc' . $varnum}; echo $sim_col; update_clusterhead($col_name, $sim_col); }
function query_similarity($mat1) { $arr1 = $mat1; $arr2 = array(); $sim_querydoc_array = array(); $query11 = "select count(column_name) from information_schema.columns where table_schema='test' and table_name='cluster_heads'"; $result11 = mysql_query($query11); $data11 = mysql_fetch_array($result11); $col_no = $data11[0]; for ($i = 3; $i <= $col_no; $i++) { $arr2 = array(); $query12 = "select column_name from information_schema.columns where ordinal_position='{$i}' and table_schema='test' and table_name='cluster_heads'"; $result12 = mysql_query($query12) or die(mysql_error()); $data12 = mysql_fetch_array($result12); $col = $data12['column_name']; $query = "select {$col} from cluster_heads"; $result = mysql_query($query) or die(mysql_error()); while ($data = mysql_fetch_array($result)) { array_push($arr2, $data[0]); } $dotproduct = 0; $sim_den1 = 0; $sim_den2 = 0; $sim_den = 0; for ($j = 0; $j < count($arr1); $j++) { $dotproduct = $dotproduct + $arr1[$j] * $arr2[$j]; $sim_den1 = $sim_den1 + $arr1[$j] * $arr1[$j]; $sim_den2 = $sim_den2 + $arr2[$j] * $arr2[$j]; } $sim_den1 = sqrt($sim_den1); echo "\n"; $sim_den2 = sqrt($sim_den2); echo "\n"; $sim_den = $sim_den1 + $sim_den2; $sim_num = $dotproduct; $sim = $sim_num / $sim_den; array_push($sim_querydoc_array, $sim); unset($arr2); } sort_resultarray($sim_querydoc_array, $arr1); }