Beispiel #1
0
        ?>
         <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 {