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