?> <div class="bb-item"> <div class="bb-custom-side"> <div class="wrap"> <?php echo "Name:" . $_SESSION['FullName']; ?> <br> <?php echo "Publication:" . extractPublicationName($_SESSION['SearchResults'][$count]); ?> <br> <?php echo "Page Number:" . extractPageNumber($_SESSION['SearchResults'][$count]); ?> <br> <?php echo "Description:" . $_SESSION['SearchDescriptions'][$count]; ?> <br> <?php echo "Type:" . $_SESSION['SearchTypes'][$count]; ?> <br> </div> </div> <?php //$count++;
<li><a href="ChoosePublicationToView.php">View Publications</a></li> <li><a href="importFile.php">Import Yearbook</a></li> <li>About</li> </ul> <!--Banner and navigation bar !--> </div> <?php if ($_SESSION['part'] == 3) { $beginPath = "C:\\MAMP\\htdocs\\GusNicholsArchives\\"; $permanentPath = "uploads\\" . $_SESSION['name'] . "\\"; foreach (glob($beginPath . $permanentPath . "*.jpg", GLOB_NOSORT) as $imagePath) { $imageName = basename($imagePath); //echo $imageName; $DBPath = $permanentPath . $imageName; $pageNum = extractPageNumber($imageName); //echo $pageNum; $stmt = $pdo->prepare("SELECT PageId FROM Page WHERE PageNumber=? AND Publication_PublicationId=?"); $stmt->execute(array($pageNum, $_SESSION['publicationId'])); $pageId = $stmt->fetchColumn(); //echo "pageId: " . $pageId; if ($pageId) { echo $pageNum . ":" . $pageId . "<br />"; $sql = $pdo->prepare("UPDATE Page SET ImagePath=? WHERE PageId=?"); try { $sql->execute(array($DBPath, $pageId)); // echo "Page ".$pageNum."imported <br />"; } catch (PDOException $e) { echo 'Error: ' . $e->getMessage(); } } else {