<?php
include 'dbconnect.php';
set_time_limit(0);
$arow = 6468;
$match = 'No Match';
$prcode = 'O233';
$conn = dbconnect();
$sql = "SELECT * FROM investigator i where i.FK_Award in (SELECT a.FK_rootTag FROM programelement pe ,award a WHERE pe.FK_award = a.FK_rootTag and pe.code = '" . $prcode . "')";
$result = $conn->query($sql);
$citysql = 'SELECT * FROM institution WHERE FK_Award = ' . $arow;
$cresult = $conn->query($citysql);
$crowcount = mysqli_num_rows($cresult);
$row = $cresult->fetch_assoc();
$citysim = lev($row["CityName"], 'Urbana');
if ($citysim < 0.4) {
$match = $row["CityName"] . ' Affiliation City match';
}
echo $match;
}
}
// Compare affiliation cities if still no match found
if ($match == 'No Match') {
// echo '-- In No Match if --';
$awa = $arow["FK_Award"];
$conn = dbconnect();
$citysql = 'SELECT * FROM institution WHERE FK_Award = ' . $awa;
$cresult = $conn->query($citysql);
$crow = $cresult->fetch_assoc();
// echo $crow["CityName"];
// echo $author['affiliation-current']['affiliation-city'];
$cname = $crow["CityName"];
$cname_scopus = $author['affiliation-current']['affiliation-city'];
if (!empty($cname) && !empty($cname_scopus)) {
$citysim = lev(strtolower($cname), strtolower($cname_scopus));
if ($citysim < 0.4) {
$match = $auid . ' - Affiliation City Match';
}
}
mysqli_close($conn);
}
}
}
// Print results of matching
if ($match != 'No Match') {
$mcount++;
}
echo '<br/>NSF Author Name : ' . $arow["FirstName"] . " " . $arow["LastName"];
echo '<br/>Scopus Author ID : ' . $match . '<br/>';
}
