<?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/>'; }