'arc2', 'db_user' => 'arc2', 'db_pwd' => 'arc2', /* store */ 'store_name' => 'arc_tests', /* stop after 100 errors */ 'max_errors' => 100, ); $store = ARC2::getStore($config); if ($store) { echo "Connected to ARC2 database
\n"; } if (!$store->isSetUp()) { $store->setUp(); } $config_dbpedia = array( /* remote endpoint */ 'remote_store_endpoint' => 'http://dbpedia.org/sparql' ); $store_dbpedia = ARC2::getRemoteStore($config_dbpedia); if ($store_dbpedia) { echo "Connected to DBPedia database
\n"; } echo ""; $q = ' PREFIX foaf: . SELECT ?name ?person ?workplace WHERE { foaf:knows ?person . ?person foaf:workplaceHomepage ?workplace . OPTIONAL {?person foaf:name ?name } }'; if ($rows = $store->query($q, 'rows')) { foreach ($rows as $row) { // from workplace homepage to map $image = ''; $url = parse_url($row['workplace']); $host = $url['host']; $dbpediaQuery = createQuery("http://" . $host. "/"); //echo $dbpediaQuery . '
\n'; $image = ''; if ($rows1 = $store_dbpedia->query($dbpediaQuery, 'rows')) { foreach ($rows1 as $row1) { if ( $row1['lat'] != '' & $row1['long'] != '' ) { $image = makeMap($row1['lat'], $row1['long'], $googleMapKey); break; } } } echo ''; } } echo "

' . $row['name'] . ' ' . $row['person'] . ' ' . $row['workplace'] . '

' . $image .'

"; function makeMap ($lat, $long, $key) { $image = ""; return $image; } function createQuery($website){ return 'PREFIX rdfs: PREFIX type: PREFIX prop: PREFIX ont: PREFIX foaf: PREFIX geo: SELECT DISTINCT ?label ?lat ?long WHERE { { {?resource prop:website <'. $website .'>.} UNION {?resource foaf:homepage <'. $website . '>} } { {?resource ont:location ?location. OPTIONAL {?location geo:lat ?lat. ?location geo:long ?long.} OPTIONAL {?location rdfs:label ?label.} } UNION {?subject prop:employer ?resource} UNION {?subject prop:institution ?resource} UNION {?subject prop:workInstitution ?resource} UNION {?subject prop:workInstitutions ?resource} UNION {?subject prop:workplaces ?resource} UNION {?subject ont:occupation ?resource} OPTIONAL {?resource geo:lat ?lat. ?resource geo:long ?long.} OPTIONAL {?resource rdfs:label ?label.} }}'; } ?>