$placeFromArchive = $placeFromWeb; $countWebDownloads++; } } } elseif ($place->getty) { $placeFromArchive = $archiveGetty->getByGetty($place->getty); if ($placeFromArchive == NULL) { $placeFromWeb = $archiveGetty->makeEntryFromGetty($place->getty); if ($placeFromWeb) { $archiveGetty->insertEntryIfNew('getty', $place->getty, $placeFromWeb); $placeFromArchive = $placeFromWeb; $countWebDownloads++; } } } else { $placeFromArchive = $archiveGeoNames->getByName($searchName); } if ($placeFromArchive) { $place->geoData['lat'] = $placeFromArchive->lat; $place->geoData['long'] = $placeFromArchive->long; } elseif ($testUnidentified == 0) { $unidentifiedPlaces[] = $searchName; } } } } $archiveGeoNames->saveToFile('geoNames'); $archiveGetty->saveToFile('getty'); $archiveGND->saveToFile('gnd'); $serialize = serialize($data); file_put_contents($_SESSION['folderName'] . '/dataPHP', $serialize);
function load_data_liddel($server, $user, $password, $database, $table) { $db = new mysqli($server, $user, $password, $database); $db->set_charset("utf8"); if (mysqli_connect_errno()) { die('Konnte keine Verbindung zur Datenbank aufbauen: ' . mysqli_connect_error() . '(' . mysqli_connect_errno() . ')'); } $archive = new GeoDataArchive(); $archive->loadFromFile(); $translatePlaces = array('Görlitz (Dresden)' => 'Görlitz', 'Middleburg' => 'Middelburg', 'Neustadt an der Haardt' => 'Neustadt an der Weinstraße'); if ($result = $db->query('SELECT * FROM ' . $table)) { $dataArray = array(); while ($rowBooks = $result->fetch_assoc()) { $rowBooks = array_map('trim', $rowBooks); $thisBook = new item(); $thisBook->id = $rowBooks['system_no']; //$thisBook->itemInVolume = getItemInVolume($rowBooks['nr']); $thisBook->bibliographicalLevel = 'copy'; $thisBook->titleBib = htmlspecialchars($rowBooks['title']); $thisBook->publisher = htmlspecialchars($rowBooks['printer']); $thisBook->year = $rowBooks['date']; $thisBook->subject = $rowBooks['subject']; $thisBook->mediaType = 'Book'; $thisBook->originalItem['institutionOriginal'] = 'Aberdeen, Sir Duncan Rice Library'; $thisBook->originalItem['shelfmarkOriginal'] = $rowBooks['shelfmark']; $thisBook->originalItem['targetOPAC'] = 'https://aulib.abdn.ac.uk/F?func=direct&local_base=ABN01&doc_number={ID}'; $thisBook->originalItem['searchID'] = $rowBooks['system_no']; $thisBook->language = explode(';', $rowBooks['language']); $placeName = $rowBooks['place_ger']; if ($placeName == '') { $placeName = $rowBooks['place']; } $placeName = strtr($placeName, $translatePlaces); $placeNameSearch = $placeName; if ($placeNameSearch == 'Frankfurt' or $placeNameSearch == 'Frankfurt am Main') { $placeNameSearch = 'Frankfurt/M.'; $placeName = 'Frankfurt am Main'; } elseif ($placeNameSearch == 'Frankfurt an der Oder' or $placeNameSearch == 'Frankfurt (Oder)') { $placeNameSearch = 'Frankfurt/O.'; } $place = new place(); $place->placeName = $placeName; $placeFromArchive = $archive->getByName($placeNameSearch); if ($placeFromArchive) { $place->geoData['lat'] = $placeFromArchive->lat; $place->geoData['long'] = $placeFromArchive->long; } $thisBook->places[] = $place; if (preg_match('~VD[ ]?(1[67]) (.+)~', $rowBooks['vd'], $matches)) { $thisBook->manifestation['systemManifestation'] = 'VD' . $matches[1]; $thisBook->manifestation['idManifestation'] = $matches[2]; } elseif ($rowBooks['retrieve_from'] == 'GBV') { $thisBook->manifestation['systemManifestation'] = 'GBV'; $thisBook->manifestation['idManifestation'] = $rowBooks['ppn']; } if ($rowBooks['author'] != '') { $person = new person(); $person->persName = $rowBooks['author']; if ($rowBooks['gnd']) { if ($resultAuthor = $db->query('SELECT * FROM liddel_authority WHERE gnd_aut LIKE "' . $rowBooks['gnd'] . '"')) { $rowPerson = $resultAuthor->fetch_assoc(); $person->persName = $rowPerson['name_de']; if ($person->persName == '') { $person->persName = $rowPerson['name_en']; } $person->gnd = $rowPerson['gnd_aut']; } } $thisBook->persons[] = $person; } if ($resultDigi = $db->query('SELECT * FROM liddel_library_digi WHERE id_print LIKE ' . $rowBooks['id'])) { while ($rowDigi = $resultDigi->fetch_assoc()) { $thisBook->digitalCopy = $rowDigi['value']; } } $dataArray[] = $thisBook; } } foreach ($dataArray as $item) { foreach ($item->persons as $person) { $person->perName = replaceArrowBrackets($person->persName); } } return $dataArray; }