/** * Inserts data into the biblio table * @param $data * @return int last insterted id if succesefull */ function alreadyInDB($title, $author, $publication) { $biblioQ = new BiblioQuery(); $biblioQ->connect(); if (!$biblioQ->validateBiblio($title, $author, $publication)) { $sql = "select bibid from biblio where strcmp(title,'" . $title . "')=0"; $qShowStatusResult = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($qShowStatusResult); return $row["bibid"]; } return 0; }
require_once "../classes/Biblio.php"; require_once "../classes/BiblioQuery.php"; require_once "../classes/Localize.php"; $loc = new Localize(OBIB_LOCALE, $tab); if (isset($_GET["bibid"])) { unset($_SESSION["postVars"]); unset($_SESSION["pageErrors"]); #**************************************************************************** #* Retrieving get var #**************************************************************************** $bibid = $_GET["bibid"]; #**************************************************************************** #* Search database #**************************************************************************** $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } if (!($biblio = $biblioQ->doQuery($bibid))) { $biblioQ->close(); displayErrorPage($biblioQ); } foreach ($biblio->getBiblioFields() as $value) { $value->setFieldid(''); } #************************************************************************** #* load up post vars #************************************************************************** include "biblio_post_conversion.php";
echo '<th>' . $loc->getText("MarcUploadData") . '</th>'; echo '</tr>'; foreach ($biblio->getBiblioFields() as $field) { echo '<tr><td>' . H($field->getTag()) . '</td>'; echo '<td>' . H($field->getSubfieldCd()) . '</td>'; echo '<td>' . H($field->getFieldData()) . '</td></tr>'; } echo '</table>'; } echo '<hr /><h3>' . $loc->getText("MarcUploadRawData") . '</h3>'; echo '<pre>'; readfile($_FILES["usmarc_data"]["tmp_name"]); echo '</pre>'; } else { $bq = new BiblioQuery(); $bq->connect(); if ($bq->errorOccurred()) { $bq->close(); displayErrorPage($bq); } foreach ($biblios as $biblio) { if (!$bq->insert($biblio)) { $bq->close(); displayErrorPage($bq); } } $bq->close(); echo $loc->getText("MarcUploadRecordsUploaded"); echo ": " . H(count($biblios)); } include "../shared/footer.php";
function insertBiblio($biblio) { require_once "../classes/BiblioQuery.php"; $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } $bibid = $biblioQ->insert($biblio); if (!$bibid) { $biblioQ->close(); displayErrorPage($biblioQ); } $biblioQ->close(); return $bibid; }
function updateBiblio($biblio) { require_once "../classes/BiblioQuery.php"; $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); displayErrorPage($biblioQ); } if (!$biblioQ->update($biblio)) { $biblioQ->close(); displayErrorPage($biblioQ); } $biblioQ->close(); }
function _insertBiblio($biblio) { require_once "BiblioQuery.php"; $biblioQ = new BiblioQuery(); $biblioQ->connect(); if ($biblioQ->errorOccurred()) { $biblioQ->close(); return false; } $bibid = $biblioQ->insert($biblio); if (!$bibid) { $biblioQ->close(); return false; } $biblioQ->close(); return $bibid; }